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
Problem with insert statements sharing in shared pool By: sach_sumit on Fri, 10 March 2006	0	3180	Fri, 10 March 2006 08:38 By: sach_sumit
MERGE INTO with a hint By: a_developer on Thu, 09 March 2006	4	15718	Fri, 10 March 2006 00:19 By: a_developer
When to rebuild indexes ... By: tridentadm on Thu, 09 March 2006	0	3948	Thu, 09 March 2006 23:40 By: tridentadm
number of rows per db block By: srhl on Thu, 09 March 2006	2	1035	Thu, 09 March 2006 21:10 By: srhl
Index Monitoring By: faiz_hyd on Thu, 02 March 2006	5	4106	Thu, 09 March 2006 10:07 By: faiz_hyd
Query to select users connected By: MoleyHarey on Thu, 09 March 2006	1	2948	Thu, 09 March 2006 06:13 By: Mahesh Rajendran
best way to create an index By: a_developer on Wed, 08 March 2006	1	866	Thu, 09 March 2006 00:47 By: rleishman
help for not equal and index usage By: mjschwenger on Mon, 06 March 2006	4	1368	Wed, 08 March 2006 15:10 By: mjschwenger
Sort and hash area size problem By: sach_sumit on Tue, 07 March 2006	1	3436	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	4365	Wed, 08 March 2006 08:48 By: Mahesh Rajendran
Please tune this Query By: hsinghalmrt on Tue, 07 March 2006	8	1211	Wed, 08 March 2006 06:56 By: JSI2001
Statpack report By: rc_ashish on Sat, 05 November 2005	6	5820	Wed, 08 March 2006 06:21 By: Mahesh Rajendran
please help me ->cpu id 0 By: rzmni on Tue, 07 March 2006	0	2712	Tue, 07 March 2006 21:42 By: rzmni
Performance tuning of Oracle 8i By: Vamshee on Tue, 07 March 2006	6	2632	Tue, 07 March 2006 12:38 By: Mahesh Rajendran
Query Optimisation By: mhjoshi on Tue, 07 March 2006	2	858	Tue, 07 March 2006 07:12 By: JSI2001
ORDER BY CLAUSE By: rvnair123 on Tue, 07 March 2006	3	2753	Tue, 07 March 2006 05:27 By: Frank
Tuning Buffer Hit Ratio on Oracle 8i By: Vamshee on Mon, 06 March 2006	2	1218	Mon, 06 March 2006 13:44 By: Vamshee
log waits By: toshidas2000 on Mon, 06 March 2006	0	2890	Mon, 06 March 2006 13:10 By: toshidas2000
ORA-024012: PLAN_TABLE not found By: Brayan on Thu, 02 February 2006	4	12592	Mon, 06 March 2006 05:22 By: samidc
Index not being used in Query By: samidc on Mon, 06 March 2006	2	821	Mon, 06 March 2006 02:08 By: Mahesh Rajendran
Bulk Collect in Oracle 8i By: mohit.arora79 on Fri, 03 March 2006	2	2272	Fri, 03 March 2006 05:57 By: rleishman
library cache latch By: aline on Thu, 02 March 2006	1	4039	Thu, 02 March 2006 13:42 By: mchadder
SELECT doubt By: frank.svs on Thu, 02 March 2006	1	796	Thu, 02 March 2006 09:58 By: Barbara Boehmer
Execution Plan doubt By: frank.svs on Thu, 02 March 2006	2	3187	Thu, 02 March 2006 06:00 By: frank.svs
Statistic By: zoltanp on Wed, 01 March 2006	1	1130	Wed, 01 March 2006 09:55 By: Mahesh Rajendran
what are the steps to follow to coalesce By: pnvani on Tue, 28 February 2006	14	2389	Wed, 01 March 2006 07:58 By: Mahesh Rajendran
Visual Explain By: theo06 on Thu, 23 February 2006	2	963	Fri, 24 February 2006 05:10 By: suryaevl
formula for value of INITIAL By: quytc on Wed, 22 February 2006	0	2759	Wed, 22 February 2006 20:40 By: quytc
Attempt to de-mystify DBMS_STATS ( Any Takers ? ) By: Navin Prabhu on Mon, 20 February 2006	3	1629	Tue, 21 February 2006 07:53 By: smartin
Unique constraint versus unique index By: mjschwenger on Mon, 20 February 2006	3	2717	Tue, 21 February 2006 04:57 By: Mahesh Rajendran
Analyze Table By: vikashbansal on Mon, 20 February 2006	3	1713	Tue, 21 February 2006 04:17 By: Mahesh Rajendran
fragmented tables and indexes By: uv_anil on Mon, 20 February 2006	1	3256	Mon, 20 February 2006 10:13 By: Mahesh Rajendran
Generate the execution plan for a stored procedure !! By: AlinaC on Sun, 19 February 2006	1	895	Sun, 19 February 2006 20:14 By: rleishman
help with outer join By: mjschwenger on Thu, 16 February 2006	3	1407	Sun, 19 February 2006 17:39 By: mjschwenger
how to set DB_BLOCK_SIZE??????help meeeeeee...... By: quytc on Thu, 16 February 2006	9	5005	Fri, 17 February 2006 22:52 By: rleishman
Slow query performance... By: loveoracle on Fri, 17 February 2006	4	1324	Fri, 17 February 2006 22:37 By: rleishman
Commit time format in retention table By: arado196 on Thu, 16 February 2006	2	1207	Fri, 17 February 2006 04:54 By: arado196
functional index and bind variable problem By: uv_anil on Fri, 17 February 2006	1	1906	Fri, 17 February 2006 01:43 By: rleishman
Why Merge Cartesian Join By: mjschwenger on Wed, 15 February 2006	5	13875	Fri, 17 February 2006 01:26 By: rleishman
No data in v$sql_plan for SELECT By: piotrgrz on Thu, 16 February 2006	0	4235	Thu, 16 February 2006 10:42 By: piotrgrz