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
A myth of TKPROF output in Oracle 10.1.0.4 By: tphan_au on Tue, 07 March 2006	3	2319	Mon, 20 March 2006 22:25 By: Art Metzer
Truncation of Queries in Statspack Report By: ajay_gupta_dr on Mon, 20 March 2006	1	1556	Mon, 20 March 2006 06:34 By: Maaher
Function index By: panatisudhakar on Sat, 18 March 2006	3	2751	Mon, 20 March 2006 05:08 By: JSI2001
bitmap index on unstable column By: a_developer on Thu, 16 March 2006	4	2537	Sat, 18 March 2006 21:51 By: a_developer
Transaction never fails ..where By: jagjeet.malhi on Sat, 18 March 2006	0	3550	Sat, 18 March 2006 07:21 By: jagjeet.malhi
Difference in Execution timing By: feroze on Fri, 17 March 2006	1	1439	Sat, 18 March 2006 00:52 By: Frank
Log File Sync By: amitsingla on Fri, 17 March 2006	3	1930	Fri, 17 March 2006 04:56 By: alanm
Interpreting tkprof By: sophieharris on Sun, 12 March 2006	4	9406	Thu, 16 March 2006 15:42 By: sophieharris
operation timed out By: vasudevan on Thu, 16 March 2006	3	1612	Thu, 16 March 2006 15:30 By: Mahesh Rajendran
Materialized view vs Table By: a_developer on Tue, 14 March 2006	2	5578	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	3752	Thu, 16 March 2006 09:29 By: deadpoet
Difference in location of the hint By: a_developer on Tue, 14 March 2006	2	1729	Wed, 15 March 2006 06:45 By: a_developer
Numeric or Alphanumeric datatype By: gajini on Mon, 13 March 2006	1	1820	Tue, 14 March 2006 02:32 By: rleishman
Partitioned to Composite Partitioned By: a_developer on Sat, 11 March 2006	2	1716	Mon, 13 March 2006 12:45 By: a_developer
parallel hint/execution By: a_developer on Fri, 10 March 2006	2	3703	Sun, 12 March 2006 16:16 By: a_developer
Oracle 8 rebuild index By: marco118 on Thu, 09 March 2006	4	6340	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	3985	Fri, 10 March 2006 08:38 By: sach_sumit
MERGE INTO with a hint By: a_developer on Thu, 09 March 2006	4	19165	Fri, 10 March 2006 00:19 By: a_developer
When to rebuild indexes ... By: tridentadm on Thu, 09 March 2006	0	4752	Thu, 09 March 2006 23:40 By: tridentadm
number of rows per db block By: srhl on Thu, 09 March 2006	2	1874	Thu, 09 March 2006 21:10 By: srhl
Index Monitoring By: faiz_hyd on Thu, 02 March 2006	5	5177	Thu, 09 March 2006 10:07 By: faiz_hyd
Query to select users connected By: MoleyHarey on Thu, 09 March 2006	1	3903	Thu, 09 March 2006 06:13 By: Mahesh Rajendran
best way to create an index By: a_developer on Wed, 08 March 2006	1	1695	Thu, 09 March 2006 00:47 By: rleishman
help for not equal and index usage By: mjschwenger on Mon, 06 March 2006	4	2275	Wed, 08 March 2006 15:10 By: mjschwenger
Sort and hash area size problem By: sach_sumit on Tue, 07 March 2006	1	4324	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	5231	Wed, 08 March 2006 08:48 By: Mahesh Rajendran
Please tune this Query By: hsinghalmrt on Tue, 07 March 2006	8	2180	Wed, 08 March 2006 06:56 By: JSI2001
Statpack report By: rc_ashish on Sat, 05 November 2005	6	6604	Wed, 08 March 2006 06:21 By: Mahesh Rajendran
please help me ->cpu id 0 By: rzmni on Tue, 07 March 2006	0	3412	Tue, 07 March 2006 21:42 By: rzmni
Performance tuning of Oracle 8i By: Vamshee on Tue, 07 March 2006	6	3462	Tue, 07 March 2006 12:38 By: Mahesh Rajendran
Query Optimisation By: mhjoshi on Tue, 07 March 2006	2	1591	Tue, 07 March 2006 07:12 By: JSI2001
ORDER BY CLAUSE By: rvnair123 on Tue, 07 March 2006	3	3531	Tue, 07 March 2006 05:27 By: Frank
Tuning Buffer Hit Ratio on Oracle 8i By: Vamshee on Mon, 06 March 2006	2	1940	Mon, 06 March 2006 13:44 By: Vamshee
log waits By: toshidas2000 on Mon, 06 March 2006	0	3642	Mon, 06 March 2006 13:10 By: toshidas2000
ORA-024012: PLAN_TABLE not found By: Brayan on Thu, 02 February 2006	4	13768	Mon, 06 March 2006 05:22 By: samidc
Index not being used in Query By: samidc on Mon, 06 March 2006	2	1551	Mon, 06 March 2006 02:08 By: Mahesh Rajendran
Bulk Collect in Oracle 8i By: mohit.arora79 on Fri, 03 March 2006	2	3097	Fri, 03 March 2006 05:57 By: rleishman
library cache latch By: aline on Thu, 02 March 2006	1	4799	Thu, 02 March 2006 13:42 By: mchadder
SELECT doubt By: frank.svs on Thu, 02 March 2006	1	1505	Thu, 02 March 2006 09:58 By: Barbara Boehmer
Execution Plan doubt By: frank.svs on Thu, 02 March 2006	2	3972	Thu, 02 March 2006 06:00 By: frank.svs