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

    Replies Views Last message
  Temp Tablespace running out of space (68 GB)
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Thu, 17 November 2011
5 4760 Wed, 23 November 2011 04:41
By: dee_bee_eh
icon3.gif At the end of the road of my sql tuning
oracle
By: tigerxu on Mon, 21 November 2011
1 650 Mon, 21 November 2011 20:47
By: BlackSwan
  Definition between 2 metrics "Physical Reads"
10gR2
By: nikko on Mon, 21 November 2011
3 868 Mon, 21 November 2011 06:22
By: John Watson
  Tuning in Hierarchical queries
Oracle 10.2.0.2.0
By: praveenkumarsr on Thu, 17 November 2011
4 1171 Fri, 18 November 2011 19:12
By: praveenkumarsr
  Need help for query tunning the below query
By: shefalik on Wed, 16 November 2011
5 845 Thu, 17 November 2011 03:38
By: cookiemonster
  Slow running query -Explain plan attached-pls help!
ORacle,11g,windows server2003
By: aviana on Wed, 16 November 2011
2 939 Wed, 16 November 2011 13:54
By: LKBrwn_DBA
  Simple inserts Slow (merged 6)
oracle 10g XP
By: zulfiqaralimemon on Tue, 18 October 2011
7 1527 Wed, 16 November 2011 07:05
By: Michel Cadot
  Shrinking index
Oracle 10.2.0.3,Windows server 2003 64 bit
By: eafaisal on Tue, 15 November 2011
7 711 Wed, 16 November 2011 01:30
By: Michel Cadot
  index monitoring
oracle 10g
By: prashant_ora on Thu, 26 August 2010
23 3003 Fri, 11 November 2011 16:31
By: LNossov
  Merge statement tuning for 100M records in table ( 1 2)
By: sachi09 on Mon, 31 October 2011
49 2363 Tue, 08 November 2011 04:35
By: LNossov
  Need help (2 Merged)
By: supriyadba1 on Mon, 07 November 2011
14 1007 Tue, 08 November 2011 00:53
By: supriyadba1
  SQL tuning
11.2.0.2
By: singh09 on Sun, 06 November 2011
3 940 Mon, 07 November 2011 01:17
By: LNossov
  Reducing Hard parses
Oracle 10g, 10.2.0.3.0, Linux
By: Rags123 on Wed, 02 November 2011
30 4585 Fri, 04 November 2011 05:00
By: LNossov
  Doubt about Tuning SQL
Oracle 11g R2
By: aucrun on Thu, 03 November 2011
8 1056 Thu, 03 November 2011 12:25
By: aucrun
  sql tunning help required
11.1.0.7
By: nut_shut on Mon, 12 September 2011
4 727 Wed, 02 November 2011 13:12
By: Flyby
  Compare current row values with previous one until mismatch
Oracle 10g
By: asakchris on Wed, 02 November 2011
7 781 Wed, 02 November 2011 05:25
By: Michel Cadot
  Parallelism in queries
By: manojbe09 on Thu, 20 October 2011
4 618 Sun, 30 October 2011 23:55
By: manojbe09
  Bulk update performance issue
Oracle 11g, Windows XP
By: ninan on Sat, 01 October 2011
26 4821 Sat, 29 October 2011 19:54
By: Kevin Meade
  buffer busy wait
Linux 2.6.18-92.1.13.el5
By: dba_7722 on Tue, 25 October 2011
20 2316 Fri, 28 October 2011 16:12
By: LNossov
  Reading explain plan
11GR2 RAC on Windows
By: Kwisatz78 on Mon, 24 October 2011
4 792 Fri, 28 October 2011 10:21
By: Vackar
  Query performance diff
Oracle 10.2.0.1.0 CentOS 5
By: Vackar on Tue, 25 October 2011
12 772 Fri, 28 October 2011 06:41
By: cookiemonster
  Tuning my first query
11GR2 RAC on Windows
By: Kwisatz78 on Wed, 26 October 2011
10 1094 Thu, 27 October 2011 04:15
By: cookiemonster
icon4.gif Are Stale STATS Any Good
v10.2.0.4 SunOS 5.10 x86_64
By: drovnik on Tue, 18 October 2011
2 1057 Thu, 27 October 2011 02:31
By: drovnik
  Proving OTT undo reads
In post
By: Roachcoach on Wed, 26 October 2011
3 968 Wed, 26 October 2011 08:50
By: Roachcoach
  Performance Issue after Bulk Insertion
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: Manoj.Gupta.91 on Tue, 04 October 2011
2 607 Wed, 26 October 2011 06:57
By: Kevin Meade
  DECODE in WHERE CLAUSE Performance
Oracle 11g, Windows XP
By: ninan on Mon, 17 October 2011
9 5801 Wed, 26 October 2011 06:01
By: Kevin Meade
  Performance Tuning
Aix
By: sher297 on Sun, 23 October 2011
5 699 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 815 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 1278 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 1556 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 8552 Tue, 25 October 2011 02:02
By: LNossov
  Optimize MERGE statement
Oracle 10g
By: tsteinmaurer on Wed, 05 October 2011
10 4201 Mon, 24 October 2011 15:54
By: LNossov
  PL/SQL help (performance)
Win Xp, Oracle 10g
By: rajivn786 on Wed, 19 October 2011
17 1053 Sat, 22 October 2011 16:04
By: LNossov
  I/p on tuning select query
Oracle 8i
By: shyamu on Sat, 22 October 2011
3 814 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 790 Fri, 21 October 2011 12:49
By: ThomasG
  Need support for Query performance tuning
Oracle 11g
By: onlijob on Thu, 20 October 2011
10 770 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 3438 Wed, 19 October 2011 17:41
By: LNossov
  Large temporary files
Oracle 9i, Centos
By: ranjit@buddhaair.com on Mon, 17 October 2011
2 817 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 1138 Sun, 16 October 2011 00:59
By: Michel Cadot
  QUERY Help
By: venkatlvr on Sat, 15 October 2011
3 714 Sat, 15 October 2011 05:35
By: John Watson
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: Tue Apr 28 01:57:40 CDT 2015

Total time taken to generate the page: 0.10960 seconds