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
Options for optimising SQL running against Wide tables 11g By: jasontilbury on Tue, 13 November 2012	9	4311	Mon, 19 November 2012 15:16 By: rleishman
dba_hist_sqlstat 11.2.0.3 \|\| Solaris By: Roachcoach on Mon, 12 November 2012	5	7051	Wed, 14 November 2012 20:16 By: alan.kendall@nfl.com
Slow Join between dba_tab_cols and dba_types By: ocdeveloper on Wed, 14 November 2012	1	3360	Wed, 14 November 2012 13:20 By: BlackSwan
Alternate Query instead of querying the table twice Oracle 11G,R2 By: prashanth7582 on Sun, 11 November 2012	5	3298	Wed, 14 November 2012 08:29 By: Kevin Meade
Tuning SELECT-WHERE-BETWEEN Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 By: rop4 on Mon, 12 November 2012	4	3137	Tue, 13 November 2012 05:52 By: rleishman
how to examine the impact of a too long varchar2 field Oracle Database 10g R2 By: beingman on Tue, 06 November 2012	13	3753	Mon, 12 November 2012 12:56 By: Kevin Meade
Long running query Oracle 11.2 By: lakshmis on Tue, 06 November 2012	9	3288	Sun, 11 November 2012 23:50 By: lakshmis
Table rebuild should be done after removing most of its data? Oracle 10.2.0.4 on Solaris 10 By: orausern on Tue, 23 October 2012	4	4517	Mon, 05 November 2012 17:47 By: alan.kendall@nfl.com
Performance degrades as dB size increases Oracle 11gr2 Server 2008r2 By: segan1415 on Thu, 01 November 2012	1	3081	Fri, 02 November 2012 03:52 By: John Watson
SQL execution plan different on different hardware Oracle 11gR2, AIX By: hjoshi on Wed, 31 October 2012	3	2839	Thu, 01 November 2012 02:36 By: John Watson
NESTED LOOPS JOIN and DISTRIBUTED OPERATIONS 9i/10g/11g By: Kevin Meade on Tue, 30 October 2012	5	3289	Wed, 31 October 2012 08:13 By: Kevin Meade
Merge Join Cartesian in Outline Data Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Wed, 31 October 2012	0	2937	Wed, 31 October 2012 06:47 By: manubatham20
[11g]Direct-path insert / temp usage / PGA Oracle 11gr2 / linux 2.6 x86_64 By: nikko on Tue, 30 October 2012	3	4781	Wed, 31 October 2012 04:19 By: nikko
How tune the following query? Oracle 9i By: kumar_hi21@yahoo.com on Tue, 23 October 2012	4	6350	Mon, 29 October 2012 23:05 By: Kevin Meade
How Oracle optimizer choose joins (hash, Merge & nested loop join) By: ukumarjsr2 on Thu, 18 October 2012	2	3485	Mon, 29 October 2012 22:56 By: Kevin Meade
Proper index is not used ... Oracle, 11.2.0.2, Linux 5.5 By: ardhendu on Wed, 17 October 2012	4	3151	Fri, 19 October 2012 05:07 By: ardhendu
incremental stats not happening ORACLE 11GR2 SOLARIS By: guddu_12 on Mon, 15 October 2012	3	2433	Thu, 18 October 2012 12:28 By: Littlefoot
NOLOGGING in Oracle 11gr2 Oracle 11gr2 Server 2008r2 By: segan1415 on Tue, 16 October 2012	26	23099	Thu, 18 October 2012 09:18 By: segan1415
Improve performance postgre By: perfectioi on Wed, 10 October 2012	4	3417	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	2452	Wed, 10 October 2012 05:36 By: ndg123
cluter in index oracle 11gr2 By: guddu_12 on Thu, 04 October 2012	4	2447	Fri, 05 October 2012 17:19 By: rleishman
Is this a bug on Oracle11gr2? 11gr2 By: alantany on Tue, 25 September 2012	5	4057	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	5681	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	4606	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	3845	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	3990	Mon, 24 September 2012 19:39 By: reym21
Analytics and Predicate Pushing 9i/10g/11g By: Kevin Meade on Thu, 20 September 2012	18	7807	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	7385	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	5576	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	5238	Tue, 18 September 2012 14:04 By: Littlefoot
FOR Loop and Driving Site Oracle 11g By: wmgonzalbo on Tue, 18 September 2012	1	2267	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	9904	Mon, 17 September 2012 13:09 By: Michel Cadot
Improve procedure's performance By: suryay22 on Fri, 14 September 2012	7	2914	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	3419	Sun, 16 September 2012 11:03 By: Kevin Meade
ASH Report Oracle 11G,Linux 5 By: saagar on Wed, 12 September 2012	7	2637	Wed, 12 September 2012 23:50 By: Michel Cadot
tuning stats command ORACLE 11GR2 SOLARIS By: guddu_12 on Tue, 11 September 2012	1	1966	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	2138	Sat, 08 September 2012 16:36 By: arif_md2009
Explain plan of a query Oracle 11g By: sathik on Wed, 05 September 2012	16	5200	Fri, 07 September 2012 07:52 By: BlackSwan
Slow running query (3 Merged) Oracle 11g By: brown_zzz on Wed, 05 September 2012	4	3436	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	2845	Fri, 31 August 2012 21:38 By: Kevin Meade