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
NOLOGGING in Oracle 11gr2 Oracle 11gr2 Server 2008r2 By: segan1415 on Tue, 16 October 2012	26	21638	Thu, 18 October 2012 09:18 By: segan1415
Improve performance postgre By: perfectioi on Wed, 10 October 2012	4	2559	Wed, 10 October 2012 11:39 By: BlackSwan
SSL on database connections Oracle EE ver 11, linux By: ndg123 on Wed, 10 October 2012	4	1834	Wed, 10 October 2012 05:36 By: ndg123
cluter in index oracle 11gr2 By: guddu_12 on Thu, 04 October 2012	4	1674	Fri, 05 October 2012 17:19 By: rleishman
Is this a bug on Oracle11gr2? 11gr2 By: alantany on Tue, 25 September 2012	5	3221	Thu, 04 October 2012 15:20 By: Flyby
Help required for tuning referring AWR Reports Oracle 10.2.0.4.0 on linux By: orapratap on Thu, 30 August 2012	5	5105	Thu, 04 October 2012 02:17 By: Roachcoach
how to tune 100s of transactions over single table By: kamilp on Mon, 24 September 2012	10	3637	Tue, 02 October 2012 17:24 By: alan.kendall@nfl.com
What does analyzing a table do for the indexes ? Oracle 11g Win 7 By: jxh461 on Wed, 26 September 2012	2	3393	Tue, 02 October 2012 16:48 By: alan.kendall@nfl.com
appropriate memory Oracle 11g/ 10g/ 9i - Solaris 10 By: reym21 on Sun, 16 September 2012	6	3034	Mon, 24 September 2012 19:39 By: reym21
Analytics and Predicate Pushing 9i/10g/11g By: Kevin Meade on Thu, 20 September 2012	18	5518	Mon, 24 September 2012 08:14 By: Kevin Meade
dbms_stats.gather_index_stats vs dbms_stats.gather_table_stats 11.2.0.1 By: c_stenersen on Fri, 21 September 2012	2	6517	Fri, 21 September 2012 06:28 By: c_stenersen
HIBERNATE query runs slow but ok in SQLPLUS Oracle 11g By: brown_zzz on Fri, 14 September 2012	7	4974	Tue, 18 September 2012 14:20 By: alan.kendall@nfl.com
Remove SQL*Net waitevent from top 5 list Oracle 11.2.0.2 By: sathik on Mon, 17 September 2012	11	4631	Tue, 18 September 2012 14:04 By: Littlefoot
FOR Loop and Driving Site Oracle 11g By: wmgonzalbo on Tue, 18 September 2012	1	1834	Tue, 18 September 2012 04:21 By: Michel Cadot
inbound connection timed out (ORA-3136) ORACLE DB 10g(64 bit) R2 By: p.anshuman1 on Thu, 24 May 2012	4	9176	Mon, 17 September 2012 13:09 By: Michel Cadot
Improve procedure's performance By: suryay22 on Fri, 14 September 2012	7	2480	Sun, 16 September 2012 14:43 By: Kevin Meade
Help needed to tune the SQL (merged 2) By: parthaspaul on Thu, 06 September 2012	7	2956	Sun, 16 September 2012 11:03 By: Kevin Meade
ASH Report Oracle 11G,Linux 5 By: saagar on Wed, 12 September 2012	7	2217	Wed, 12 September 2012 23:50 By: Michel Cadot
tuning stats command ORACLE 11GR2 SOLARIS By: guddu_12 on Tue, 11 September 2012	1	1565	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	1730	Sat, 08 September 2012 16:36 By: arif_md2009
Explain plan of a query Oracle 11g By: sathik on Wed, 05 September 2012	16	4704	Fri, 07 September 2012 07:52 By: BlackSwan
Slow running query (3 Merged) Oracle 11g By: brown_zzz on Wed, 05 September 2012	4	2902	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	2140	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	14213	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	3606	Tue, 28 August 2012 06:35 By: cookiemonster
index behaviour 11.2.0.3.0 By: piotrtal on Sat, 25 August 2012	6	3024	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	13922	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	3503	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	1968	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	7046	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	3184	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	2858	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	3679	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	1437	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	1330	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	4180	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	5301	Thu, 16 August 2012 06:34 By: cookiemonster
Need help with Queries ( 1 2 3) By: supiash on Sat, 19 May 2012	105	8046	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	2957	Mon, 13 August 2012 18:12 By: alan.kendall@nfl.com
Analyzed table Oracle 8i By: shyamu on Thu, 09 August 2012	2	1418	Sat, 11 August 2012 10:38 By: BlackSwan