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
Simple SQL with High Concurrency Wait Time (cursor: pin S wait on X) Oracle 10gR2 on AIX 6.1 By: eclipsis on Fri, 05 August 2011	18	16481	Tue, 09 August 2011 06:46 By: LNossov
Application slow Oracle 11.1.0.7.0, Unix-HP By: Smith14 on Sun, 07 August 2011	4	4064	Sun, 07 August 2011 12:20 By: Michel Cadot
PERFORMANCE TUNING By: shashank_kurasrediffmail on Sat, 06 August 2011	1	3224	Sat, 06 August 2011 10:02 By: Michel Cadot
How to reduce the consistent gets of this sql Oracle 10.2.0.4.0 64bit , AIX 5.3 ( 1 2) By: snowball on Mon, 27 June 2011	72	13280	Wed, 03 August 2011 20:34 By: snowball
enq: TS - contention 10.2.0.4 By: varunvir on Tue, 26 July 2011	14	35132	Mon, 01 August 2011 07:27 By: LNossov
PERFORMANCE HIT DUE TO NVL FUNCTION Oracle 9i By: Fasy on Fri, 29 July 2011	1	3477	Fri, 29 July 2011 07:34 By: Michel Cadot
BitMap Index Issue By: abdulrahaman288 on Thu, 21 July 2011	6	3898	Mon, 25 July 2011 22:00 By: rleishman
query optimization oracle 10gR2 , Suse Enterprise Linux By: mr_wee on Thu, 21 July 2011	16	5099	Mon, 25 July 2011 01:18 By: michael_bialik
big table partitioning oracle 10gR2 By: mr_wee on Tue, 28 June 2011	15	6404	Sun, 24 July 2011 03:49 By: mr_wee
delete statement taking forever 10.2.0.3 By: varunvir on Wed, 20 July 2011	14	5727	Fri, 22 July 2011 13:18 By: varunvir
Sql Query comsuming time oracle 11g, Window 2003 Server By: pradies on Fri, 15 July 2011	5	3784	Thu, 21 July 2011 02:42 By: MicroJoey
Performance Tuning SQL Queries Oracle 11i Queries By: petersdj on Tue, 19 July 2011	2	4513	Tue, 19 July 2011 11:24 By: cookiemonster
DBMS_UTILITY GET_TIME By: rakesh1503 on Tue, 19 July 2011	9	5258	Tue, 19 July 2011 04:31 By: cookiemonster
How can i force a sql use index range scan 11.2.0.1.0 Windos XP By: andy huang on Fri, 15 July 2011	10	5006	Mon, 18 July 2011 03:33 By: cookiemonster
Data dictionary Cache - dc_objects Oracle 10g By: Rags123 on Mon, 04 July 2011	27	7938	Sat, 16 July 2011 00:49 By: LNossov
Precise I3 vs. OEM Grid 9i/10g/11g By: Kevin Meade on Fri, 15 July 2011	0	6453	Fri, 15 July 2011 09:15 By: Kevin Meade
SYSAUX Tablespace Oracle 10g/Windows XP By: gxeon on Thu, 14 July 2011	3	5498	Fri, 15 July 2011 03:06 By: Michel Cadot
Query Optimization Help - Date-Range Matching results in MERGE JOIN CARTESIAN Oracle 10gR2 (10.2.0.4) By: rasa on Mon, 11 July 2011	10	4612	Thu, 14 July 2011 09:39 By: rasa
alter table.. shrink space command hanging.. Sun OS, 10.2.0.3.0 By: lg123 on Wed, 13 July 2011	2	4960	Thu, 14 July 2011 02:33 By: John Watson
Wait Stats Oracle 10g/Windows By: gxeon on Mon, 11 July 2011	4	4175	Wed, 13 July 2011 22:24 By: hkchital
NVL is degraing performance, any alternative By: goparaju on Mon, 04 July 2011	9	7293	Wed, 13 July 2011 02:37 By: LNossov
Help SQL Tuning Oracle 10.2.0.1 on Suse 10 By: nqtrung on Mon, 11 July 2011	13	4725	Wed, 13 July 2011 02:32 By: Michel Cadot
Reg Segment advisor Oracle 10g By: sathik on Mon, 11 July 2011	20	7211	Tue, 12 July 2011 09:58 By: hkchital
Sol req : Alternative way of rewriting the query Oracle 10gr2 By: ganeshkn21 on Wed, 06 July 2011	8	3589	Fri, 08 July 2011 05:59 By: Michel Cadot
query optimization oracle 10g By: prashant_ora on Thu, 07 July 2011	13	7360	Fri, 08 July 2011 05:51 By: LNossov
Delete stmt taking so much time oracle By: shyamu544 on Thu, 07 July 2011	28	5743	Thu, 07 July 2011 09:40 By: cookiemonster
Become DB import too slow after server reboot Oracle 10G, Solaris 10 By: Tlg13team on Mon, 04 July 2011	11	10034	Thu, 07 July 2011 04:38 By: LNossov
Query taking more time Oracle 10g R2 By: raj9999 on Tue, 14 June 2011	15	7060	Wed, 06 July 2011 08:54 By: Kevin Meade
problem with outlines #2 By: piotrtal on Tue, 05 July 2011	19	6447	Tue, 05 July 2011 10:17 By: LNossov
Solution req :Performance issue with partitioned table Oracle 10gR2 By: ganeshkn21 on Tue, 05 July 2011	3	2923	Tue, 05 July 2011 06:34 By: cookiemonster
Typical Question of Query Performance By: Manoj.Gupta.91 on Tue, 05 July 2011	3	2812	Tue, 05 July 2011 05:24 By: Roachcoach
Query doing FTS on a big table Oracle 10g 10.2.0.4.0 on AIX 5.3 By: raj9999 on Fri, 24 June 2011	10	3695	Tue, 05 July 2011 04:46 By: michael_bialik
problem with outlines By: piotrtal on Thu, 30 June 2011	26	6139	Mon, 04 July 2011 10:32 By: cookiemonster
how to clear cache for testing tuned code oracle 11g r2 By: gogol_1987 on Mon, 04 July 2011	4	3924	Mon, 04 July 2011 04:25 By: gogol_1987
Performance Tuning in Oracle 10g during Migration - Heavy Insert Optimization Oracle 10g By: ajexpert on Tue, 15 April 2008	27	13848	Sun, 03 July 2011 23:27 By: Michel Cadot
How to measure the sql run time? Oracle 10.2.0.4.0 64bit , AIX 5.3 By: snowball on Sun, 26 June 2011	12	6168	Sun, 03 July 2011 16:11 By: LNossov
SQL tuning By: hannah00 on Thu, 09 June 2011	22	6067	Sat, 02 July 2011 01:25 By: Kevin Meade
Performance Standard Edition without partitioning Oracle 11g - RHEL 5 By: pbaldanta on Thu, 16 June 2011	2	2518	Sat, 02 July 2011 01:05 By: Kevin Meade
Oracle hash join Oracle 9i By: dushan_st on Thu, 23 June 2011	21	27391	Sat, 02 July 2011 00:26 By: Kevin Meade
AWR Report network foreground wait events 11.1.0.7.0, Linux By: kavitagoel00 on Wed, 29 June 2011	8	15140	Thu, 30 June 2011 17:15 By: BlackSwan