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

    Replies Views Last message
  Set NOLOGGING for tables in UAT
windows 2012, oracle 12c
By: muktha_22 on Wed, 20 May 2015
6 700 Thu, 21 May 2015 09:24
By: bpeasland
  Find cpu MHz in Oracle view
Linux red hat 6.6, oracle 11.2.0.4
By: Malakay79 on Thu, 14 May 2015
2 504 Thu, 14 May 2015 08:01
By: BlackSwan
  ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION - Kevin Meade's book corner
By: paolfili on Sun, 19 April 2015
9 1755 Tue, 12 May 2015 10:29
By: paolfili
  How to check index is re-built
11g, 11.2.0.3, Window server
By: ashishkumarmahanta80 on Thu, 30 April 2015
3 609 Thu, 30 April 2015 02:21
By: ashishkumarmahanta80
  Query running very slow
oracle 9i, windows 2003 server
By: zkdba on Thu, 16 April 2015
5 932 Sun, 19 April 2015 13:40
By: Kevin Meade
  Do we need to rebound instance when we Determine the Practical Range for FAST_START_MTTR_TARGET
11.2.0.3 Enterprise Edition
By: juniordbanewbie on Tue, 20 January 2015
3 1358 Fri, 17 April 2015 20:38
By: juniordbanewbie
  INDEX FULL SCAN (MIN/MAX)
11.2.0.3
By: Roachcoach on Mon, 06 April 2015
4 1178 Mon, 13 April 2015 02:35
By: Roachcoach
  indexing nulls
oracle 11.2.0.4 on Linux
By: orausern on Fri, 10 April 2015
6 913 Fri, 10 April 2015 11:24
By: Lalit Kumar B
  Index skip scan
11.2.0.4
By: Roachcoach on Thu, 02 April 2015
7 1078 Mon, 06 April 2015 02:41
By: Roachcoach
  performance
By: rameshk0316@gmail.com on Tue, 31 March 2015
2 508 Wed, 01 April 2015 00:15
By: Michel Cadot
  performance
By: rameshk0316@gmail.com on Tue, 31 March 2015
3 607 Tue, 31 March 2015 08:57
By: Michel Cadot
  ORA-00439: feature not enabled: Bit-mapped indexes
By: Sunil Bassi on Mon, 29 March 2004
14 23645 Tue, 31 March 2015 01:39
By: ramanakakarla
  Bind variable for date type takes longer time in a query
toad 10g
By: nciteamo on Fri, 20 March 2015
3 1016 Sun, 29 March 2015 07:53
By: Kevin Meade
  Image File Size
oracle 11 g
By: simplesanju on Tue, 24 March 2015
0 622 Tue, 24 March 2015 02:35
By: simplesanju
  Union (all) and outline hints
11.2.0.3
By: Roachcoach on Fri, 20 February 2015
3 955 Sat, 21 March 2015 04:05
By: billgate123
  CPU consumption calculation for sqls
Oracle 11.2.0.4, AIX 6.1
By: saurabhshukladba on Mon, 16 March 2015
1 698 Mon, 16 March 2015 11:27
By: Michel Cadot
  Compression benefits and options
Oracle 11.2.0.4 on Linux
By: orausern on Thu, 12 March 2015
8 843 Sun, 15 March 2015 12:27
By: orausern
  Information to provide when asking for tuning help.
By: Kevin Meade on Wed, 11 March 2015
0 568 Wed, 11 March 2015 20:43
By: Kevin Meade
  Same Data, Two machines but different timings. Why?
10.2.0.1.0
By: bluetooth420 on Mon, 09 March 2015
10 853 Tue, 10 March 2015 22:43
By: Kevin Meade
  Performance Monitor looked ugly
11.2.04
By: bvo65 on Wed, 07 January 2015
5 2716 Mon, 09 March 2015 07:42
By: paolfili
  Database today's load vs yesterday
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: ind9 on Thu, 05 March 2015
9 746 Fri, 06 March 2015 10:49
By: ind9
  The differential between Index hint and no hint
Oracle 10gr2, RHEL5
By: trantuananh24hg on Mon, 02 March 2015
4 625 Tue, 03 March 2015 01:51
By: trantuananh24hg
  v$service_stats information
Oracle 11.2.0.4 on Linux RH6
By: Malakay79 on Mon, 02 March 2015
6 699 Mon, 02 March 2015 03:25
By: Michel Cadot
  How to take OSWatcher baseline
11.2.0.3 SLES SP 3
By: juniordbanewbie on Fri, 27 February 2015
1 530 Fri, 27 February 2015 00:28
By: BlackSwan
  How to improve performance? (merged)
Oracle Database 11g Release 11.2.0.1.0 - Production, WINDOWS 7
By: mokarem on Tue, 17 February 2015
15 1119 Thu, 26 February 2015 01:30
By: mokarem
  Parallel direct path insert no quicker (merged 2 )
Oracle 11
By: brown_zzz on Tue, 24 February 2015
15 807 Tue, 24 February 2015 08:39
By: Roachcoach
  query to data dictionary tables taking long time
11.2.0.4 on Linux
By: orausern on Tue, 24 February 2015
6 650 Tue, 24 February 2015 04:32
By: John Watson
icon4.gif A oracle query causing 100% cpu utilization and blocking other sessions.
oracle 11g,(11.2.0.3), Sun Solaris
By: RamanaRocks on Sun, 22 February 2015
10 939 Mon, 23 February 2015 04:00
By: John Watson
  Execution plan
oracle,11.2.0.2,RHEL
By: Prathikesh on Thu, 12 February 2015
4 818 Fri, 20 February 2015 16:31
By: Kevin Meade
  Why does monitoring index fix performance?
Oracle Database/Forms 11g, Windows 7
By: nait1234 on Sun, 15 February 2015
8 932 Wed, 18 February 2015 15:04
By: Michel Cadot
  Alert log file size can impact database performance
10g, 10.2.0.1, window server 2008
By: ashishkumarmahanta80 on Tue, 10 February 2015
3 608 Tue, 10 February 2015 07:31
By: cookiemonster
  Updating text string to mask address characters
Oracle 11
By: brown_zzz on Thu, 05 February 2015
20 1440 Sun, 08 February 2015 23:42
By: FDAVIDOV
icon11.gif Oracle Database 11g 11.2.0.4.0 running slow
Oracle Database 11g 11.2.0.4.0
By: DevilzAdvocate on Sat, 03 January 2015
14 6096 Sat, 07 February 2015 17:02
By: LNossov
  update statement takes too long
11.2.0.1.0
By: OraFerro on Sun, 01 February 2015
16 1730 Sat, 07 February 2015 09:20
By: Kevin Meade
  what is ** TRANSIENT: 12029568
oracle db 11.2.0.3 on solaris
By: mshrkshl on Fri, 30 January 2015
2 997 Thu, 05 February 2015 03:13
By: Michel Cadot
  Explain plan
oracle 10g windows 7
By: hdba on Thu, 29 January 2015
10 811 Thu, 29 January 2015 06:26
By: hdba
  What should be recommended percentage of memory to be used for oracle
11.2.0.3 Standard Edition, SLES SP 3 64 bit
By: juniordbanewbie on Wed, 28 January 2015
6 1316 Thu, 29 January 2015 01:31
By: John Watson
  AWR - licensing question
By: piotrtal on Tue, 12 July 2011
28 8901 Mon, 19 January 2015 10:58
By: Kevin Meade
  Updating compressed rows
All with compression options
By: Roachcoach on Tue, 13 January 2015
0 1876 Tue, 13 January 2015 08:22
By: Roachcoach
  table lock in past
Oracle 10.2.0.4.0, Aix 6.1
By: oradba123 on Mon, 12 January 2015
7 807 Mon, 12 January 2015 13:42
By: BlackSwan
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: Tue Aug 30 14:19:41 CDT 2016

Total time taken to generate the page: 0.22168 seconds