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

    Replies Views Last message
  DECODE in WHERE CLAUSE Performance
Oracle 11g, Windows XP
By: ninan on Mon, 17 October 2011
9 17175 Wed, 26 October 2011 06:01
By: Kevin Meade
  Performance Tuning
Aix
By: sher297 on Sun, 23 October 2011
5 2409 Wed, 26 October 2011 04:53
By: Kevin Meade
  executions
10.2.0.4, Windows 2003
By: sant_new on Tue, 25 October 2011
3 2246 Tue, 25 October 2011 13:16
By: BlackSwan
  Tracing long running program
10.2.0.4, Windows 2003
By: sant_new on Tue, 25 October 2011
14 3954 Tue, 25 October 2011 12:49
By: Michel Cadot
  Index on Range-List Subpartitions Table using template
Oracle 11.2.0.2.0
By: ric90 on Mon, 24 October 2011
4 4210 Tue, 25 October 2011 08:12
By: LNossov
  Snap IDs not found for awr reports generation
Oracle 11gR2, RHEL 5
By: User01 on Mon, 24 October 2011
15 15466 Tue, 25 October 2011 02:02
By: LNossov
  Optimize MERGE statement
Oracle 10g
By: tsteinmaurer on Wed, 05 October 2011
10 9840 Mon, 24 October 2011 15:54
By: LNossov
  PL/SQL help (performance)
Win Xp, Oracle 10g
By: rajivn786 on Wed, 19 October 2011
17 3498 Sat, 22 October 2011 16:04
By: LNossov
  I/p on tuning select query
Oracle 8i
By: shyamu on Sat, 22 October 2011
3 2481 Sat, 22 October 2011 15:52
By: BlackSwan
  Tune the query..
Oracle 11.1.0.6.0
By: muralikri on Fri, 21 October 2011
12 3384 Fri, 21 October 2011 12:49
By: ThomasG
  Need support for Query performance tuning
Oracle 11g
By: onlijob on Thu, 20 October 2011
10 3093 Fri, 21 October 2011 02:59
By: Roachcoach
  To verify if a row exists (index range scan)
Oracle 10.2.0.3
By: Its_me_ved on Tue, 18 October 2011
4 5402 Wed, 19 October 2011 17:41
By: LNossov
  Large temporary files
Oracle 9i, Centos
By: ranjit@buddhaair.com on Mon, 17 October 2011
2 2230 Mon, 17 October 2011 06:53
By: ranjit@buddhaair.com
  Suggestions of manipulating 3 crores of data
Oracle 8i
By: shyamu on Sat, 15 October 2011
8 3156 Sun, 16 October 2011 00:59
By: Michel Cadot
  QUERY Help
By: venkatlvr on Sat, 15 October 2011
3 2484 Sat, 15 October 2011 05:35
By: John Watson
  The query was running before 11g upgrade
11.2.0.2.2
By: getzeeshan on Fri, 07 October 2011
39 6641 Fri, 14 October 2011 09:07
By: getzeeshan
  sga,pga parameter resizing
hp-ux ,oracle 10g(rel 2)
By: dbaoracleinin on Thu, 15 September 2011
5 6077 Wed, 12 October 2011 09:34
By: dbaoracleinin
icon4.gif Slower DB response [Oracle 10g on Solaris 5.10]
Oracle 10g on Solaris 5.10
By: suddhasatwa_bhaumik on Tue, 11 October 2011
4 2591 Tue, 11 October 2011 09:49
By: suddhasatwa_bhaumik
  Performance Issue (merged 2)
Oracle DB,11.2.0.1.0,Linux 2.6.18-194.el5PAE
By: crussed_sonu on Mon, 10 October 2011
16 12467 Tue, 11 October 2011 04:02
By: crussed_sonu
  performance problem (Hit Ratio)
Oracle 10g,windows server 2003
By: oradba123 on Mon, 10 October 2011
2 1952 Mon, 10 October 2011 03:53
By: Michel Cadot
  Tuning help needed
Oracle 11.1.0.7.0
By: naveenreddy on Fri, 09 September 2011
18 4328 Wed, 05 October 2011 02:55
By: LNossov
  Very Bad Performance After ReOrg
v92080 Enterprise - SPARC 8 64bit
By: drovnik on Tue, 04 October 2011
3 2252 Tue, 04 October 2011 12:18
By: LNossov
  how to find index to rebuilt
oracle 9i
By: sathish16787 on Mon, 03 October 2011
2 2678 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 2768 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 3001 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 2512 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 2511 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 3602 Thu, 29 September 2011 07:00
By: ric90
  Query tuning
oracle 9i
By: sathik on Tue, 27 September 2011
6 2842 Wed, 28 September 2011 03:25
By: Flyby
  SQL with more parse
11g
By: gkrishn on Tue, 27 September 2011
6 2223 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 2042 Thu, 22 September 2011 13:12
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 21 September 2011
9 8255 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 4547 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 6481 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 2191 Fri, 16 September 2011 14:26
By: varunvir
  session_cached_cursors
11gr2
By: fairdaus on Mon, 27 June 2011
11 20224 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 2364 Thu, 15 September 2011 20:27
By: BlackSwan
  "NOT IN" REPLACE WITH "MINUS"
Oracle 10gR2
By: thinknightgmailcom on Thu, 15 September 2011
1 1861 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 4084 Tue, 13 September 2011 08:29
By: cookiemonster
  pl/sql
oracle 10g
By: zodiacsom on Wed, 07 September 2011
24 3927 Mon, 12 September 2011 23:13
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: Thu Mar 28 04:50:39 CDT 2024