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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Not exists inside exists is having very low performence By: narsimha6 on Thu, 02 August 2012	2	841	Fri, 03 August 2012 06:26 By: cookiemonster
where the second fetch data ? oracle 10g 10.2.03 By: zengmuansha on Wed, 01 August 2012	3	860	Thu, 02 August 2012 06:25 By: cookiemonster
connect database By: sirumon on Mon, 19 December 2011	13	883	Wed, 01 August 2012 06:13 By: Michel Cadot
Oracle 11g high memory usage dbw0 and dbw1 Oracle 11.2.0.3 Redhat Linux By: preet_kumar on Tue, 31 July 2012	4	3375	Tue, 31 July 2012 07:20 By: John Watson
understanding a SQL plan Oracle 11.2.0.2 Solaris 2.10 By: BeefStu on Wed, 18 July 2012	5	1084	Mon, 23 July 2012 17:31 By: alan.kendall@nfl.com
Undo advice. 11.0.2.3 Sol 10 64bit By: Roachcoach on Fri, 06 July 2012	12	1318	Mon, 23 July 2012 16:41 By: alan.kendall@nfl.com
SQL optimisation By: rachcha on Mon, 23 July 2012	1	817	Mon, 23 July 2012 11:48 By: Michel Cadot
Sentence tuning Oracle9i By: estonolose on Wed, 04 July 2012	7	1308	Wed, 18 July 2012 15:05 By: alan.kendall@nfl.com
DB FILE SEQUENTIAL READ IN Full table scan Oracle,11.1.0.7.0,Aix By: vattigunta on Tue, 17 July 2012	9	2922	Wed, 18 July 2012 14:05 By: LNossov
how can i know host name using sql id or sid oracle 10g rac 10.2.0.4, windows server 2008 64 bit By: x-oracle on Wed, 11 July 2012	19	3057	Wed, 18 July 2012 13:43 By: alan.kendall@nfl.com
Oracle process exceed SGA_MAX_TARGET Oracle database 11g R2,Windows 2008 server By: Sami_Younis on Tue, 17 July 2012	2	992	Tue, 17 July 2012 21:21 By: alan.kendall@nfl.com
How to Tune my SQL (5 merged) 10.2.0.3.0 By: grpatwari on Mon, 16 July 2012	4	727	Mon, 16 July 2012 08:31 By: Michel Cadot
Response very slow oracle database 10g By: hielh on Thu, 31 May 2012	8	1748	Fri, 13 July 2012 19:44 By: alan.kendall@nfl.com
Big database migration By: majstoru on Wed, 04 July 2012	4	771	Fri, 13 July 2012 15:45 By: majstoru
The percentage of time spent by sessions waiting on redo operations By: BeefStu on Thu, 12 July 2012	11	906	Thu, 12 July 2012 13:01 By: BeefStu
DBA performance tools Oracle 10g By: ram anand on Wed, 11 July 2012	4	647	Thu, 12 July 2012 00:57 By: Michel Cadot
Oracle 10g showing problem with index (2 Merged) 10g By: avaquestions on Mon, 02 July 2012	22	1868	Wed, 11 July 2012 10:11 By: avaquestions
Elapsed time 11.2.0.2 , Linux By: gkrishn on Sat, 07 July 2012	16	2204	Wed, 11 July 2012 09:50 By: LNossov
DB time in AWR Report - (CPU time,I/O and waits)? Oracle 10.2.0.4 By: orapratap on Mon, 09 July 2012	3	4143	Tue, 10 July 2012 01:04 By: Michel Cadot
Force Index Unique Scan Oracle 10g 10.2.0.4 HP-UX By: manubatham20 on Thu, 14 June 2012	19	3990	Sun, 08 July 2012 20:32 By: rleishman
where fiter result rows save before join and grop by operation? oracle 10g 10.2.0.1 By: zengmuansha on Sat, 07 July 2012	11	1328	Sun, 08 July 2012 04:53 By: John Watson
DB file sequential read (9 merged) oracle 10g By: bhagyaraj.p on Fri, 06 July 2012	5	2395	Sat, 07 July 2012 01:43 By: John Watson
DB_BLOCK_SIZE ORACLE 11GR2 SOLARIS By: guddu_12 on Thu, 05 July 2012	14	4224	Fri, 06 July 2012 03:06 By: Michel Cadot
Query running slow 11.2.0.2.5 , Solaris 10 By: getzeeshan on Thu, 05 July 2012	1	447	Thu, 05 July 2012 17:08 By: BlackSwan
How to find out who is the locking SQL statement? Oracle Database 11g Release 11.2.0.1.0 - 64bit Production By: Andrey_R on Wed, 04 July 2012	13	1470	Wed, 04 July 2012 13:16 By: Andrey_R
Investigating sudden Temp Tablespace growth from AWR? Oracle 10.2.0.4 By: orapratap on Wed, 04 July 2012	0	1291	Wed, 04 July 2012 05:24 By: orapratap
use_hash hint without arguments Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Tue, 03 July 2012	3	987	Wed, 04 July 2012 01:52 By: Michel Cadot
partition pruning oracle 10.2 By: guddu_12 on Tue, 03 July 2012	2	641	Tue, 03 July 2012 06:44 By: guddu_12
Slow db performance on Oracle 11.2.0.3 Oracle 11.2.0..3, Linux By: u570744 on Sat, 30 June 2012	6	8597	Mon, 02 July 2012 11:28 By: LNossov
SGA related queries Oracle 10.1.0.2.0 By: charuamit on Sat, 30 June 2012	4	888	Sat, 30 June 2012 01:50 By: charuamit
tools for monitoring the load of the db oracle 10g By: crocuta on Fri, 03 December 2010	4	938	Fri, 29 June 2012 21:24 By: alan.kendall@nfl.com
Performance issue Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ,Windows XP By: a_oracle on Thu, 14 June 2012	6	619	Fri, 29 June 2012 02:22 By: John Watson
how to reduce dml locks? oracle 11.2.0.1.0,windows server 2008 R2 By: vijenderkdba on Thu, 24 May 2012	6	1443	Thu, 28 June 2012 23:22 By: Michel Cadot
Tuning Queries Oracle 10.1.0.2 By: arif_md2009 on Wed, 16 May 2012	13	1036	Thu, 28 June 2012 15:44 By: alan.kendall@nfl.com
redo size Oracle version 11.2.0.2.0, OS AIX basedSystems(64 bit) By: ashishrnv on Mon, 18 June 2012	18	3339	Thu, 28 June 2012 14:29 By: BlackSwan
Value for sga_target Oracle 10.2.0.4.0 on AIX 5.3 By: raj9999 on Fri, 15 June 2012	8	2128	Wed, 27 June 2012 23:15 By: Michel Cadot
a table deleted or updated frequency issue By: andy huang on Thu, 14 June 2012	8	733	Wed, 27 June 2012 19:09 By: alan.kendall@nfl.com
Outer join causes much slower performance By: projecttoday on Tue, 26 June 2012	3	727	Wed, 27 June 2012 10:00 By: BlackSwan
performance improvement of clob data oracle 10.2.0.5 solaris 64 bit By: guddu_12 on Tue, 26 June 2012	1	770	Tue, 26 June 2012 07:04 By: Michel Cadot
SGA related queries By: charuamit on Mon, 25 June 2012	1	764	Mon, 25 June 2012 05:12 By: Michel Cadot