OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Truncation of Queries in Statspack Report By: ajay_gupta_dr on Mon, 20 March 2006	1	1244	Mon, 20 March 2006 06:34 By: Maaher
Function index By: panatisudhakar on Sat, 18 March 2006	3	2391	Mon, 20 March 2006 05:08 By: JSI2001
bitmap index on unstable column By: a_developer on Thu, 16 March 2006	4	2171	Sat, 18 March 2006 21:51 By: a_developer
Transaction never fails ..where By: jagjeet.malhi on Sat, 18 March 2006	0	3225	Sat, 18 March 2006 07:21 By: jagjeet.malhi
Difference in Execution timing By: feroze on Fri, 17 March 2006	1	1102	Sat, 18 March 2006 00:52 By: Frank
Log File Sync By: amitsingla on Fri, 17 March 2006	3	1593	Fri, 17 March 2006 04:56 By: alanm
Interpreting tkprof By: sophieharris on Sun, 12 March 2006	4	8993	Thu, 16 March 2006 15:42 By: sophieharris
operation timed out By: vasudevan on Thu, 16 March 2006	3	1252	Thu, 16 March 2006 15:30 By: Mahesh Rajendran
Materialized view vs Table By: a_developer on Tue, 14 March 2006	2	5223	Thu, 16 March 2006 09:32 By: croK
Oracle 8.1.7.0 - How to find BIND Variable values ? By: deadpoet on Thu, 16 March 2006	0	3408	Thu, 16 March 2006 09:29 By: deadpoet
Difference in location of the hint By: a_developer on Tue, 14 March 2006	2	1370	Wed, 15 March 2006 06:45 By: a_developer
Numeric or Alphanumeric datatype By: gajini on Mon, 13 March 2006	1	1487	Tue, 14 March 2006 02:32 By: rleishman
Partitioned to Composite Partitioned By: a_developer on Sat, 11 March 2006	2	1365	Mon, 13 March 2006 12:45 By: a_developer
parallel hint/execution By: a_developer on Fri, 10 March 2006	2	3363	Sun, 12 March 2006 16:16 By: a_developer
Oracle 8 rebuild index By: marco118 on Thu, 09 March 2006	4	5981	Fri, 10 March 2006 19:22 By: rleishman
Problem with insert statements sharing in shared pool By: sach_sumit on Fri, 10 March 2006	0	3648	Fri, 10 March 2006 08:38 By: sach_sumit
MERGE INTO with a hint By: a_developer on Thu, 09 March 2006	4	18301	Fri, 10 March 2006 00:19 By: a_developer
When to rebuild indexes ... By: tridentadm on Thu, 09 March 2006	0	4419	Thu, 09 March 2006 23:40 By: tridentadm
number of rows per db block By: srhl on Thu, 09 March 2006	2	1510	Thu, 09 March 2006 21:10 By: srhl
Index Monitoring By: faiz_hyd on Thu, 02 March 2006	5	4769	Thu, 09 March 2006 10:07 By: faiz_hyd
Query to select users connected By: MoleyHarey on Thu, 09 March 2006	1	3475	Thu, 09 March 2006 06:13 By: Mahesh Rajendran
best way to create an index By: a_developer on Wed, 08 March 2006	1	1360	Thu, 09 March 2006 00:47 By: rleishman
help for not equal and index usage By: mjschwenger on Mon, 06 March 2006	4	1925	Wed, 08 March 2006 15:10 By: mjschwenger
Sort and hash area size problem By: sach_sumit on Tue, 07 March 2006	1	3962	Wed, 08 March 2006 09:41 By: aciolac
Wait event 'db file sequential read' on TABLE segment By: tphan_au on Tue, 07 March 2006	1	4849	Wed, 08 March 2006 08:48 By: Mahesh Rajendran
Please tune this Query By: hsinghalmrt on Tue, 07 March 2006	8	1803	Wed, 08 March 2006 06:56 By: JSI2001
Statpack report By: rc_ashish on Sat, 05 November 2005	6	6270	Wed, 08 March 2006 06:21 By: Mahesh Rajendran
please help me ->cpu id 0 By: rzmni on Tue, 07 March 2006	0	3117	Tue, 07 March 2006 21:42 By: rzmni
Performance tuning of Oracle 8i By: Vamshee on Tue, 07 March 2006	6	3117	Tue, 07 March 2006 12:38 By: Mahesh Rajendran
Query Optimisation By: mhjoshi on Tue, 07 March 2006	2	1285	Tue, 07 March 2006 07:12 By: JSI2001
ORDER BY CLAUSE By: rvnair123 on Tue, 07 March 2006	3	3213	Tue, 07 March 2006 05:27 By: Frank
Tuning Buffer Hit Ratio on Oracle 8i By: Vamshee on Mon, 06 March 2006	2	1642	Mon, 06 March 2006 13:44 By: Vamshee
log waits By: toshidas2000 on Mon, 06 March 2006	0	3341	Mon, 06 March 2006 13:10 By: toshidas2000
ORA-024012: PLAN_TABLE not found By: Brayan on Thu, 02 February 2006	4	13382	Mon, 06 March 2006 05:22 By: samidc
Index not being used in Query By: samidc on Mon, 06 March 2006	2	1229	Mon, 06 March 2006 02:08 By: Mahesh Rajendran
Bulk Collect in Oracle 8i By: mohit.arora79 on Fri, 03 March 2006	2	2772	Fri, 03 March 2006 05:57 By: rleishman
library cache latch By: aline on Thu, 02 March 2006	1	4483	Thu, 02 March 2006 13:42 By: mchadder
SELECT doubt By: frank.svs on Thu, 02 March 2006	1	1202	Thu, 02 March 2006 09:58 By: Barbara Boehmer
Execution Plan doubt By: frank.svs on Thu, 02 March 2006	2	3631	Thu, 02 March 2006 06:00 By: frank.svs
Statistic By: zoltanp on Wed, 01 March 2006	1	1504	Wed, 01 March 2006 09:55 By: Mahesh Rajendran