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

    Replies Views Last message
  Loading and reading at the sametime
Oracle 10g and 11g both
By: babhuko on Wed, 13 February 2013
1 353 Wed, 13 February 2013 13:21
By: BlackSwan
  Oracle Statistics
Oracle 11g2.0.3
By: Rumak18 on Tue, 29 January 2013
16 1767 Mon, 11 February 2013 07:15
By: John Watson
  Server Specification
Capacity Building
By: emorka on Thu, 10 January 2013
7 2678 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 987 Thu, 07 February 2013 03:55
By: Michel Cadot
  SQL ordered by Elapsed Time
10g
By: gatetec on Sat, 02 February 2013
9 7594 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 1824 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 927 Thu, 24 January 2013 21:41
By: alantany
  Physical Reads & Logical Reads
10g
By: gatetec on Fri, 18 January 2013
9 2167 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 1248 Tue, 15 January 2013 09:29
By: alantany
icon5.gif Tune a cursor
By: cherryreddi on Mon, 14 January 2013
3 766 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 670 Fri, 11 January 2013 08:33
By: Michel Cadot
  cpu utilizaton
By: maninderkrb on Tue, 08 January 2013
6 750 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 763 Mon, 07 January 2013 16:12
By: LNossov
  Need the Tuinng Tips for Tuning The package
By: mvrkr44 on Mon, 07 January 2013
5 587 Mon, 07 January 2013 01:55
By: Michel Cadot
  Extended Statistics
By: alantany on Thu, 03 January 2013
12 1125 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 1364 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 1156 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 1553 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 5034 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 912 Thu, 03 January 2013 07:03
By: John Watson
  Sql Running Slowly
9i
By: snehal123 on Mon, 31 December 2012
11 847 Wed, 02 January 2013 09:55
By: LNossov
  Tuning the sql query
10.2.0.4
By: grpatwari on Wed, 05 December 2012
29 2235 Tue, 01 January 2013 23:31
By: grpatwari
  indexing
Oracle 10g
By: arif_md2009 on Fri, 21 December 2012
5 858 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 3896 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 826 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 849 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 1302 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 1166 Mon, 17 December 2012 17:14
By: LNossov
  SQL Tuning...?
Oracle 10G
By: gblackiv on Thu, 13 December 2012
6 669 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 853 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 1357 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 987 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 3333 Tue, 04 December 2012 21:03
By: Kevin Meade
  Help in Oracle Query Optimization
Oracle 10g
By: sanand7984 on Tue, 04 December 2012
3 800 Tue, 04 December 2012 17:01
By: Kevin Meade
  Parallel Feature
11g R2
By: TRaj on Tue, 04 December 2012
1 418 Tue, 04 December 2012 09:50
By: BlackSwan
  Checkpoint not complete
By: David King on Thu, 15 September 2005
6 20723 Sat, 01 December 2012 19:51
By: alliejane
  Bloom filters
11.2.0.3
By: John Watson on Fri, 30 November 2012
0 1463 Fri, 30 November 2012 02:35
By: John Watson
  Database Reorganisation
Oracle 10g, IBM AIX 5.3
By: oradba123 on Sat, 15 October 2011
2 870 Fri, 30 November 2012 01:09
By: atcharao
  Top 5 long running using DBA_* hist views
Oracle 11g, Linux
By: ram anand on Wed, 28 November 2012
1 424 Wed, 28 November 2012 07:40
By: Michel Cadot
  Tune the materialized view
10.2.4.0
By: grpatwari on Thu, 15 November 2012
13 1784 Wed, 28 November 2012 03:22
By: grpatwari
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: Fri Oct 31 11:34:34 CDT 2014

Total time taken to generate the page: 0.11673 seconds