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

    Replies Views Last message
  performance tuning on SQL Queries
sql developer
By: Ganesh S on Tue, 26 February 2013
1 600 Tue, 26 February 2013 03:57
By: Michel Cadot
  SQL ordered by Elapsed Time & SQL Module
10g & AIX 6.1
By: gatetec on Sun, 24 February 2013
5 836 Sun, 24 February 2013 08:43
By: BlackSwan
  DELETE taking long time
10g r2
By: guddu_12 on Fri, 22 February 2013
2 636 Fri, 22 February 2013 07:49
By: guddu_12
  Please help me in rewriting the below query in optimized way
Oracle 11g
By: vikram1780 on Wed, 23 January 2013
29 1696 Thu, 21 February 2013 19:20
By: vikram1780
  Query Sql Server faster than Oracle
oracle 10g
By: ltubio on Thu, 21 February 2013
1 661 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 1591 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 645 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 547 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 1239 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 358 Wed, 13 February 2013 13:21
By: BlackSwan
  Oracle Statistics
Oracle 11g2.0.3
By: Rumak18 on Tue, 29 January 2013
16 1789 Mon, 11 February 2013 07:15
By: John Watson
  Server Specification
Capacity Building
By: emorka on Thu, 10 January 2013
7 2694 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 1019 Thu, 07 February 2013 03:55
By: Michel Cadot
  SQL ordered by Elapsed Time
10g
By: gatetec on Sat, 02 February 2013
9 7895 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 1855 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 942 Thu, 24 January 2013 21:41
By: alantany
  Physical Reads & Logical Reads
10g
By: gatetec on Fri, 18 January 2013
9 2231 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 1278 Tue, 15 January 2013 09:29
By: alantany
icon5.gif Tune a cursor
By: cherryreddi on Mon, 14 January 2013
3 778 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 687 Fri, 11 January 2013 08:33
By: Michel Cadot
  cpu utilizaton
By: maninderkrb on Tue, 08 January 2013
6 767 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 779 Mon, 07 January 2013 16:12
By: LNossov
  Need the Tuinng Tips for Tuning The package
By: mvrkr44 on Mon, 07 January 2013
5 597 Mon, 07 January 2013 01:55
By: Michel Cadot
  Extended Statistics
By: alantany on Thu, 03 January 2013
12 1165 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 1409 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 1179 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 1595 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 5248 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 935 Thu, 03 January 2013 07:03
By: John Watson
  Sql Running Slowly
9i
By: snehal123 on Mon, 31 December 2012
11 869 Wed, 02 January 2013 09:55
By: LNossov
  Tuning the sql query
10.2.0.4
By: grpatwari on Wed, 05 December 2012
29 2265 Tue, 01 January 2013 23:31
By: grpatwari
  indexing
Oracle 10g
By: arif_md2009 on Fri, 21 December 2012
5 870 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 4037 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 853 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 882 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 1330 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 1185 Mon, 17 December 2012 17:14
By: LNossov
  SQL Tuning...?
Oracle 10G
By: gblackiv on Thu, 13 December 2012
6 685 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 870 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 1419 Tue, 11 December 2012 06:40
By: Michel Cadot
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: Thu Nov 27 14:17:50 CST 2014

Total time taken to generate the page: 0.14993 seconds