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

    Replies Views Last message
  Index on Range-List Subpartitions Table using template
Oracle 11.2.0.2.0
By: ric90 on Mon, 24 October 2011
4 1388 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 8004 Tue, 25 October 2011 02:02
By: LNossov
  Optimize MERGE statement
Oracle 10g
By: tsteinmaurer on Wed, 05 October 2011
10 3715 Mon, 24 October 2011 15:54
By: LNossov
  PL/SQL help (performance)
Win Xp, Oracle 10g
By: rajivn786 on Wed, 19 October 2011
17 906 Sat, 22 October 2011 16:04
By: LNossov
  I/p on tuning select query
Oracle 8i
By: shyamu on Sat, 22 October 2011
3 738 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 683 Fri, 21 October 2011 12:49
By: ThomasG
  Need support for Query performance tuning
Oracle 11g
By: onlijob on Thu, 20 October 2011
10 689 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 3336 Wed, 19 October 2011 17:41
By: LNossov
  Large temporary files
Oracle 9i, Centos
By: ranjit@buddhaair.com on Mon, 17 October 2011
2 781 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 1013 Sun, 16 October 2011 00:59
By: Michel Cadot
  QUERY Help
By: venkatlvr on Sat, 15 October 2011
3 619 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 1825 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 2649 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 1206 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 4653 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 694 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 1186 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 749 Tue, 04 October 2011 12:18
By: LNossov
  how to find index to rebuilt
oracle 9i
By: sathish16787 on Mon, 03 October 2011
2 1070 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 827 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 750 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 865 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 1140 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 1867 Thu, 29 September 2011 07:00
By: ric90
  Query tuning
oracle 9i
By: sathik on Tue, 27 September 2011
6 840 Wed, 28 September 2011 03:25
By: Flyby
  SQL with more parse
11g
By: gkrishn on Tue, 27 September 2011
6 476 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 750 Thu, 22 September 2011 13:12
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 21 September 2011
9 6024 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 2717 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 1256 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 634 Fri, 16 September 2011 14:26
By: varunvir
  session_cached_cursors
11gr2
By: fairdaus on Mon, 27 June 2011
11 6240 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 816 Thu, 15 September 2011 20:27
By: BlackSwan
  "NOT IN" REPLACE WITH "MINUS"
Oracle 10gR2
By: thinknightgmailcom on Thu, 15 September 2011
1 861 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 1016 Tue, 13 September 2011 08:29
By: cookiemonster
  pl/sql
oracle 10g
By: zodiacsom on Wed, 07 September 2011
24 976 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 1442 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 886 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 725 Fri, 09 September 2011 07:37
By: Michel Cadot
  Performance issue
Oracle 10g, wondows XP
By: a_oracle on Tue, 06 September 2011
3 713 Fri, 09 September 2011 03:56
By: cookiemonster
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 Oct 02 11:02:13 CDT 2014

Total time taken to generate the page: 0.11623 seconds