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
parallel_index 11g1, 11g2 LINUX By: mjm22 on Wed, 23 November 2011	1	5733	Thu, 01 December 2011 14:05 By: LNossov
I/O issue 11g r2 HP-UX By: dba_7722 on Wed, 30 November 2011	4	6221	Thu, 01 December 2011 13:43 By: LNossov
memory_max_target and 11g memory utilization - question 11.2.0.1.0 By: piotrtal on Wed, 30 November 2011	5	4101	Wed, 30 November 2011 13:27 By: BlackSwan
WINDOW SORT Oracle 11g By: sachi09 on Wed, 30 November 2011	5	7572	Wed, 30 November 2011 04:37 By: Michel Cadot
Data type conversion impact on performance By: patni123 on Mon, 28 November 2011	8	4412	Tue, 29 November 2011 03:59 By: cookiemonster
Query performance decreased between order by ASC/DESC By: euphORIA on Fri, 25 November 2011	11	2932	Mon, 28 November 2011 11:59 By: Flyby
SGA AND PGA PARAMETER SETTINGS WINDOWS 2000 SERVER ORACLE 9I By: mrdb on Sun, 27 November 2011	5	4142	Sun, 27 November 2011 02:49 By: John Watson
Table space with different block size inside same database Oracle 10g, 10.2.0.1.0 Linux By: Rags123 on Fri, 25 November 2011	14	3528	Fri, 25 November 2011 16:55 By: BlackSwan
Reports Tuning Oracle Report builder 6i or later .. By: ramoradba on Wed, 23 November 2011	1	2103	Thu, 24 November 2011 02:02 By: ramoradba
MVIEW huge temp space 10.2.0.3 linux By: dee_bee_eh on Wed, 23 November 2011	6	5790	Wed, 23 November 2011 09:43 By: dee_bee_eh
Elapsed Time in Trace file output (2 Merged) Oracle 11g R2 on Windows 7 By: orapratap on Wed, 16 November 2011	1	20236	Wed, 23 November 2011 05:29 By: dee_bee_eh
Temp Tablespace running out of space (68 GB) Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Thu, 17 November 2011	5	8336	Wed, 23 November 2011 04:41 By: dee_bee_eh
At the end of the road of my sql tuning oracle By: tigerxu on Mon, 21 November 2011	1	1370	Mon, 21 November 2011 20:47 By: BlackSwan
Definition between 2 metrics "Physical Reads" 10gR2 By: nikko on Mon, 21 November 2011	3	1759	Mon, 21 November 2011 06:22 By: John Watson
Tuning in Hierarchical queries Oracle 10.2.0.2.0 By: praveenkumarsr on Thu, 17 November 2011	4	2231	Fri, 18 November 2011 19:12 By: praveenkumarsr
Need help for query tunning the below query By: shefalik on Wed, 16 November 2011	5	2072	Thu, 17 November 2011 03:38 By: cookiemonster
Slow running query -Explain plan attached-pls help! ORacle,11g,windows server2003 By: aviana on Wed, 16 November 2011	2	1891	Wed, 16 November 2011 13:54 By: LKBrwn_DBA
Simple inserts Slow (merged 6) oracle 10g XP By: zulfiqaralimemon on Tue, 18 October 2011	7	2399	Wed, 16 November 2011 07:05 By: Michel Cadot
Shrinking index Oracle 10.2.0.3,Windows server 2003 64 bit By: eafaisal on Tue, 15 November 2011	7	2028	Wed, 16 November 2011 01:30 By: Michel Cadot
index monitoring oracle 10g By: prashant_ora on Thu, 26 August 2010	23	6095	Fri, 11 November 2011 16:31 By: LNossov
Merge statement tuning for 100M records in table ( 1 2) By: sachi09 on Mon, 31 October 2011	49	9054	Tue, 08 November 2011 04:35 By: LNossov
Need help (2 Merged) By: supriyadba1 on Mon, 07 November 2011	14	3153	Tue, 08 November 2011 00:53 By: supriyadba1
SQL tuning 11.2.0.2 By: singh09 on Sun, 06 November 2011	3	2437	Mon, 07 November 2011 01:17 By: LNossov
Reducing Hard parses Oracle 10g, 10.2.0.3.0, Linux By: Rags123 on Wed, 02 November 2011	30	13246	Fri, 04 November 2011 05:00 By: LNossov
Doubt about Tuning SQL Oracle 11g R2 By: aucrun on Thu, 03 November 2011	8	2469	Thu, 03 November 2011 12:25 By: aucrun
sql tunning help required 11.1.0.7 By: nut_shut on Mon, 12 September 2011	4	1754	Wed, 02 November 2011 13:12 By: Flyby
Compare current row values with previous one until mismatch Oracle 10g By: asakchris on Wed, 02 November 2011	7	2409	Wed, 02 November 2011 05:25 By: Michel Cadot
Parallelism in queries By: manojbe09 on Thu, 20 October 2011	4	1512	Sun, 30 October 2011 23:55 By: manojbe09
Bulk update performance issue Oracle 11g, Windows XP By: ninan on Sat, 01 October 2011	26	9185	Sat, 29 October 2011 19:54 By: Kevin Meade
buffer busy wait Linux 2.6.18-92.1.13.el5 By: dba_7722 on Tue, 25 October 2011	20	6778	Fri, 28 October 2011 16:12 By: LNossov
Reading explain plan 11GR2 RAC on Windows By: Kwisatz78 on Mon, 24 October 2011	4	2032	Fri, 28 October 2011 10:21 By: Vackar
Query performance diff Oracle 10.2.0.1.0 CentOS 5 By: Vackar on Tue, 25 October 2011	12	2668	Fri, 28 October 2011 06:41 By: cookiemonster
Tuning my first query 11GR2 RAC on Windows By: Kwisatz78 on Wed, 26 October 2011	10	3006	Thu, 27 October 2011 04:15 By: cookiemonster
Are Stale STATS Any Good v10.2.0.4 SunOS 5.10 x86_64 By: drovnik on Tue, 18 October 2011	2	2024	Thu, 27 October 2011 02:31 By: drovnik
Proving OTT undo reads In post By: Roachcoach on Wed, 26 October 2011	3	2053	Wed, 26 October 2011 08:50 By: Roachcoach
Performance Issue after Bulk Insertion Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: Manoj.Gupta.91 on Tue, 04 October 2011	2	1545	Wed, 26 October 2011 06:57 By: Kevin Meade
DECODE in WHERE CLAUSE Performance Oracle 11g, Windows XP By: ninan on Mon, 17 October 2011	9	16630	Wed, 26 October 2011 06:01 By: Kevin Meade
Performance Tuning Aix By: sher297 on Sun, 23 October 2011	5	2034	Wed, 26 October 2011 04:53 By: Kevin Meade
executions 10.2.0.4, Windows 2003 By: sant_new on Tue, 25 October 2011	3	1883	Tue, 25 October 2011 13:16 By: BlackSwan
Tracing long running program 10.2.0.4, Windows 2003 By: sant_new on Tue, 25 October 2011	14	3467	Tue, 25 October 2011 12:49 By: Michel Cadot