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
optimisation oracle 10g By: rajasekhar857 on Wed, 21 October 2009	8	2488	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	6988	Thu, 05 November 2009 17:42 By: Kevin Meade
How to Query Large table .? 10G By: MR[T] on Mon, 26 October 2009	5	2348	Thu, 05 November 2009 17:30 By: Kevin Meade
lock issue oracle 10g , windows By: RAY_HT on Sun, 01 November 2009	3	2088	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	5144	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	1630	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	3172	Thu, 05 November 2009 16:38 By: Kevin Meade
HMV scripts 9.2.0.7 By: puneetsachar on Thu, 05 November 2009	4	1976	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	1671	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	5539	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	2166	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	7127	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	2537	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	4810	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	4393	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	2667	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	9961	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	3399	Fri, 30 October 2009 03:45 By: Michel Cadot
INTERNAL_FUNCTION in execution plan By: McLaud on Thu, 22 October 2009	9	17497	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	2681	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	2569	Mon, 26 October 2009 05:07 By: cookiemonster
Performance on single query Oracle 9i By: ram anand on Sat, 24 October 2009	4	2048	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	5004	Fri, 23 October 2009 04:01 By: JRowbottom
regarding session time out By: karthikeyanc2003 on Fri, 23 October 2009	4	2377	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	7513	Wed, 21 October 2009 01:16 By: balaji_cg
query tuning 10g/windows By: ayush_anand on Tue, 13 October 2009	4	10064	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	4417	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	6209	Wed, 14 October 2009 03:30 By: balakrishnay
How to clear lock???? Oracle 10g By: im_vnew on Sun, 11 October 2009	6	6917	Tue, 13 October 2009 21:25 By: rahulvb
Oracle Performance Manager Oracle 9i By: balaji_cg on Tue, 13 October 2009	5	2262	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	4266	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	3841	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	9339	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	3146	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	1949	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	2219	Wed, 07 October 2009 11:19 By: JRowbottom
db_block_buffer oracle 8i By: ranjit@buddhaair.com on Wed, 07 October 2009	3	2058	Wed, 07 October 2009 05:12 By: JRowbottom
Pctfree 9i By: abdulahads on Tue, 06 October 2009	5	2032	Tue, 06 October 2009 02:28 By: Michel Cadot
Histogram Issue oracle 9.2.0.6 By: ankush_chawla on Mon, 05 October 2009	3	1437	Mon, 05 October 2009 13:23 By: Michel Cadot
hard parse for SQL (merged) By: casttree on Fri, 02 October 2009	4	2858	Mon, 05 October 2009 07:51 By: JRowbottom