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
general query tuning By: mjschwenger on Sun, 19 March 2006	7	4458	Wed, 22 March 2006 15:11 By: mjschwenger
A myth of TKPROF output in Oracle 10.1.0.4 By: tphan_au on Tue, 07 March 2006	3	2840	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	1704	Mon, 20 March 2006 06:34 By: Maaher
Function index By: panatisudhakar on Sat, 18 March 2006	3	3023	Mon, 20 March 2006 05:08 By: JSI2001
bitmap index on unstable column By: a_developer on Thu, 16 March 2006	4	2724	Sat, 18 March 2006 21:51 By: a_developer
Transaction never fails ..where By: jagjeet.malhi on Sat, 18 March 2006	0	3765	Sat, 18 March 2006 07:21 By: jagjeet.malhi
Difference in Execution timing By: feroze on Fri, 17 March 2006	1	1480	Sat, 18 March 2006 00:52 By: Frank
Log File Sync By: amitsingla on Fri, 17 March 2006	3	2534	Fri, 17 March 2006 04:56 By: alanm
Interpreting tkprof By: sophieharris on Sun, 12 March 2006	4	10120	Thu, 16 March 2006 15:42 By: sophieharris
operation timed out By: vasudevan on Thu, 16 March 2006	3	1925	Thu, 16 March 2006 15:30 By: Mahesh Rajendran
Materialized view vs Table By: a_developer on Tue, 14 March 2006	2	5932	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	3827	Thu, 16 March 2006 09:29 By: deadpoet
Difference in location of the hint By: a_developer on Tue, 14 March 2006	2	1801	Wed, 15 March 2006 06:45 By: a_developer
Numeric or Alphanumeric datatype By: gajini on Mon, 13 March 2006	1	2014	Tue, 14 March 2006 02:32 By: rleishman
Partitioned to Composite Partitioned By: a_developer on Sat, 11 March 2006	2	1799	Mon, 13 March 2006 12:45 By: a_developer
parallel hint/execution By: a_developer on Fri, 10 March 2006	2	3768	Sun, 12 March 2006 16:16 By: a_developer
Oracle 8 rebuild index By: marco118 on Thu, 09 March 2006	4	6775	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	4186	Fri, 10 March 2006 08:38 By: sach_sumit
MERGE INTO with a hint By: a_developer on Thu, 09 March 2006	4	19475	Fri, 10 March 2006 00:19 By: a_developer
When to rebuild indexes ... By: tridentadm on Thu, 09 March 2006	0	4992	Thu, 09 March 2006 23:40 By: tridentadm
number of rows per db block By: srhl on Thu, 09 March 2006	2	2068	Thu, 09 March 2006 21:10 By: srhl
Index Monitoring By: faiz_hyd on Thu, 02 March 2006	5	5269	Thu, 09 March 2006 10:07 By: faiz_hyd
Query to select users connected By: MoleyHarey on Thu, 09 March 2006	1	3939	Thu, 09 March 2006 06:13 By: Mahesh Rajendran
best way to create an index By: a_developer on Wed, 08 March 2006	1	1843	Thu, 09 March 2006 00:47 By: rleishman
help for not equal and index usage By: mjschwenger on Mon, 06 March 2006	4	2342	Wed, 08 March 2006 15:10 By: mjschwenger
Sort and hash area size problem By: sach_sumit on Tue, 07 March 2006	1	4398	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	5713	Wed, 08 March 2006 08:48 By: Mahesh Rajendran
Please tune this Query By: hsinghalmrt on Tue, 07 March 2006	8	3428	Wed, 08 March 2006 06:56 By: JSI2001
Statpack report By: rc_ashish on Sat, 05 November 2005	6	7581	Wed, 08 March 2006 06:21 By: Mahesh Rajendran
please help me ->cpu id 0 By: rzmni on Tue, 07 March 2006	0	3485	Tue, 07 March 2006 21:42 By: rzmni
Performance tuning of Oracle 8i By: Vamshee on Tue, 07 March 2006	6	3879	Tue, 07 March 2006 12:38 By: Mahesh Rajendran
Query Optimisation By: mhjoshi on Tue, 07 March 2006	2	1754	Tue, 07 March 2006 07:12 By: JSI2001
ORDER BY CLAUSE By: rvnair123 on Tue, 07 March 2006	3	3990	Tue, 07 March 2006 05:27 By: Frank
Tuning Buffer Hit Ratio on Oracle 8i By: Vamshee on Mon, 06 March 2006	2	2204	Mon, 06 March 2006 13:44 By: Vamshee
log waits By: toshidas2000 on Mon, 06 March 2006	0	3967	Mon, 06 March 2006 13:10 By: toshidas2000
ORA-024012: PLAN_TABLE not found By: Brayan on Thu, 02 February 2006	4	14423	Mon, 06 March 2006 05:22 By: samidc
Index not being used in Query By: samidc on Mon, 06 March 2006	2	2123	Mon, 06 March 2006 02:08 By: Mahesh Rajendran
Bulk Collect in Oracle 8i By: mohit.arora79 on Fri, 03 March 2006	2	3502	Fri, 03 March 2006 05:57 By: rleishman
library cache latch By: aline on Thu, 02 March 2006	1	4989	Thu, 02 March 2006 13:42 By: mchadder
SELECT doubt By: frank.svs on Thu, 02 March 2006	1	1921	Thu, 02 March 2006 09:58 By: Barbara Boehmer