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
HASH cluster building very Slow Oracle 10g R2 By: sky_lt on Tue, 02 February 2010	7	5158	Fri, 05 February 2010 03:05 By: John Watson
Performance issue in Oracle 10g using Bulk Collect Oracle 10.2.0.3.0 By: venkat_bollu on Fri, 05 February 2010	3	4463	Fri, 05 February 2010 02:58 By: Michel Cadot
Function Based Indexes By: navin_deep on Wed, 03 February 2010	2	2981	Wed, 03 February 2010 12:09 By: Michel Cadot
Oracle Segment Tuning Oracle10g By: salora on Tue, 02 February 2010	2	9287	Tue, 02 February 2010 02:59 By: rahulvb
Heap size exceeds warning notification in alert.log oracle 10.2.0.1.0,Redhat Linux 4.5 [Enterprise edition] By: goracle9 on Sat, 30 January 2010	9	51981	Sun, 31 January 2010 01:41 By: Michel Cadot
slower execution of pl/sql code By: mandark on Thu, 28 January 2010	1	2853	Fri, 29 January 2010 10:56 By: Kevin Meade
Bitmap Join Index for DW Oracle 10g By: summoner on Mon, 25 January 2010	5	5365	Fri, 29 January 2010 10:51 By: Kevin Meade
When is execution plan for a package determined (merged) By: firefly on Thu, 28 January 2010	17	5049	Fri, 29 January 2010 02:38 By: firefly
Rarely used columns Oracle 10.2.0.1.0,RHEL5,pro*c By: johnbach on Thu, 28 January 2010	4	3001	Thu, 28 January 2010 05:52 By: rleishman
how to calculate cpu usage of database from statspack report 10.1.0.5.0 , linux By: anwar786 on Wed, 27 January 2010	2	5273	Wed, 27 January 2010 23:54 By: anwar786
v$pgastat value 11.0.0.6 By: jinga on Wed, 27 January 2010	4	5406	Wed, 27 January 2010 11:05 By: Michel Cadot
Undo used by Batch Job Oracle 9.2.0.6.0 on HP-UX By: chetanaZ on Tue, 26 January 2010	3	2851	Tue, 26 January 2010 05:27 By: Michel Cadot
Query performance problem Oracle 9.2.0.8.0 By: mbmalasenthil on Mon, 25 January 2010	2	2863	Mon, 25 January 2010 05:39 By: rleishman
Use of double parallel hint By: sameertuladhar on Mon, 25 January 2010	1	3845	Mon, 25 January 2010 02:58 By: Michel Cadot
Finding INSERT statments between 2 AWR snapshots 10.2.0.4 By: kamran.irshad on Sat, 23 January 2010	1	3346	Sat, 23 January 2010 00:32 By: kamran.irshad
Query With View Vs Select of the View behave differently Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 By: faiz_hyd on Thu, 21 January 2010	3	4180	Fri, 22 January 2010 07:45 By: cookiemonster
Query Fetching data within Two hrs 9.2.0.8 By: jaganerp@gmail.com on Fri, 22 January 2010	3	7848	Fri, 22 January 2010 05:53 By: cookiemonster
Table Access by ROWID vs UNIQUE INDEX SCAN 10.2.0.4 By: kamran.irshad on Thu, 21 January 2010	4	9714	Thu, 21 January 2010 21:35 By: rleishman
Determining UPDATE statements from DBA_HIST_SQL_PLAN 10.2.0.4 By: kamran.irshad on Tue, 19 January 2010	4	4428	Thu, 21 January 2010 01:23 By: John Watson
"os thread startup" in top 5 Events linux , oracle 10.2.0.4 By: gir_sat on Wed, 20 January 2010	1	19903	Wed, 20 January 2010 04:59 By: ramoradba
Database slow problem 10g Database By: allianz2010 on Mon, 18 January 2010	5	3909	Wed, 20 January 2010 03:44 By: JRowbottom
how to avoid multiple Like operators in a single query By: bubblyaruna on Tue, 22 December 2009	8	4830	Sat, 16 January 2010 17:45 By: Kevin Meade
Query optimisation, table partitionning and lack of index database 10g By: didiera on Thu, 14 January 2010	5	4398	Sat, 16 January 2010 17:41 By: rleishman
Oracle audit view performance issue Oracle Apps R12 By: sreejit on Thu, 24 December 2009	5	6995	Sat, 16 January 2010 15:53 By: Kevin Meade
Wait event problem oracle 10.1.0.5.0, Sunsolaris 5.10 By: sathik on Thu, 14 January 2010	2	2916	Sat, 16 January 2010 15:37 By: Kevin Meade
SQL Tuning and optimization- Help Needed 10g By: benjamin.tl on Wed, 13 January 2010	5	3160	Thu, 14 January 2010 09:02 By: benjamin.tl
11g tuning oracle 11g By: orafacjublu on Tue, 12 January 2010	3	2759	Tue, 12 January 2010 04:22 By: Michel Cadot
Query monitoring/intercepting 10g By: newerakb on Mon, 11 January 2010	4	2830	Mon, 11 January 2010 15:20 By: newerakb
how to reduce the response time of the sql query oracl 10 linux By: dhanamukesh on Fri, 08 January 2010	10	4140	Mon, 11 January 2010 07:31 By: JRowbottom
what is the best ? (merged 3) oracle 11g By: al_hareth on Sat, 09 January 2010	4	2701	Sat, 09 January 2010 16:23 By: martijn
cardinality of join affected by transitivity 10201 By: stsy38 on Thu, 31 December 2009	14	6232	Sat, 09 January 2010 11:53 By: narsap
SQL Tuning- Need help Oracle 10g Enterprise Edition Release 10.2.0.3.0 - Prod By: marlon_loyolite on Thu, 07 January 2010	1	2651	Fri, 08 January 2010 02:31 By: Michel Cadot
to tune an SQL query oracle 9i By: mohannksr on Fri, 08 January 2010	3	2883	Fri, 08 January 2010 01:36 By: rahulvb
Re-structuring the SQL query By: decci_7 on Mon, 04 January 2010	3	2860	Wed, 06 January 2010 19:47 By: rleishman
How to tune this sql? Oracle 10.0.2.3 By: prachij593 on Tue, 05 January 2010	7	3390	Tue, 05 January 2010 09:31 By: BlackSwan
Instance profiling 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: rahulvb on Tue, 05 January 2010	5	3152	Tue, 05 January 2010 03:25 By: rahulvb
write as a single statement Databse 10.1,xp By: krajasekhar.v on Tue, 22 December 2009	2	2191	Sun, 03 January 2010 09:46 By: coleing
Current snap shot level? 9.2, Windows XP By: muthu_dba on Sat, 02 January 2010	3	2516	Sat, 02 January 2010 11:39 By: BlackSwan
Explain Plan from statsreport Oracle DB, 10.2.0.4.0 , UNIX By: smita_giri on Thu, 24 December 2009	5	4691	Wed, 30 December 2009 06:33 By: JRowbottom
Sql query tuning oracle,10.1.0.5.0,sunsolaris 5.10 By: sathik on Wed, 23 December 2009	9	4225	Wed, 30 December 2009 06:15 By: JRowbottom