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
Oracle 10.2.0.4 IBM AIX 5.3 By: ravi214u on Thu, 05 November 2009	9	8301	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	4072	Fri, 06 November 2009 08:16 By: babuknb
optimisation oracle 10g By: rajasekhar857 on Wed, 21 October 2009	8	2951	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	7555	Thu, 05 November 2009 17:42 By: Kevin Meade
How to Query Large table .? 10G By: MR[T] on Mon, 26 October 2009	5	3526	Thu, 05 November 2009 17:30 By: Kevin Meade
lock issue oracle 10g , windows By: RAY_HT on Sun, 01 November 2009	3	3096	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	5658	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	2367	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	4116	Thu, 05 November 2009 16:38 By: Kevin Meade
HMV scripts 9.2.0.7 By: puneetsachar on Thu, 05 November 2009	4	2878	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	2343	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	6087	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	3003	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	7439	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	2829	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	5314	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	5021	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	3478	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	10995	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	3883	Fri, 30 October 2009 03:45 By: Michel Cadot
INTERNAL_FUNCTION in execution plan By: McLaud on Thu, 22 October 2009	9	18182	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	3151	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	3203	Mon, 26 October 2009 05:07 By: cookiemonster
Performance on single query Oracle 9i By: ram anand on Sat, 24 October 2009	4	2376	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	5713	Fri, 23 October 2009 04:01 By: JRowbottom
regarding session time out By: karthikeyanc2003 on Fri, 23 October 2009	4	2793	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	7983	Wed, 21 October 2009 01:16 By: balaji_cg
query tuning 10g/windows By: ayush_anand on Tue, 13 October 2009	4	10548	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	4874	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	6647	Wed, 14 October 2009 03:30 By: balakrishnay
How to clear lock???? Oracle 10g By: im_vnew on Sun, 11 October 2009	6	7255	Tue, 13 October 2009 21:25 By: rahulvb
Oracle Performance Manager Oracle 9i By: balaji_cg on Tue, 13 October 2009	5	3392	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	4615	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	4227	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	9682	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	3533	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	2298	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	3301	Wed, 07 October 2009 11:19 By: JRowbottom
db_block_buffer oracle 8i By: ranjit@buddhaair.com on Wed, 07 October 2009	3	3127	Wed, 07 October 2009 05:12 By: JRowbottom
Pctfree 9i By: abdulahads on Tue, 06 October 2009	5	2384	Tue, 06 October 2009 02:28 By: Michel Cadot