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 with rewriting the query 8.0.6 By: ateeqrahman786 on Sat, 15 May 2010	10	3090	Mon, 17 May 2010 02:50 By: ateeqrahman786
need help to speed up data loading in form 8.0.6, forms 4.5, win 2003 server By: ateeqrahman786 on Sat, 15 May 2010	1	1719	Sat, 15 May 2010 07:48 By: rleishman
Sql Trace and tkprof By: sonia.ali on Fri, 14 May 2010	1	2608	Fri, 14 May 2010 01:13 By: Michel Cadot
Tune sql query oracle 10.2.0.4 By: ankush_chawla on Mon, 03 May 2010	5	2859	Fri, 14 May 2010 00:45 By: nitinkrmishra
Function based index Oracle, 10g, Windows Server 2003 By: getritesh on Wed, 12 May 2010	8	2930	Thu, 13 May 2010 12:07 By: Michel Cadot
Help required to tune a query Oralce,9.2.0.8.0,sun solaris 5.2 By: sathik on Wed, 05 May 2010	13	3148	Thu, 13 May 2010 04:02 By: sathik
Consistent gets reduced but Elapsed time increased.. please help. By: nitinkrmishra on Mon, 10 May 2010	4	2707	Wed, 12 May 2010 08:55 By: Alessandro Rossi
performance problem oracle 10g, windows By: klinki on Thu, 06 May 2010	4	2900	Tue, 11 May 2010 01:37 By: klinki
Optimisation Strategies Oracle 11g Enterprise R1 By: dsub42 on Fri, 07 May 2010	26	4530	Mon, 10 May 2010 01:25 By: rahulvb
AWR report 10.2.0.4 By: new_dba on Thu, 06 May 2010	1	1993	Thu, 06 May 2010 07:12 By: John Watson
Tuning Oracle, 10g, Windows Server 2003 By: getritesh on Mon, 03 May 2010	4	2295	Wed, 05 May 2010 03:07 By: michael_bialik
simultaneous query processing 11g,solaris (urgent) By: orafacjublu on Mon, 03 May 2010	1	2096	Mon, 03 May 2010 03:36 By: Michel Cadot
Interpreting tuning task Report Oracle 10.2.0.4,AIX By: dbcop on Wed, 28 April 2010	4	8100	Sun, 02 May 2010 05:58 By: michael_bialik
execution time versus plan cost 10.2.0.4 By: ankush_chawla on Fri, 30 April 2010	2	2708	Fri, 30 April 2010 07:14 By: cookiemonster
Updating a huge table of size 750Gb Oracle 10g, Linux By: nawasthi on Fri, 30 April 2010	1	2272	Fri, 30 April 2010 00:57 By: Michel Cadot
alter table to add list partition oracle 10g By: swas_fly on Thu, 29 April 2010	1	2622	Thu, 29 April 2010 02:37 By: Michel Cadot
awr report By: zodiacsom on Mon, 26 April 2010	3	18349	Wed, 28 April 2010 01:31 By: zodiacsom
DBMS SQL Tuning Advisor 10.2.0.4 By: ankush_chawla on Mon, 26 April 2010	3	5072	Tue, 27 April 2010 01:03 By: John Watson
DBMS SQL TUNE Problem Oracle 10.2.0.4/AIX 5 By: dbcop on Mon, 26 April 2010	1	7233	Mon, 26 April 2010 10:47 By: mherlindo
Tuning query having not exists clause. Oracle Database 10g Release 10.2.0.4.0 - 64bit Production. By: Gangaprasad on Thu, 22 April 2010	3	3139	Thu, 22 April 2010 04:55 By: cookiemonster
Tune sql query 10.2.0.4 By: ankush_chawla on Tue, 20 April 2010	9	3561	Wed, 21 April 2010 06:29 By: JRowbottom
Analse tables Oracle 9i ,AIx 5.2 By: soundar on Mon, 19 April 2010	3	2577	Tue, 20 April 2010 07:57 By: soundar
Parsing of sql-statements Oracle rdbms / 11.2.0.1.0 / Linux / FC 12 32 bit By: martijn on Fri, 16 April 2010	5	2954	Sun, 18 April 2010 08:29 By: mnitu
Compare Query Performance Oracle 10.2.0.4.0 on windows and HP-UX By: kumarsz on Mon, 12 April 2010	3	2919	Fri, 16 April 2010 01:04 By: hkchital
same query different explain plan 11g ,solaris By: orafacjublu on Mon, 12 April 2010	2	3536	Wed, 14 April 2010 09:01 By: mjohanss
SQL Logic (merged by CM) Oracle9i By: kkmohan1 on Wed, 14 April 2010	1	2209	Wed, 14 April 2010 05:47 By: cookiemonster
Using 9i stored outlines by 11g SPM 11g , solaris9 By: orafacjublu on Mon, 12 April 2010	3	3001	Mon, 12 April 2010 13:09 By: John Watson
awr snapshots oracle 10g,unix By: ranganathan1984 on Fri, 09 April 2010	3	2445	Fri, 09 April 2010 14:47 By: Michel Cadot
hash join vs nested loops 11g By: orafacjublu on Wed, 07 April 2010	3	5069	Thu, 08 April 2010 08:02 By: rleishman
Using SQL Tuning Advisor Interactively on already running task/job/batch By: samg4ug on Thu, 08 April 2010	2	2137	Thu, 08 April 2010 04:51 By: samg4ug
Resolving Latch Free Waits Oracle 9.2.0.6.0 and 9.2.0.8.0 on HP-UX By: kumarsz on Tue, 06 April 2010	12	11782	Wed, 07 April 2010 05:44 By: kumarsz
Please help me in tuning below query By: Gangaprasad on Mon, 05 April 2010	8	3650	Wed, 07 April 2010 04:44 By: JRowbottom
Query benchmarking Oracle 10gR2 RHEL 4 By: sussus2326 on Wed, 07 April 2010	1	2201	Wed, 07 April 2010 03:23 By: Michel Cadot
Performance tuning with date comparison oracle 10g By: sray_suman on Tue, 30 March 2010	18	6894	Fri, 02 April 2010 02:05 By: mnitu
Inline View Oracle 10G By: harshalonline22 on Mon, 29 March 2010	6	4888	Thu, 01 April 2010 08:02 By: cookiemonster
Difference in Cardinality, Cost, Temp Space Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: knw15pwr on Tue, 30 March 2010	16	5544	Wed, 31 March 2010 04:44 By: cookiemonster
Missing Index but strange column Oracle 10.2.0.1, Sun Solaris 10 By: trantuananh24hg on Thu, 11 March 2010	4	3736	Wed, 31 March 2010 04:07 By: cookiemonster
Full Table Scan Instead of Index Usage Oracle 10g By: MartinMM on Thu, 17 July 2008	34	16894	Tue, 30 March 2010 07:39 By: cookiemonster
11g- query Performance issue 11g,Release 11.1.0.6.0,windowsXP By: vs0037476 on Sun, 28 March 2010	4	3354	Mon, 29 March 2010 02:14 By: vs0037476
Query fetching time before hand 11g,solaris9 By: orafacjublu on Thu, 25 March 2010	3	2670	Sun, 28 March 2010 08:17 By: Michel Cadot