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

    Replies Views Last message
  Advice on Gather_stats
Oracle 8i, 9i and 10G
By: sathik on Tue, 06 September 2011
23 5802 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 2924 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 1826 Fri, 09 September 2011 07:37
By: Michel Cadot
  Performance issue
Oracle 10g, wondows XP
By: a_oracle on Tue, 06 September 2011
3 1922 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 6874 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 1715 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 2434 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 2256 Mon, 05 September 2011 02:45
By: Michel Cadot
  performance tuning
oracle 10g
By: zodiacsom on Fri, 02 September 2011
2 1694 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 3400 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 2785 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 3150 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 1649 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 2157 Tue, 30 August 2011 01:27
By: jai_subi
  harsh area size and sort area size
By: matthew00 on Mon, 29 August 2011
3 2228 Mon, 29 August 2011 11:38
By: John Watson
  Interface table design question
Oracle, 10g
By: ironman12 on Sat, 27 August 2011
5 3131 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 3637 Mon, 29 August 2011 06:17
By: kesavansundaram
  RANGE SCAN VS FAST FULL SCAN
By: patneel on Mon, 29 August 2011
3 5240 Mon, 29 August 2011 05:36
By: Michel Cadot
  SQL TUNING
Oracle 10G
By: Bhaskarquadrant on Fri, 26 August 2011
7 2376 Sun, 28 August 2011 22:23
By: hkchital
  Managing Large Table
Oracle 10g
By: EbenT on Fri, 26 August 2011
7 3523 Sun, 28 August 2011 20:56
By: Kevin Meade
  SGA_TARGET and shared pool
By: matthew00 on Thu, 25 August 2011
2 2012 Thu, 25 August 2011 15:24
By: John Watson
  performance doubt
11.2.0.2.0
By: shashank_kurasrediffmail on Thu, 11 August 2011
9 2573 Thu, 25 August 2011 07:45
By: Kevin Meade
  Insert / Update Performance due to Triggers (merged 2)
Oracle 9i
By: mjm22 on Wed, 10 August 2011
5 2919 Wed, 24 August 2011 20:41
By: Kevin Meade
  how expensive is unique versus primary key in large table
9.2.0.1.0
By: OraFerro on Mon, 15 August 2011
5 6245 Wed, 24 August 2011 19:57
By: Kevin Meade
  application performance
By: matthew00 on Wed, 24 August 2011
1 1455 Wed, 24 August 2011 17:51
By: cookiemonster
  Speed up this SQL
Oracle 10g
By: r23rob on Fri, 19 August 2011
2 2338 Mon, 22 August 2011 08:16
By: rleishman
  performance tuning PROBLEM
By: shashank_kurasrediffmail on Thu, 18 August 2011
8 4023 Thu, 18 August 2011 11:17
By: BlackSwan
  Need help with tuning
By: naveenreddy on Wed, 17 August 2011
1 1620 Wed, 17 August 2011 14:20
By: Michel Cadot
  2 design alternatives, passing natural key as meaningful foreign key
9.2.0.1.0
By: OraFerro on Wed, 17 August 2011
5 2284 Wed, 17 August 2011 03:01
By: Michel Cadot
  Query sub-factoring issue
Oracle 10g,Windows XP
By: a_oracle on Wed, 17 August 2011
4 3248 Wed, 17 August 2011 02:34
By: a_oracle
  Oracle Instance Related Query
Oracle 10g
By: saswatic on Tue, 16 August 2011
2 2210 Wed, 17 August 2011 00:47
By: John Watson
  start with and connect by
Oracle 11g R2 , RHEL4
By: liliek on Mon, 25 July 2011
28 13060 Mon, 15 August 2011 01:39
By: liliek
  Need to decrease the cost as much as possible
Version: Oracle 10.2.0.3.0 OS: Solaris
By: SSharma on Fri, 29 July 2011
11 3709 Thu, 11 August 2011 13:36
By: SSharma
  Performance tuning for select statement
By: benjamin.tl on Fri, 15 January 2010
19 5801 Thu, 11 August 2011 03:33
By: cookiemonster
  New Trace File
Oracle 11g R1
By: rchenna on Thu, 11 August 2011
3 2429 Thu, 11 August 2011 01:33
By: Michel Cadot
  nvl problem i think
11.2.0.2.0
By: shashank_kurasrediffmail on Wed, 10 August 2011
30 18869 Wed, 10 August 2011 22:45
By: shashank_kurasrediffmail
  SGA_MAX_SIZE to more than 2G?
10.2.0.1.0, OS=Windows 2003 server 64 bit with 16G RAM
By: pt12340 on Wed, 10 August 2011
6 10207 Wed, 10 August 2011 22:32
By: BlackSwan
  Simple SQL with High Concurrency Wait Time (cursor: pin S wait on X)
Oracle 10gR2 on AIX 6.1
By: eclipsis on Fri, 05 August 2011
18 15188 Tue, 09 August 2011 06:46
By: LNossov
  Application slow
Oracle 11.1.0.7.0, Unix-HP
By: Smith14 on Sun, 07 August 2011
4 2760 Sun, 07 August 2011 12:20
By: Michel Cadot
  PERFORMANCE TUNING
By: shashank_kurasrediffmail on Sat, 06 August 2011
1 2581 Sat, 06 August 2011 10:02
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: Fri Mar 29 04:40:53 CDT 2024