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
can oracle access table in parallel with index? oracle 10g r2 By: Kriptas on Tue, 21 October 2008	1	1447	Tue, 21 October 2008 13:45 By: Michel Cadot
Query Optimization (merged) By: psamarpan on Tue, 21 October 2008	4	2069	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	1715	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	2204	Mon, 20 October 2008 20:38 By: Kevin Meade
Slow query - Please help. By: ora_2007 on Thu, 03 January 2008	16	3507	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	2064	Sat, 18 October 2008 21:57 By: rleishman
tuning a view Oracle 10g, Windows By: getritesh on Tue, 14 October 2008	4	2755	Sat, 18 October 2008 12:47 By: getritesh
optimize query 10g By: ora_baby on Tue, 14 October 2008	5	2461	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	4750	Thu, 16 October 2008 08:18 By: kumarsz
Very Strange and Interesting Oracle Issue 10g R2 By: nsteblay on Mon, 13 October 2008	3	2264	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	2226	Thu, 16 October 2008 07:57 By: JRowbottom
Which is faster 10g By: maheshmhs on Wed, 15 October 2008	4	1929	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	2900	Thu, 16 October 2008 06:29 By: rleishman
OEM performance issue oracle 10G on RHEL 4 By: bangalibor on Wed, 15 October 2008	0	6328	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	6304	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	1493	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	2475	Tue, 14 October 2008 01:39 By: ajaysharma2907
Bulk insert Oracle 9i,windows By: balaji1482 on Mon, 13 October 2008	4	3917	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	4307	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	5404	Sun, 12 October 2008 03:38 By: Arju
After Defining Index 10.2.0.1 By: pmapc on Fri, 10 October 2008	2	1412	Fri, 10 October 2008 02:02 By: pmapc
General Question 9i By: MrSethT on Mon, 06 October 2008	8	2606	Thu, 09 October 2008 22:58 By: Michel Cadot
query tuning By: ArvindBhope on Thu, 09 October 2008	2	1634	Thu, 09 October 2008 15:33 By: ArvindBhope
10.2..0..2 solaris9 By: varunvir on Thu, 09 October 2008	3	1798	Thu, 09 October 2008 12:01 By: varunvir
segment tuning 10.2.0.1 By: varunvir on Mon, 06 October 2008	2	1613	Thu, 09 October 2008 10:33 By: varunvir
Index creation- Performance impact Oracle 10g By: ora_2007 on Mon, 06 October 2008	4	2321	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	2956	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	4075	Tue, 07 October 2008 07:43 By: michael_bialik
Fine tuning By: saurav.raj on Mon, 06 October 2008	1	1463	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	2560	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	23247	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	4072	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	7672	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	1863	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	7411	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	5887	Sat, 27 September 2008 12:04 By: Kevin Meade
a locking scenario Generic By: gkrishn on Fri, 26 September 2008	1	1474	Fri, 26 September 2008 10:14 By: Alessandro Rossi
SQL execution time based on ash history 10g release 2 By: John Charles on Fri, 26 September 2008	0	8180	Fri, 26 September 2008 04:23 By: John Charles
taking to much time to update oracle 9i/Linux By: tannad on Tue, 23 September 2008	7	2641	Fri, 26 September 2008 00:50 By: Kevin Meade
How to delete records without generating redo logs? Oracle 10g By: sudheer0886 on Thu, 25 September 2008	11	14029	Thu, 25 September 2008 22:55 By: rleishman