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
User statistics Oracle 10.2.0.4 By: gkrishn on Mon, 09 November 2009	3	3530	Mon, 09 November 2009 07:07 By: Michel Cadot
to check for temporary space usage 10.2.0.4 By: ankush_chawla on Wed, 04 November 2009	9	6289	Mon, 09 November 2009 06:35 By: ramoradba
Oracle 10.2.0.4 IBM AIX 5.3 By: ravi214u on Thu, 05 November 2009	9	8967	Sat, 07 November 2009 10:09 By: BlackSwan
SQL Tune Oracle 10g Database 10.2.0.4 + Oracle Client 9.2.0.1 By: babuknb on Fri, 06 November 2009	7	4773	Fri, 06 November 2009 08:16 By: babuknb
optimisation oracle 10g By: rajasekhar857 on Wed, 21 October 2009	8	3623	Thu, 05 November 2009 17:53 By: Kevin Meade
Optimizing the procedure 10.2.0.4, Solaris 10 By: khan500 on Tue, 20 October 2009	12	8420	Thu, 05 November 2009 17:42 By: Kevin Meade
How to Query Large table .? 10G By: MR[T] on Mon, 26 October 2009	5	4012	Thu, 05 November 2009 17:30 By: Kevin Meade
lock issue oracle 10g , windows By: RAY_HT on Sun, 01 November 2009	3	3514	Thu, 05 November 2009 17:26 By: Kevin Meade
How to reduce CPU Utilization 10.2.0.2.0 ,windows By: Hitman11 on Mon, 02 November 2009	11	6303	Thu, 05 November 2009 17:18 By: Kevin Meade
Tune the code without autotrace+ dictionary - fed up with DBA advice (merged 3) Oracle 9i By: Richard2009 on Wed, 04 November 2009	2	2788	Thu, 05 November 2009 16:48 By: Kevin Meade
Buffer Catche 10.2.0.1.0 Redhat Linux 4 By: goracle9 on Thu, 05 November 2009	2	4541	Thu, 05 November 2009 16:38 By: Kevin Meade
HMV scripts 9.2.0.7 By: puneetsachar on Thu, 05 November 2009	4	3352	Thu, 05 November 2009 05:35 By: Michel Cadot
Migration from Oracle8i to Oracle 10G Unix server By: mjkreddy1927 on Thu, 05 November 2009	3	2774	Thu, 05 November 2009 02:10 By: Its_me_ved
SQL statements were not shared due to the usage of literals. This resulted in additional hard parses oracle 10.2.0.1.0,Redhat Linux 4 By: goracle9 on Wed, 04 November 2009	2	6554	Wed, 04 November 2009 03:29 By: JRowbottom
performance issue wtith single instance database linux 2 Advance server By: sherkhan@infodynamic.net on Sun, 25 October 2009	5	3500	Wed, 04 November 2009 00:04 By: sherkhan@infodynamic.net
ORA-02097 AND ORA-00439 10.2.0.1.0 Redhat Linux 4 By: goracle9 on Tue, 03 November 2009	1	7842	Tue, 03 November 2009 02:15 By: Michel Cadot
undo usage in a query oracle 10.2.0.4, Sun 5.10 By: ankush_chawla on Tue, 03 November 2009	1	3143	Tue, 03 November 2009 01:21 By: Michel Cadot
Advanced Queuing correlation id Oracle 10g Release 10.2.0.1.0 By: johnbach on Mon, 02 November 2009	2	5777	Tue, 03 November 2009 00:48 By: johnbach
BITMAP INDEX performance issue 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production By: johnbach on Fri, 23 October 2009	13	5993	Mon, 02 November 2009 03:24 By: johnbach
why oracle change the sql plan from hash join to nested loop when the system resource load is high? oracle RDBMS 10g RAC HP UNIX By: davidh2y on Tue, 27 October 2009	2	3999	Sat, 31 October 2009 07:29 By: davidh2y
Single Query suddenly goes slow until restart or change Oracle 10g EE 10.1.0.4.0, Windows 2003 Server By: ihristov on Tue, 27 October 2009	3	11797	Fri, 30 October 2009 16:42 By: rleishman
INDEX_STATS.HEIGHT > 3 HP UNIX / 9.2.0.7 By: Brayan on Fri, 30 October 2009	3	4503	Fri, 30 October 2009 03:45 By: Michel Cadot
INTERNAL_FUNCTION in execution plan By: McLaud on Thu, 22 October 2009	9	19397	Mon, 26 October 2009 10:50 By: McLaud
Simple select is not executed Oracle 10g, Solaris 10 By: gym963 on Thu, 22 October 2009	10	3870	Mon, 26 October 2009 06:34 By: Michel Cadot
explain plan difference between 9i and 10g oracle 9i,oracle 10g By: manoj12 on Mon, 26 October 2009	2	3624	Mon, 26 October 2009 05:07 By: cookiemonster
Performance on single query Oracle 9i By: ram anand on Sat, 24 October 2009	4	2882	Sat, 24 October 2009 16:13 By: Its_me_ved
Optimizing the query containing 7 table joins By: manzoor14 on Tue, 20 October 2009	28	7504	Fri, 23 October 2009 04:01 By: JRowbottom
regarding session time out By: karthikeyanc2003 on Fri, 23 October 2009	4	3318	Fri, 23 October 2009 03:07 By: ramoradba
How to view Oracle counters in windows performance monitor Oracle 9i By: balaji_cg on Wed, 21 October 2009	0	8212	Wed, 21 October 2009 01:16 By: balaji_cg
query tuning 10g/windows By: ayush_anand on Tue, 13 October 2009	4	11100	Tue, 20 October 2009 07:33 By: michael_bialik
Execution plan for every SQL, executed by user Oracle10g By: McLaud on Wed, 14 October 2009	9	5636	Mon, 19 October 2009 04:21 By: JRowbottom
Analyze table hangs for hours Oracle 10.2.0.4 ,linux By: sundarfaq on Wed, 14 October 2009	3	7139	Wed, 14 October 2009 03:30 By: balakrishnay
How to clear lock???? Oracle 10g By: im_vnew on Sun, 11 October 2009	6	7945	Tue, 13 October 2009 21:25 By: rahulvb
Oracle Performance Manager Oracle 9i By: balaji_cg on Tue, 13 October 2009	5	3925	Tue, 13 October 2009 11:14 By: balaji_cg
Need help on Performance tuning Oracle 10.1.0.2, Windows 2003 By: socalguy09 on Wed, 07 October 2009	6	5263	Fri, 09 October 2009 16:39 By: rleishman
Slow queries, configuration problem ? Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit By: daff24 on Wed, 07 October 2009	8	5198	Fri, 09 October 2009 16:37 By: rleishman
regarding AWK in oracle oracle10g, 10.2.0.2.0, AIX52 By: chandu_imax on Fri, 09 October 2009	0	10064	Fri, 09 October 2009 06:59 By: chandu_imax
Hints within a query that reads from view 10g By: beetel on Wed, 07 October 2009	9	4473	Thu, 08 October 2009 12:04 By: Kevin Meade
Predicate Informationn in PLAN Oracle 10.2.0.3 By: Olivia on Wed, 07 October 2009	4	2821	Wed, 07 October 2009 11:21 By: JRowbottom
Slow performance for Some queries Oracle 10g , solaris By: ram anand on Wed, 07 October 2009	3	3797	Wed, 07 October 2009 11:19 By: JRowbottom