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
Need help in tuning this query By: apps_user on Mon, 20 October 2008	5	2759	Wed, 22 October 2008 03:20 By: Alessandro Rossi
Query Rewrite in Materialised Views (merged) By: hexmanju on Wed, 22 October 2008	3	2683	Wed, 22 October 2008 03:00 By: hexmanju
Performance Query Tuning help By: rsoma on Fri, 17 October 2008	6	2902	Tue, 21 October 2008 22:27 By: rsoma
Please help me Tune this query By: rak007 on Thu, 16 October 2008	4	4412	Tue, 21 October 2008 16:36 By: michael_bialik
can oracle access table in parallel with index? oracle 10g r2 By: Kriptas on Tue, 21 October 2008	1	2076	Tue, 21 October 2008 13:45 By: Michel Cadot
Query Optimization (merged) By: psamarpan on Tue, 21 October 2008	4	2932	Tue, 21 October 2008 13:38 By: Kriptas
Query running more timeand then time out message Oracle, 9i ,window xp By: psamarpan on Tue, 21 October 2008	1	2226	Tue, 21 October 2008 06:47 By: Michel Cadot
ORA-03113 after performance tuning Oracle 9.2.0.3, Windows 2003 By: dzavy on Mon, 20 October 2008	2	2461	Mon, 20 October 2008 20:38 By: Kevin Meade
Slow query - Please help. By: ora_2007 on Thu, 03 January 2008	16	4372	Sat, 18 October 2008 22:07 By: rleishman
Slow cpu-bound hard parse in one environment, fast in another By: pmc123 on Fri, 17 October 2008	3	2466	Sat, 18 October 2008 21:57 By: rleishman
tuning a view Oracle 10g, Windows By: getritesh on Tue, 14 October 2008	4	3118	Sat, 18 October 2008 12:47 By: getritesh
optimize query 10g By: ora_baby on Tue, 14 October 2008	5	2832	Thu, 16 October 2008 09:24 By: JRowbottom
Getting Plan of SQL query executed in the past (merged) By: kumarsz on Thu, 16 October 2008	1	5490	Thu, 16 October 2008 08:18 By: kumarsz
Very Strange and Interesting Oracle Issue 10g R2 By: nsteblay on Mon, 13 October 2008	3	2960	Thu, 16 October 2008 08:12 By: nsteblay
need help to tune the query solaris 10 oracle 10.2.0.3 By: kumar.joy on Tue, 14 October 2008	4	2510	Thu, 16 October 2008 07:57 By: JRowbottom
Which is faster 10g By: maheshmhs on Wed, 15 October 2008	4	2784	Thu, 16 October 2008 06:45 By: rleishman
Performance issue with RETURNING BULK COLLECT clause Oracle 10g on Linux By: snomula on Thu, 09 October 2008	3	3210	Thu, 16 October 2008 06:29 By: rleishman
OEM performance issue oracle 10G on RHEL 4 By: bangalibor on Wed, 15 October 2008	0	6559	Wed, 15 October 2008 22:36 By: bangalibor
Performance issue on RAC Linux Redhat 4 AS/ES By: altafhk on Wed, 13 August 2008	19	7306	Wed, 15 October 2008 02:14 By: altafhk
MAJOR performance issues since upgrade to 10G 10.2.0.3.0 By: kenton on Tue, 14 October 2008	2	1765	Tue, 14 October 2008 16:35 By: kenton
TRIGGERS/PROCEDURES running too slow after index rebuild ORACLE 8i By: ajaysharma2907 on Fri, 10 October 2008	4	3491	Tue, 14 October 2008 01:39 By: ajaysharma2907
Bulk insert Oracle 9i,windows By: balaji1482 on Mon, 13 October 2008	4	5158	Mon, 13 October 2008 05:36 By: balaji1482
about sql access advisor oracle10g, 10.2.0, RHEL AS4 By: suresh.wst on Sun, 12 October 2008	5	5598	Sun, 12 October 2008 03:45 By: Arju
query slow after 10g upgrade 10.2.0.3 on hp-ux By: seema.taunk on Thu, 18 September 2008	10	7144	Sun, 12 October 2008 03:38 By: Arju
After Defining Index 10.2.0.1 By: pmapc on Fri, 10 October 2008	2	2195	Fri, 10 October 2008 02:02 By: pmapc
General Question 9i By: MrSethT on Mon, 06 October 2008	8	4540	Thu, 09 October 2008 22:58 By: Michel Cadot
query tuning By: ArvindBhope on Thu, 09 October 2008	2	2304	Thu, 09 October 2008 15:33 By: ArvindBhope
10.2..0..2 solaris9 By: varunvir on Thu, 09 October 2008	3	2089	Thu, 09 October 2008 12:01 By: varunvir
segment tuning 10.2.0.1 By: varunvir on Mon, 06 October 2008	2	2457	Thu, 09 October 2008 10:33 By: varunvir
Index creation- Performance impact Oracle 10g By: ora_2007 on Mon, 06 October 2008	4	2703	Thu, 09 October 2008 09:47 By: Kevin Meade
How to tune UNION Oracle,10g,Windows XP By: getritesh on Thu, 09 October 2008	7	3500	Thu, 09 October 2008 09:26 By: Kevin Meade
Need Assistance in Fine tuning the SQL By: saurav.raj on Tue, 07 October 2008	2	4379	Tue, 07 October 2008 07:43 By: michael_bialik
Fine tuning By: saurav.raj on Mon, 06 October 2008	1	1969	Mon, 06 October 2008 05:30 By: Michel Cadot
need assistance to optimize the query oracle 10.2.0.3 By: kumar.joy on Thu, 02 October 2008	3	2913	Sat, 04 October 2008 21:09 By: Kevin Meade
Performance Due to Buffer Sort Oracle 10.2.0.2.0 By: senaka on Tue, 30 September 2008	9	24704	Sat, 04 October 2008 00:16 By: senaka
Dictionary Cache Hit ratio Oracle 9.2.0.8 By: shrinika on Thu, 02 October 2008	1	4420	Thu, 02 October 2008 10:19 By: Michel Cadot
Need to improve query performance Oracle 10g ( 1 2) By: RAJANKK4 on Mon, 22 September 2008	44	9759	Wed, 01 October 2008 02:50 By: JRowbottom
Pagination in big result sets Oracle 10g By: javier.rivas.arias on Mon, 29 September 2008	1	2441	Mon, 29 September 2008 22:41 By: rleishman
Why does t.rowid = t.rowid improves performance? Oracle Enterprise Edition Release 9.2.0.6.0 By: emil_m on Fri, 26 September 2008	13	8472	Mon, 29 September 2008 12:29 By: coleing
Two 30 million records tables join query needs tuning Oracle 10g,AIX By: d.dineshkumar on Sat, 20 September 2008	9	7836	Sat, 27 September 2008 12:04 By: Kevin Meade