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

    Replies Views Last message
  Very Bad Performance After ReOrg
v92080 Enterprise - SPARC 8 64bit
By: drovnik on Tue, 04 October 2011
3 1676 Tue, 04 October 2011 12:18
By: LNossov
  how to find index to rebuilt
oracle 9i
By: sathish16787 on Mon, 03 October 2011
2 2078 Tue, 04 October 2011 11:40
By: LNossov
  don't know why this baseline doesn't work :/
11.2.0.1.0
By: piotrtal on Fri, 16 September 2011
3 2080 Tue, 04 October 2011 10:08
By: LNossov
  How to view the tables which are in the keep buffer cache????
By: Narmada28 on Sat, 01 October 2011
9 2420 Mon, 03 October 2011 02:54
By: Narmada28
  Views which will help in tuning SGA and PGA
By: Narmada28 on Sat, 01 October 2011
5 1842 Sat, 01 October 2011 12:05
By: Michel Cadot
  optimizer ignoring USE_HASH hint in MERGE Query
10.2.0.3
By: deepa_balu on Fri, 30 September 2011
2 1992 Fri, 30 September 2011 06:42
By: Michel Cadot
  Virtual Columns : function based very slow
Oracle 11.2.0.2.0
By: ric90 on Thu, 29 September 2011
0 3059 Thu, 29 September 2011 07:00
By: ric90
  Query tuning
oracle 9i
By: sathik on Tue, 27 September 2011
6 2252 Wed, 28 September 2011 03:25
By: Flyby
  SQL with more parse
11g
By: gkrishn on Tue, 27 September 2011
6 1568 Tue, 27 September 2011 05:39
By: Roachcoach
  MERGE Statment repetitive subquery refactoring (3 Merged)
Oracle 11g, Windows xP
By: ninan on Thu, 22 September 2011
1 1482 Thu, 22 September 2011 13:12
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 21 September 2011
9 7603 Thu, 22 September 2011 07:24
By: a_oracle
  Need help to understand in depth about ORA-01555
Oracle , 9.2.0.8, solaris
By: sathik on Thu, 22 September 2011
6 3940 Thu, 22 September 2011 06:56
By: Michel Cadot
  POWER function slows query way down?
9.2.0.8.0
By: Kevin Meade on Fri, 16 September 2011
14 4631 Sun, 18 September 2011 11:51
By: Kevin Meade
  query taking long time
10.2.0.4
By: varunvir on Fri, 16 September 2011
5 1623 Fri, 16 September 2011 14:26
By: varunvir
  session_cached_cursors
11gr2
By: fairdaus on Mon, 27 June 2011
11 18793 Fri, 16 September 2011 08:25
By: Michel Cadot
  select partition issue
11.2.0.1.0 Windos XP
By: andy huang on Thu, 15 September 2011
3 1813 Thu, 15 September 2011 20:27
By: BlackSwan
  "NOT IN" REPLACE WITH "MINUS"
Oracle 10gR2
By: thinknightgmailcom on Thu, 15 September 2011
1 1388 Thu, 15 September 2011 07:04
By: Michel Cadot
  Perfomance problem with select distinct from cartesian join with OR-ed filter
Production: (11.2.0.1, Windows Server x64); Test: (9.2.01, Windows XP)
By: malishich on Mon, 12 September 2011
13 3382 Tue, 13 September 2011 08:29
By: cookiemonster
  pl/sql
oracle 10g
By: zodiacsom on Wed, 07 September 2011
24 2823 Mon, 12 September 2011 23:13
By: Michel Cadot
  Advice on Gather_stats
Oracle 8i, 9i and 10G
By: sathik on Tue, 06 September 2011
23 4846 Sun, 11 September 2011 03:38
By: Michel Cadot
  Don't Know how to start performance tuning.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: Manoj.Gupta.91 on Fri, 09 September 2011
4 2351 Sat, 10 September 2011 10:55
By: halim
  How to find out all the queries that are executed in particular range of time in oracle instance.
Oracle 10g [10.2.0.3.0] windows 7
By: gopieee16 on Fri, 09 September 2011
3 1306 Fri, 09 September 2011 07:37
By: Michel Cadot
  Performance issue
Oracle 10g, wondows XP
By: a_oracle on Tue, 06 September 2011
3 1396 Fri, 09 September 2011 03:56
By: cookiemonster
  how we can match variable sga using v$sga and v$sgastat views
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: msol25 on Fri, 02 September 2011
10 5651 Thu, 08 September 2011 08:05
By: Michel Cadot
  Stopping optimizer choosing concatenation
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
By: Roachcoach on Wed, 07 September 2011
2 1176 Wed, 07 September 2011 07:42
By: Roachcoach
icon5.gif Statspack unit information
Oracle database, Standard 10.0.2.4, Windows 2003
By: Flyby on Tue, 06 September 2011
2 1900 Tue, 06 September 2011 14:19
By: Flyby
  dml is very slowly when table have many rows
11.2.0.1.0 Windos XP
By: andy huang on Sun, 04 September 2011
6 1619 Mon, 05 September 2011 02:45
By: Michel Cadot
  performance tuning
oracle 10g
By: zodiacsom on Fri, 02 September 2011
2 1171 Fri, 02 September 2011 13:15
By: flyboy
  Query Performance Issue (4 Merged)
Oracle 10 G
By: mani_rbs on Wed, 31 August 2011
9 2682 Fri, 02 September 2011 09:33
By: BlackSwan
  Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
how we can match variable sga in v$sga with v$sgastat view
By: msol25 on Fri, 02 September 2011
5 2244 Fri, 02 September 2011 05:25
By: Michel Cadot
  Memory Fault Error in Tkprof
Oracle 10g, Unix
By: artisteprasanna on Wed, 31 August 2011
1 2620 Wed, 31 August 2011 23:56
By: BlackSwan
  Importing Partitioning rows from Many Export Files.
oracle version 10g Windows XP
By: muktha_22 on Tue, 30 August 2011
2 1157 Tue, 30 August 2011 02:40
By: muktha_22
  different between move and shink table
11g windows
By: andy huang on Fri, 22 July 2011
2 1635 Tue, 30 August 2011 01:27
By: jai_subi
  harsh area size and sort area size
By: matthew00 on Mon, 29 August 2011
3 1626 Mon, 29 August 2011 11:38
By: John Watson
  Interface table design question
Oracle, 10g
By: ironman12 on Sat, 27 August 2011
5 2233 Mon, 29 August 2011 11:21
By: Kevin Meade
  Need to improve speed for UPDATE statement
oracle 11.2.0.1.0 linux 2.6
By: kesavansundaram on Mon, 29 August 2011
0 3077 Mon, 29 August 2011 06:17
By: kesavansundaram
  RANGE SCAN VS FAST FULL SCAN
By: patneel on Mon, 29 August 2011
3 4684 Mon, 29 August 2011 05:36
By: Michel Cadot
  SQL TUNING
Oracle 10G
By: Bhaskarquadrant on Fri, 26 August 2011
7 1755 Sun, 28 August 2011 22:23
By: hkchital
  Managing Large Table
Oracle 10g
By: EbenT on Fri, 26 August 2011
7 2858 Sun, 28 August 2011 20:56
By: Kevin Meade
  SGA_TARGET and shared pool
By: matthew00 on Thu, 25 August 2011
2 1507 Thu, 25 August 2011 15:24
By: John Watson
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 Jul 30 09:03:10 CDT 2021