|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Partitioning Table |
2 |
1720 |
Mon, 10 April 2006 08:48 By: faiz_hyd ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Problem ORA-04031 was solved and spfile changed. |
2 |
2466 |
Mon, 10 April 2006 07:45 By: kmsalih ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
error in SPreport output |
1 |
3118 |
Sun, 09 April 2006 23:55 By: vraman3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
List vs Range Partitioning |
7 |
7599 |
Sun, 09 April 2006 23:07 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
about PCT in mv_capabilities_table. |
1 |
2068 |
Sat, 08 April 2006 19:29 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Database speed up By: amkotz on Sat, 08 April 2006 |
3 |
1332 |
Sat, 08 April 2006 06:32 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
migrating SYS from DICT to LOCAL |
3 |
1324 |
Sat, 08 April 2006 04:18 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance Tuning Tool |
1 |
1468 |
Fri, 07 April 2006 03:55 By: madhusunkara ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Is it Oracle 10g slower comparatively Oracle 9i |
1 |
1446 |
Fri, 07 April 2006 03:50 By: madhusunkara ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
slow connection to oracle 8 server with oracle 9 client |
1 |
1639 |
Wed, 05 April 2006 07:21 By: mustafat ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
"db file scattered read" too high and Query going for full table scan-Why ? |
4 |
2198 |
Tue, 04 April 2006 18:11 By: RaeMarvin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
gather_fixed_objects_stats By: orant1 on Mon, 03 April 2006 |
1 |
4060 |
Mon, 03 April 2006 06:36 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Clearing Blocks from Memory |
4 |
2233 |
Mon, 03 April 2006 04:43 By: madhusunkara ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Speed Slow. |
3 |
1970 |
Mon, 03 April 2006 03:22 By: nmacdannald ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Merge Cartesian Join in Plan and More Reads |
1 |
1555 |
Fri, 31 March 2006 22:49 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
generic SGA |
1 |
1465 |
Fri, 31 March 2006 05:59 By: Frank Naude ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Use of 1 Cpu insted of 2 on Oracle 10 G By: luchot on Tue, 28 March 2006 |
2 |
1244 |
Fri, 31 March 2006 02:30 By: luchot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Can anyone do the guidance to learn Performance Tuning? |
2 |
1586 |
Fri, 31 March 2006 01:22 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
resolving buffer busy waits |
2 |
1872 |
Fri, 31 March 2006 00:43 By: madhusunkara ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How I can Eliminate the Full Table scan for the following query? |
1 |
1423 |
Fri, 31 March 2006 00:37 By: madhusunkara ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Partition & Performance |
6 |
2376 |
Thu, 30 March 2006 21:32 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Balanced Decision on Index Creation |
11 |
2816 |
Wed, 29 March 2006 04:11 By: JSI2001 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Question about PERFSTAT Tablespace By: Uwe on Wed, 29 March 2006 |
3 |
3346 |
Wed, 29 March 2006 03:15 By: Frank ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
oracle solaris tuning kernel |
3 |
2930 |
Wed, 29 March 2006 00:07 By: madhusunkara ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Global and Local Index |
1 |
1440 |
Mon, 27 March 2006 22:17 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Materialized View Based on a Union Query |
1 |
1710 |
Mon, 27 March 2006 22:14 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Different Plan for Inner and Outer Query By: feroze on Wed, 22 March 2006 |
5 |
2113 |
Mon, 27 March 2006 00:16 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
information about indexes By: kinjal on Thu, 23 March 2006 |
7 |
2873 |
Sun, 26 March 2006 22:33 By: tarundua ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How increase SGA more than 25% of physical memory |
1 |
1427 |
Sun, 26 March 2006 16:16 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQLTRACE AND DB_FILE_SEQUENTIAL_READ |
9 |
6119 |
Sat, 25 March 2006 08:56 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Function taking very long to execute |
1 |
1273 |
Sat, 25 March 2006 05:37 By: Frank ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
help!!->resolving "cpu time" problem By: rzmni on Wed, 08 March 2006 |
1 |
1414 |
Sat, 25 March 2006 01:03 By: Frank Naude ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
where is UGA stored ?? |
1 |
1263 |
Fri, 24 March 2006 06:02 By: amit_nanote ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Merge-Update vs Normal Update |
1 |
1299 |
Fri, 24 March 2006 00:18 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Table scan in only 1 of many partitions? |
2 |
1404 |
Thu, 23 March 2006 17:18 By: kulickd ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
TUNING HIGH DISK READ By: feroze on Fri, 10 March 2006 |
5 |
2282 |
Thu, 23 March 2006 09:49 By: feroze ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Tablespace Fragmentation !! By: AlinaC on Thu, 23 March 2006 |
6 |
6218 |
Thu, 23 March 2006 07:07 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
tablespace By: manns on Tue, 21 March 2006 |
5 |
1936 |
Thu, 23 March 2006 03:41 By: Frank ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
general query tuning |
7 |
3595 |
Wed, 22 March 2006 15:11 By: mjschwenger ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
A myth of TKPROF output in Oracle 10.1.0.4 |
3 |
2140 |
Mon, 20 March 2006 22:25 By: Art Metzer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |