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

    Replies Views Last message
  "NOT IN" REPLACE WITH "MINUS"
Oracle 10gR2
By: thinknightgmailcom on Thu, 15 September 2011
1 863 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 1028 Tue, 13 September 2011 08:29
By: cookiemonster
  pl/sql
oracle 10g
By: zodiacsom on Wed, 07 September 2011
24 985 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 1453 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 892 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 732 Fri, 09 September 2011 07:37
By: Michel Cadot
  Performance issue
Oracle 10g, wondows XP
By: a_oracle on Tue, 06 September 2011
3 724 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 2408 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 644 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 913 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 659 Mon, 05 September 2011 02:45
By: Michel Cadot
  performance tuning
oracle 10g
By: zodiacsom on Fri, 02 September 2011
2 603 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 943 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 1266 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 1674 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 498 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 971 Tue, 30 August 2011 01:27
By: jai_subi
  harsh area size and sort area size
By: matthew00 on Mon, 29 August 2011
3 660 Mon, 29 August 2011 11:38
By: John Watson
  Interface table design question
Oracle, 10g
By: ironman12 on Sat, 27 August 2011
5 736 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 2137 Mon, 29 August 2011 06:17
By: kesavansundaram
  RANGE SCAN VS FAST FULL SCAN
By: patneel on Mon, 29 August 2011
3 2951 Mon, 29 August 2011 05:36
By: Michel Cadot
  SQL TUNING
Oracle 10G
By: Bhaskarquadrant on Fri, 26 August 2011
7 641 Sun, 28 August 2011 22:23
By: hkchital
  Managing Large Table
Oracle 10g
By: EbenT on Fri, 26 August 2011
7 1029 Sun, 28 August 2011 20:56
By: Kevin Meade
  SGA_TARGET and shared pool
By: matthew00 on Thu, 25 August 2011
2 907 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 675 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 1016 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 3979 Wed, 24 August 2011 19:57
By: Kevin Meade
  application performance
By: matthew00 on Wed, 24 August 2011
1 410 Wed, 24 August 2011 17:51
By: cookiemonster
  Speed up this SQL
Oracle 10g
By: r23rob on Fri, 19 August 2011
2 811 Mon, 22 August 2011 08:16
By: rleishman
  performance tuning PROBLEM
By: shashank_kurasrediffmail on Thu, 18 August 2011
8 1244 Thu, 18 August 2011 11:17
By: BlackSwan
  Need help with tuning
By: naveenreddy on Wed, 17 August 2011
1 527 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 506 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 1666 Wed, 17 August 2011 02:34
By: a_oracle
  Oracle Instance Related Query
Oracle 10g
By: saswatic on Tue, 16 August 2011
2 1109 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 5630 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 1327 Thu, 11 August 2011 13:36
By: SSharma
  Performance tuning for select statement
By: benjamin.tl on Fri, 15 January 2010
19 2431 Thu, 11 August 2011 03:33
By: cookiemonster
  New Trace File
Oracle 11g R1
By: rchenna on Thu, 11 August 2011
3 1019 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 14394 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 5403 Wed, 10 August 2011 22:32
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: Mon Oct 20 19:41:07 CDT 2014

Total time taken to generate the page: 0.11381 seconds