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
ASH Report Oracle 11G,Linux 5 By: saagar on Wed, 12 September 2012	7	3041	Wed, 12 September 2012 23:50 By: Michel Cadot
tuning stats command ORACLE 11GR2 SOLARIS By: guddu_12 on Tue, 11 September 2012	1	2360	Tue, 11 September 2012 04:39 By: Michel Cadot
Tuning issue Oracle 10.0.2.1 By: arif_md2009 on Thu, 06 September 2012	4	2538	Sat, 08 September 2012 16:36 By: arif_md2009
Explain plan of a query Oracle 11g By: sathik on Wed, 05 September 2012	16	5593	Fri, 07 September 2012 07:52 By: BlackSwan
Slow running query (3 Merged) Oracle 11g By: brown_zzz on Wed, 05 September 2012	4	3827	Wed, 05 September 2012 11:57 By: BlackSwan
How to Control concurrent Inserts of a record by parallel sessions Oracle 10.2.0.4 By: orapratap on Tue, 07 August 2012	4	3318	Fri, 31 August 2012 21:38 By: Kevin Meade
ORA-01652-unable to extend temp segment by 128 in tablespace TEMP 11.1.0.7.0 By: Scowron on Wed, 25 July 2012	10	15637	Thu, 30 August 2012 15:25 By: wakula
SQL Tuning Assistance Required Oracle 10.2.0.3, PeopleSoft 8.8, PeopleTools 8.49 By: SBhaumik_DBA on Tue, 28 August 2012	6	4710	Tue, 28 August 2012 06:35 By: cookiemonster
index behaviour 11.2.0.3.0 By: piotrtal on Sat, 25 August 2012	6	4033	Sun, 26 August 2012 09:30 By: BlackSwan
restart database after increase the db_cache_size? oracle 10.2.0.4 , sun solaris 5.10 64bit By: shmily2012 on Thu, 23 August 2012	6	17933	Fri, 24 August 2012 14:11 By: alan.kendall@nfl.com
Frequent changed table stats problem Oracle 10.2.0.4, AIX 5.3 64bit By: snowball on Mon, 06 August 2012	10	4577	Wed, 22 August 2012 01:14 By: LNossov
SQL Statement taking too long (merged 3) Oracle 11.2.0, AIX 6.1 (64bit) By: Creems on Tue, 21 August 2012	5	3313	Tue, 21 August 2012 16:52 By: Creems
Slow query with full table scan ORACLE 11 By: brown_zzz on Sat, 18 August 2012	16	8284	Tue, 21 August 2012 09:36 By: Kevin Meade
Performance Issue while truncating table partition. (3 Merged) Oracle 11g , Linux By: palanisvr on Tue, 24 July 2012	2	4135	Tue, 21 August 2012 06:30 By: Kevin Meade
dbms_xplan.display_cursor Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Mon, 20 August 2012	4	3608	Mon, 20 August 2012 13:50 By: John Watson
Same query with different Explain Plan in two Database Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 By: prashanth7582 on Fri, 17 August 2012	4	4561	Fri, 17 August 2012 08:18 By: prashanth7582
Re: Get Unique row number for list of values (split from unrelated thread by bb) By: prashanth7582 on Fri, 17 August 2012	0	2240	Fri, 17 August 2012 06:23 By: prashanth7582
query recommedation Oracle 10.2.0.4 solaris 2.10 By: BeefStu on Thu, 16 August 2012	2	2055	Fri, 17 August 2012 01:36 By: Michel Cadot
how to find all indexes scripts in particular schema Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi By: msol25 on Thu, 16 August 2012	4	4928	Fri, 17 August 2012 01:34 By: Michel Cadot
Buffer_gets/Buffer_cache Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Mon, 13 August 2012	22	6210	Thu, 16 August 2012 06:34 By: cookiemonster
Need help with Queries ( 1 2 3) By: supiash on Sat, 19 May 2012	105	9664	Tue, 14 August 2012 15:20 By: Barbara Boehmer
Query tuning help 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production By: knw15pwr on Fri, 10 August 2012	7	3677	Mon, 13 August 2012 18:12 By: alan.kendall@nfl.com
Analyzed table Oracle 8i By: shyamu on Thu, 09 August 2012	2	2091	Sat, 11 August 2012 10:38 By: BlackSwan
How to determine slowness in I/O from AWR? Oracle 11.2.0.3.0 By: orapratap on Thu, 09 August 2012	5	11213	Thu, 09 August 2012 13:24 By: alan.kendall@nfl.com
Table actual size oracle 10g By: savugar on Thu, 09 August 2012	6	3365	Thu, 09 August 2012 10:30 By: Michel Cadot
get AWR report data Oracle,10.2.0.4 By: savugar on Wed, 08 August 2012	6	3322	Thu, 09 August 2012 02:45 By: savugar
Increased LOGFILE did not increase performance Toad 9.5, Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production, Windows Server 2003 R2 By: RedFux on Mon, 06 August 2012	12	12813	Wed, 08 August 2012 15:46 By: alan.kendall@nfl.com
Cannot find TraceFile for SESSION Oracle Database 11g Release 11.1.0.7.0 - 64bit Production Windows By: Andrey_R on Mon, 06 August 2012	0	2210	Mon, 06 August 2012 03:17 By: Andrey_R
Performance difference of same query in 2 database Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi, Solaris By: sasnrock on Tue, 24 July 2012	4	2883	Sat, 04 August 2012 13:44 By: Kevin Meade
Not exists inside exists is having very low performence By: narsimha6 on Thu, 02 August 2012	2	2513	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	2930	Thu, 02 August 2012 06:25 By: cookiemonster
connect database By: sirumon on Mon, 19 December 2011	13	3840	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	9894	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	2986	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	3710	Mon, 23 July 2012 16:41 By: alan.kendall@nfl.com
SQL optimisation By: rachcha on Mon, 23 July 2012	1	3321	Mon, 23 July 2012 11:48 By: Michel Cadot
Sentence tuning Oracle9i By: estonolose on Wed, 04 July 2012	7	5147	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	9177	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	10692	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	2885	Tue, 17 July 2012 21:21 By: alan.kendall@nfl.com