|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance for Full table scan ( Huge data ) |
5 |
2422 |
Tue, 11 April 2006 02: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) |
|
Partitioning Table |
2 |
1874 |
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 |
2623 |
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 |
3254 |
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 |
7810 |
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 |
2208 |
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 |
1489 |
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 |
1468 |
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 |
1594 |
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 |
1601 |
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 |
1798 |
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 |
2373 |
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 |
4193 |
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 |
2402 |
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 |
2107 |
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 |
1702 |
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 |
1599 |
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 |
1396 |
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 |
1747 |
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 |
2043 |
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 |
1544 |
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 |
2565 |
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 |
3034 |
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 |
3492 |
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 |
3069 |
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 |
1566 |
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 |
1850 |
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 |
2259 |
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 |
3030 |
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 |
1546 |
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 |
6271 |
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 |
1408 |
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 |
1554 |
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 |
1396 |
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 |
1428 |
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 |
1563 |
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 |
2426 |
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 |
6383 |
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 |
2094 |
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 |
3761 |
Wed, 22 March 2006 15:11 By: mjschwenger ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |