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

    Replies Views Last message
  One job is hanging after SGA increase
ORACLE 10.2.0.3 HP UX 11.31
By: syed.samiullah on Mon, 11 March 2013
15 1597 Tue, 12 March 2013 16:53
By: alan.kendall@nfl.com
  Hybrid Columnar Compression
ORACLE Exadata V2 and V3, 11.2.0.2 , Linux
By: pzlj6x on Mon, 04 March 2013
2 872 Tue, 05 March 2013 01:55
By: John Watson
  PARALLEL when I don't want it
By: scottwmackey on Fri, 01 March 2013
9 1425 Mon, 04 March 2013 02:51
By: Michel Cadot
  problem with statspack
By: thorin666 on Tue, 11 September 2007
13 4742 Sun, 03 March 2013 03:23
By: Michel Cadot
  Explain plan - cost(CPU%)
10g, 10.2.0.5, windows
By: ishika_20 on Tue, 26 February 2013
17 1608 Sat, 02 March 2013 04:05
By: ishika_20
  Query Re-write for connect by
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: manubatham20 on Fri, 01 March 2013
0 1339 Fri, 01 March 2013 09:43
By: manubatham20
  performance tuning on SQL Queries
sql developer
By: Ganesh S on Tue, 26 February 2013
1 822 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 1308 Sun, 24 February 2013 08:43
By: BlackSwan
  DELETE taking long time
10g r2
By: guddu_12 on Fri, 22 February 2013
2 923 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 2149 Thu, 21 February 2013 19:20
By: vikram1780
  Query Sql Server faster than Oracle
oracle 10g
By: ltubio on Thu, 21 February 2013
1 1027 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 2408 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 986 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 788 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 1667 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 568 Wed, 13 February 2013 13:21
By: BlackSwan
  Oracle Statistics
Oracle 11g2.0.3
By: Rumak18 on Tue, 29 January 2013
16 2310 Mon, 11 February 2013 07:15
By: John Watson
  Server Specification
Capacity Building
By: emorka on Thu, 10 January 2013
7 3026 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 1609 Thu, 07 February 2013 03:55
By: Michel Cadot
  SQL ordered by Elapsed Time
10g
By: gatetec on Sat, 02 February 2013
9 13165 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 2442 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 1361 Thu, 24 January 2013 21:41
By: alantany
  Physical Reads & Logical Reads
10g
By: gatetec on Fri, 18 January 2013
9 3340 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 1898 Tue, 15 January 2013 09:29
By: alantany
icon5.gif Tune a cursor
By: cherryreddi on Mon, 14 January 2013
3 1091 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 959 Fri, 11 January 2013 08:33
By: Michel Cadot
  cpu utilizaton
By: maninderkrb on Tue, 08 January 2013
6 1009 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 1180 Mon, 07 January 2013 16:12
By: LNossov
  Need the Tuinng Tips for Tuning The package
By: mvrkr44 on Mon, 07 January 2013
5 810 Mon, 07 January 2013 01:55
By: Michel Cadot
  Extended Statistics
By: alantany on Thu, 03 January 2013
12 1696 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 2300 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 1687 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 2331 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 8091 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 1465 Thu, 03 January 2013 07:03
By: John Watson
  Sql Running Slowly
9i
By: snehal123 on Mon, 31 December 2012
11 1232 Wed, 02 January 2013 09:55
By: LNossov
  Tuning the sql query
10.2.0.4
By: grpatwari on Wed, 05 December 2012
29 2744 Tue, 01 January 2013 23:31
By: grpatwari
  indexing
Oracle 10g
By: arif_md2009 on Fri, 21 December 2012
5 1090 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 7243 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 1301 Mon, 24 December 2012 08:38
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: Wed Jul 27 14:29:07 CDT 2016

Total time taken to generate the page: 0.11334 seconds