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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
How we can find %age completion of query when is in running status Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit By: msol25 on Wed, 02 May 2012	35	1253	Sat, 05 May 2012 06:38 By: martijn
How we can check count for each partition Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit By: msol25 on Wed, 02 May 2012	12	2063	Wed, 02 May 2012 22:22 By: BlackSwan
Achieve same execution plan Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Mon, 30 April 2012	9	812	Wed, 02 May 2012 09:46 By: LNossov
How to change the execution order Oracle,11g,AIX By: vattigunta on Wed, 02 May 2012	3	1031	Wed, 02 May 2012 08:30 By: cookiemonster
Gather statistics on SYS objects Oracle 11.2.0.2.0. Sun OS By: Jack14 on Wed, 07 March 2012	4	1286	Sun, 29 April 2012 11:15 By: Jack14
Query Running for a long time in Second Schema Oracle 11G By: gan.chowdary on Fri, 27 April 2012	2	615	Sat, 28 April 2012 19:14 By: rleishman
Stale statistics for table Oracle 11g,Linux By: pokhraj_d on Fri, 27 April 2012	3	8132	Fri, 27 April 2012 22:51 By: BlackSwan
OWB Cube load SQL tuning 119, exadata By: onlinedev on Fri, 27 April 2012	1	643	Fri, 27 April 2012 13:28 By: BlackSwan
Lot of time being taken to delete the data from a table Oracle 10G By: harsh shah on Fri, 27 April 2012	26	872	Fri, 27 April 2012 07:25 By: John Watson
Locking of two sessions Oracle, 10g,Windows By: manjumagesh on Fri, 27 April 2012	3	716	Fri, 27 April 2012 07:24 By: cookiemonster
Tablespace full warning 11g By: najeeb7 on Thu, 26 April 2012	4	1054	Thu, 26 April 2012 07:36 By: BlackSwan
Querying GTT in Parallel Mode Oracle 10.2.0.2 By: orapratap on Tue, 24 April 2012	3	1813	Thu, 26 April 2012 00:43 By: orapratap
Tuneup the SQL Oracle 11.2.0.1.0 OS RH Linux 5.1 By: javed.khan on Mon, 23 April 2012	7	1208	Wed, 25 April 2012 22:49 By: Kevin Meade
Troublesome trigger By: rishwinger on Mon, 23 April 2012	3	640	Wed, 25 April 2012 22:41 By: Kevin Meade
Query on the performance of JOIN on indexed columns Oracle 10.2.0.4 By: orapratap on Fri, 23 March 2012	4	1215	Wed, 25 April 2012 22:15 By: zengmuansha
How to Tune Long running queries? Oracle 10.2.0.4 By: orapratap on Wed, 11 April 2012	16	3419	Wed, 25 April 2012 07:41 By: bobbydurrettdba
how do oracle filter data? Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: zengmuansha on Sun, 22 April 2012	7	923	Sun, 22 April 2012 22:31 By: BlackSwan
Oracle Apps/Software installed in a dB Server Oracle 11g, 11.2.0.2.0, AIX By: reym21 on Thu, 22 March 2012	6	1244	Tue, 17 April 2012 01:59 By: John Watson
query with high cpu usage 10.2.0.2 By: varunvir on Tue, 13 January 2009	14	3795	Mon, 16 April 2012 03:48 By: cookiemonster
DB performance keys By: Amine on Sat, 17 March 2012	8	1285	Mon, 16 April 2012 00:01 By: Kevin Meade
ADDM report Oracle 10.2.0.4.0,SunOS By: Jack14 on Wed, 11 April 2012	10	2426	Sun, 15 April 2012 12:01 By: Jack14
loop questions Oracle 10.2.0.4.0 , AIX 5.3 64bit By: snowball on Wed, 28 March 2012	3	721	Sun, 15 April 2012 01:35 By: Kevin Meade
database statistics By: priteshranjan.preet on Thu, 05 April 2012	2	811	Fri, 13 April 2012 08:14 By: priteshranjan.preet
Different explain plan Oracle 11g,Linux By: pokhraj_d on Fri, 13 April 2012	2	673	Fri, 13 April 2012 06:23 By: Michel Cadot
Partition Pruning Not happening! Oracle 10.2.0.2 By: orapratap on Thu, 12 April 2012	3	1063	Thu, 12 April 2012 02:08 By: orapratap
sql_id and sql_child_id not are null for SQL statement Oracle 11g R2, Windows Server 2003 sp2 By: Andrey_R on Tue, 10 April 2012	6	1367	Tue, 10 April 2012 10:24 By: Michel Cadot
Bulk Inserts Oracle 10.1.0.2 By: arif_md2009 on Mon, 09 April 2012	6	843	Tue, 10 April 2012 01:48 By: Littlefoot
tuning against count with group by clause oracle 10g By: manoj12 on Sat, 31 March 2012	4	1231	Sun, 08 April 2012 01:20 By: Michel Cadot
Need help on SQL Query in decode function performance tunning Oracle 10g By: kgecdeep on Sat, 07 April 2012	2	1205	Sat, 07 April 2012 13:18 By: Michel Cadot
Tuning for slow Oracle query Oracle database 11.2.0.2.0 By: trowsdale on Wed, 04 April 2012	13	2425	Fri, 06 April 2012 09:44 By: Bill B
functional index null values database, 9.2.0.8,hp By: vladimirhrivnak on Thu, 05 April 2012	2	596	Thu, 05 April 2012 12:25 By: Michel Cadot
Query tuning - index suggestion Oracle,10g By: sathik on Thu, 05 April 2012	3	620	Thu, 05 April 2012 09:18 By: BlackSwan
Oracle 11g alternates between two execution plans 11g Linux By: viktordt on Tue, 03 April 2012	4	1074	Thu, 05 April 2012 06:25 By: LNossov
ora - 04031 Oracle, 10.2.0.4 By: savugar on Mon, 27 February 2012	6	1985	Thu, 05 April 2012 05:59 By: LNossov
session doing FTS not appearing in longops Oracle 10.2.0.4 By: orapratap on Wed, 04 April 2012	6	959	Thu, 05 April 2012 05:43 By: orapratap
speeding up scanning of internal temporary table (of materialize hint) Oracle 10.2.0.4 By: orapratap on Tue, 03 April 2012	7	1273	Wed, 04 April 2012 03:17 By: Roachcoach
Parallel operations not executing with expected degree Oracle 10.2.0.4 By: orapratap on Mon, 02 April 2012	2	920	Mon, 02 April 2012 06:01 By: LNossov
Distributed query running slow Oracle9i Enterprise Edition Release 9.2.0.6.0 / Linux 2.4.21-50.ELsmp #1 By: SSharma on Tue, 27 March 2012	8	1124	Sat, 31 March 2012 03:57 By: cookiemonster
How to decide Partiitioning columns? Oracle 10.2.0.4 By: orapratap on Wed, 28 March 2012	21	846	Fri, 30 March 2012 00:58 By: John Watson
Optimiser Cost Caclulation for nested loop join linux, oracle 10g By: rekha.singhal@tcs.com on Tue, 27 March 2012	7	1018	Tue, 27 March 2012 06:53 By: Michel Cadot