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

    Replies Views Last message
  SQL with more parse
11g
By: gkrishn on Tue, 27 September 2011
6 494 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 764 Thu, 22 September 2011 13:12
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 21 September 2011
9 6072 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 2760 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 1303 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 656 Fri, 16 September 2011 14:26
By: varunvir
  session_cached_cursors
11gr2
By: fairdaus on Mon, 27 June 2011
11 6458 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 837 Thu, 15 September 2011 20:27
By: BlackSwan
  "NOT IN" REPLACE WITH "MINUS"
Oracle 10gR2
By: thinknightgmailcom on Thu, 15 September 2011
1 870 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 1063 Tue, 13 September 2011 08:29
By: cookiemonster
  pl/sql
oracle 10g
By: zodiacsom on Wed, 07 September 2011
24 1003 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 1477 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 914 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 743 Fri, 09 September 2011 07:37
By: Michel Cadot
  Performance issue
Oracle 10g, wondows XP
By: a_oracle on Tue, 06 September 2011
3 742 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 2464 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 652 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 916 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 672 Mon, 05 September 2011 02:45
By: Michel Cadot
  performance tuning
oracle 10g
By: zodiacsom on Fri, 02 September 2011
2 610 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 972 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 1287 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 1699 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 506 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 987 Tue, 30 August 2011 01:27
By: jai_subi
  harsh area size and sort area size
By: matthew00 on Mon, 29 August 2011
3 671 Mon, 29 August 2011 11:38
By: John Watson
  Interface table design question
Oracle, 10g
By: ironman12 on Sat, 27 August 2011
5 758 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 2147 Mon, 29 August 2011 06:17
By: kesavansundaram
  RANGE SCAN VS FAST FULL SCAN
By: patneel on Mon, 29 August 2011
3 2996 Mon, 29 August 2011 05:36
By: Michel Cadot
  SQL TUNING
Oracle 10G
By: Bhaskarquadrant on Fri, 26 August 2011
7 659 Sun, 28 August 2011 22:23
By: hkchital
  Managing Large Table
Oracle 10g
By: EbenT on Fri, 26 August 2011
7 1050 Sun, 28 August 2011 20:56
By: Kevin Meade
  SGA_TARGET and shared pool
By: matthew00 on Thu, 25 August 2011
2 915 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 684 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 1035 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 4008 Wed, 24 August 2011 19:57
By: Kevin Meade
  application performance
By: matthew00 on Wed, 24 August 2011
1 420 Wed, 24 August 2011 17:51
By: cookiemonster
  Speed up this SQL
Oracle 10g
By: r23rob on Fri, 19 August 2011
2 831 Mon, 22 August 2011 08:16
By: rleishman
  performance tuning PROBLEM
By: shashank_kurasrediffmail on Thu, 18 August 2011
8 1288 Thu, 18 August 2011 11:17
By: BlackSwan
  Need help with tuning
By: naveenreddy on Wed, 17 August 2011
1 537 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 520 Wed, 17 August 2011 03:01
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 Nov 28 01:20:31 CST 2014

Total time taken to generate the page: 0.11537 seconds