Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Please help me in rewriting the below query in optimized way
Oracle 11g
By: vikram1780 on Wed, 23 January 2013
29 1596 Thu, 21 February 2013 19:20
By: vikram1780
  Query Sql Server faster than Oracle
oracle 10g
By: ltubio on Thu, 21 February 2013
1 609 Thu, 21 February 2013 03:09
By: Michel Cadot
  Joins and in-line views
Oracle 11.2
By: lakshmis on Mon, 03 December 2012
8 1410 Mon, 18 February 2013 03:18
By: TuneMyQuery
icon14.gif Improve DDL operation performance (2 Merged)
oracle, 11.2.0.2, AIX6.1
By: soft_doctor on Thu, 14 February 2013
2 593 Thu, 14 February 2013 09:46
By: cookiemonster
  Collection count high in Memory
11.2.0.3.0
By: rishwinger on Wed, 13 February 2013
4 502 Thu, 14 February 2013 01:16
By: Michel Cadot
  LONG to CLOB conversion in huge tables
11g 11.2.0.3
By: gnmurthy86 on Fri, 25 January 2013
6 1144 Wed, 13 February 2013 16:59
By: xtender
  Loading and reading at the sametime
Oracle 10g and 11g both
By: babhuko on Wed, 13 February 2013
1 331 Wed, 13 February 2013 13:21
By: BlackSwan
  Oracle Statistics
Oracle 11g2.0.3
By: Rumak18 on Tue, 29 January 2013
16 1680 Mon, 11 February 2013 07:15
By: John Watson
  Server Specification
Capacity Building
By: emorka on Thu, 10 January 2013
7 2606 Sat, 09 February 2013 10:31
By: vamsi kasina
  ADDM Report
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production on LINUX 32bit server
By: crussed_sonu on Thu, 07 February 2013
8 905 Thu, 07 February 2013 03:55
By: Michel Cadot
  SQL ordered by Elapsed Time
10g
By: gatetec on Sat, 02 February 2013
9 6689 Mon, 04 February 2013 12:53
By: Michel Cadot
  How can we verify the statistic info is not good
Oracle 10.2 , 11.2 , AIX, Linux
By: snowball on Wed, 23 January 2013
16 1756 Thu, 31 January 2013 05:14
By: snowball
  what's mean of plh in SQL_TRACE?
11gr2
By: alantany on Thu, 24 January 2013
4 854 Thu, 24 January 2013 21:41
By: alantany
  Physical Reads & Logical Reads
10g
By: gatetec on Fri, 18 January 2013
9 1994 Tue, 22 January 2013 17:57
By: alan.kendall@nfl.com
  does 11g not do a soft parse when we set cursor_cached_curosr?
11gr2
By: alantany on Tue, 15 January 2013
4 1134 Tue, 15 January 2013 09:29
By: alantany
icon5.gif Tune a cursor
By: cherryreddi on Mon, 14 January 2013
3 726 Mon, 14 January 2013 14:46
By: xtender
  AWR Baseline in RAC
Oracle 10.2.0.3 on AIX
By: sysdba007 on Fri, 11 January 2013
1 629 Fri, 11 January 2013 08:33
By: Michel Cadot
  cpu utilizaton
By: maninderkrb on Tue, 08 January 2013
6 712 Tue, 08 January 2013 08:41
By: BlackSwan
  num_rows on user_indexes vs table_indexes
11.2 AIX 6.1
By: tom_watson on Mon, 07 January 2013
5 722 Mon, 07 January 2013 16:12
By: LNossov
  Need the Tuinng Tips for Tuning The package
By: mvrkr44 on Mon, 07 January 2013
5 551 Mon, 07 January 2013 01:55
By: Michel Cadot
  Extended Statistics
By: alantany on Thu, 03 January 2013
12 1023 Fri, 04 January 2013 23:40
By: alantany
  CURRENT_OBJ# -1 in v$active_session_history
By: tom_watson on Thu, 03 January 2013
8 1236 Fri, 04 January 2013 05:41
By: Michel Cadot
  suggestion for increasing the buffer cache
Oracle, 9.2.0.8, sunOS
By: savugar on Fri, 30 November 2012
11 1077 Fri, 04 January 2013 00:59
By: Michel Cadot
  SQL Plan Baseline Trouble!!!
Oracle 11.2.0.3.0 & Oracle 10.2.0.1.0
By: rishwinger on Thu, 03 January 2013
9 1422 Thu, 03 January 2013 22:33
By: rishwinger
  Memory_target and sga_target in oracle 11gR2
Linux, Oracle 11g, 11.2.0
By: suresh.wst on Sat, 29 December 2012
6 4397 Thu, 03 January 2013 19:32
By: alan.kendall@nfl.com
  OCI client result cache
11.2.x
By: John Watson on Wed, 02 January 2013
4 804 Thu, 03 January 2013 07:03
By: John Watson
  Sql Running Slowly
9i
By: snehal123 on Mon, 31 December 2012
11 796 Wed, 02 January 2013 09:55
By: LNossov
  Tuning the sql query
10.2.0.4
By: grpatwari on Wed, 05 December 2012
29 2140 Tue, 01 January 2013 23:31
By: grpatwari
  indexing
Oracle 10g
By: arif_md2009 on Fri, 21 December 2012
5 819 Sat, 29 December 2012 03:26
By: arif_md2009
  Sql query taking High CPU and execution time in oracle 11gR2
Oracle 11g R2
By: pappu123 on Mon, 24 December 2012
15 3410 Wed, 26 December 2012 23:49
By: BlackSwan
  Help in tuning the query
Oracle DB, 11.1.0.7.0, AIX 6
By: kiranpuli on Mon, 24 December 2012
6 781 Mon, 24 December 2012 08:38
By: Michel Cadot
  what's operation can cause these wait event?
By: lonion on Thu, 06 December 2012
2 768 Wed, 19 December 2012 12:45
By: alan.kendall@nfl.com
  Adaptive cursor sharing Doubt!!
Oracle 11g (11.2.0.3.0 ) - Linux
By: rishwinger on Tue, 18 December 2012
10 1189 Wed, 19 December 2012 04:52
By: rishwinger
  How to run a query with an different plan_hash value then in GV$SQL_PLAN
Oracle 10.2.0.4.0 RAC on Linux
By: Andrey_R on Tue, 27 November 2012
2 1086 Mon, 17 December 2012 17:14
By: LNossov
  SQL Tuning...?
Oracle 10G
By: gblackiv on Thu, 13 December 2012
6 624 Thu, 13 December 2012 10:41
By: cookiemonster
  Please help me on tune this query
Oracle 11g
By: ajaykumarkona on Mon, 10 December 2012
8 805 Wed, 12 December 2012 11:50
By: Kevin Meade
  RBS usage and longops in toad
By: nunnaravi@yahoo.com on Tue, 11 December 2012
1 1157 Tue, 11 December 2012 06:40
By: Michel Cadot
  Please help me to tune this query
Oracle 11g
By: ajaykumarkona on Tue, 04 December 2012
2 930 Wed, 05 December 2012 14:35
By: Flyby
  need more memory for hash joins
9i / 10g / 11gR2
By: Kevin Meade on Wed, 28 November 2012
5 2920 Tue, 04 December 2012 21:03
By: Kevin Meade
  Help in Oracle Query Optimization
Oracle 10g
By: sanand7984 on Tue, 04 December 2012
3 758 Tue, 04 December 2012 17:01
By: Kevin Meade
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Wed Jul 30 16:16:01 CDT 2014

Total time taken to generate the page: 0.26117 seconds