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

    Replies Views Last message
  Cannot collect Top Frequency Histogram on column
Oracle 11.2.0.2.0 on Windows Server 2003
By: Andrey_R on Tue, 23 July 2013
3 1181 Thu, 25 July 2013 10:35
By: John Watson
  TDE Related Question
By: VIP2013 on Sat, 20 July 2013
4 948 Wed, 24 July 2013 11:33
By: VIP2013
  SQL Execution Plan Export/Import within 10.2.0.4 version databases
10.2.0.4 in AIX
By: TRaj on Tue, 16 July 2013
2 1899 Sun, 21 July 2013 14:27
By: Lalit Kumar B
  Exec plan explanation
11.2.0.3
By: John Watson on Fri, 19 July 2013
10 1471 Sun, 21 July 2013 07:55
By: Michel Cadot
  Different execution plan in Different DB
Oracle 10g
By: sss111ind on Sat, 20 July 2013
6 1111 Sun, 21 July 2013 05:22
By: Lalit Kumar B
  About NO_INDEX Hint
Oracle 11.2.0.3.0
By: mkdeepak87 on Thu, 18 July 2013
2 1477 Fri, 19 July 2013 03:43
By: John Watson
  Script to load Trace files errors to a Table
IBM AIX
By: user81 on Sat, 13 July 2013
3 746 Sat, 13 July 2013 14:38
By: Michel Cadot
  How to enable AWR in oracle 10g
10g, 10.2.0.1, windows XP
By: suman1986 on Fri, 12 July 2013
3 2803 Fri, 12 July 2013 06:10
By: suman1986
  Full Table scan - Query without where clause
11g, 11.2.0.5, AIX
By: ishika_20 on Thu, 11 July 2013
6 1372 Fri, 12 July 2013 00:10
By: ishika_20
  Simple query is taking long time
Oracle 11G
By: ajaykumarkona on Sat, 29 June 2013
16 2159 Tue, 09 July 2013 08:38
By: Kevin Meade
  Efficient Way to Alter Column For TDE.
By: VIP2013 on Thu, 04 July 2013
5 1096 Mon, 08 July 2013 05:51
By: VIP2013
  Oracle Performance Test Tools
Oracle 10.2, 11.2
By: snowball on Mon, 08 July 2013
6 902 Mon, 08 July 2013 05:34
By: snowball
  SQL & PL/SQL Performance Tuning
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 02 July 2013
1 850 Tue, 02 July 2013 07:27
By: Michel Cadot
  Histograms issue During DB Upgrade.
Oracle - 11.2.0.3 G
By: VIP2013 on Sat, 29 June 2013
3 1284 Mon, 01 July 2013 11:35
By: BlackSwan
  performance issue with the query
Oracle 11G
By: ajaykumarkona on Sat, 29 June 2013
8 1174 Mon, 01 July 2013 03:27
By: Michel Cadot
  Sql query is slow
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
By: prashanth7582 on Wed, 26 June 2013
9 1180 Thu, 27 June 2013 07:49
By: Andrey_R
  Different Timings between 2 Nodes
Oracle 11g Release2
By: feroze on Wed, 26 June 2013
2 749 Wed, 26 June 2013 16:56
By: feroze
  Top wait events
Oracle ,11.2.0.3.0 , Solaris 10 sparc 64 bit
By: zeeshan047 on Mon, 24 June 2013
2 1001 Mon, 24 June 2013 05:30
By: Flyby
  Tuning a SQL query
Oracle Database 10g Release 2
By: guptasum on Mon, 02 May 2011
17 6967 Fri, 21 June 2013 10:15
By: Kevin Meade
  DB designing from performance point of view.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
By: Manoj.Gupta.91 on Mon, 17 June 2013
8 988 Mon, 17 June 2013 02:32
By: John Watson
  Tuning a query with an EXISTS clause
Oracle 10.2.0.4 on Solaris 10
By: orausern on Tue, 11 June 2013
4 1645 Fri, 14 June 2013 17:42
By: Kevin Meade
  Performance tuning made easy
Oracle 10g, Windows 7 64 bit
By: stalin4d on Tue, 11 June 2013
9 1371 Fri, 14 June 2013 17:33
By: Kevin Meade
  How to Refresh a Materialized view Data.
Oracle 10g, Windows 7 64 bit
By: stalin4d on Wed, 12 June 2013
2 739 Wed, 12 June 2013 06:48
By: stalin4d
  Memory Allocation in 11 G
oracle 11.2.0.3.0 - Windows server 2008 R2
By: muktha_22 on Mon, 10 June 2013
5 979 Mon, 10 June 2013 07:36
By: Michel Cadot
  SQL not using index from application.
Oracle 11gR1
By: kanas on Thu, 06 June 2013
9 1378 Mon, 10 June 2013 00:27
By: michael_bialik
  System statistics: demonstration
11.2.0.3
By: John Watson on Thu, 06 June 2013
6 1906 Thu, 06 June 2013 07:12
By: Michel Cadot
  How to avoid repeat where clause in oracle sql
Oracle 11g, Windows
By: murman on Tue, 04 June 2013
2 1000 Tue, 04 June 2013 15:20
By: John Watson
  Unable to update newly added column in existing table
Oracle 9.2.0.6, OS - AIX 6.1
By: s.m.ramachandran on Tue, 21 May 2013
15 2154 Mon, 03 June 2013 12:52
By: s.m.ramachandran
  LogMiner Doubt
11.2.0.3.0
By: rishwinger on Mon, 03 June 2013
6 1623 Mon, 03 June 2013 03:46
By: Michel Cadot
  High System I/O Wait Class on AWR
Oracle 10.2.0.4 EE 64-bit, Solaris 10
By: cklh2000 on Fri, 04 January 2013
10 7623 Thu, 30 May 2013 09:16
By: sysdba007
  Keep Pool
Oracle 11g
By: orauser001 on Wed, 22 May 2013
5 2644 Thu, 30 May 2013 05:30
By: anjugarg66
  Help required in analyzing Network waits from AWR
Oracle 10.2.0.3 on AIX
By: sysdba007 on Wed, 29 May 2013
3 3261 Thu, 30 May 2013 02:40
By: sysdba007
  Best disk config for SME scale datawarehouse
Oracle std 10Gx64, windows 2008 x64
By: clementstore on Wed, 15 May 2013
2 1108 Mon, 20 May 2013 04:27
By: clementstore
  Need help in performance tunning for querying table
oracle 10g
By: supiash on Sun, 19 May 2013
4 762 Sun, 19 May 2013 08:39
By: Michel Cadot
  enable row movement - ok, but why internally this thing is needed
11.2.0.3.0
By: piotrtal on Fri, 17 May 2013
4 4247 Fri, 17 May 2013 14:43
By: Flyby
  commit_write in 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
3 1061 Fri, 17 May 2013 00:51
By: Michel Cadot
  db cache advice 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
2 964 Thu, 16 May 2013 17:55
By: TRaj
  Oracle generates different execution plans for test and prod environments
Oracle Database 11g
By: httr on Wed, 08 May 2013
11 2122 Wed, 15 May 2013 14:07
By: pointers
  Is there any way to have the DB articulate why PDML is blocked
11.2.0.3
By: Roachcoach on Fri, 10 May 2013
10 1163 Wed, 15 May 2013 06:17
By: Roachcoach
  why this query is utilizing my undo so rapidly?
By: piotrtal on Sat, 11 May 2013
9 3263 Sat, 11 May 2013 14:39
By: piotrtal
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: Sun Jul 24 17:31:29 CDT 2016

Total time taken to generate the page: 0.13196 seconds