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

    Replies Views Last message
  memory_max_target and 11g memory utilization - question
11.2.0.1.0
By: piotrtal on Wed, 30 November 2011
5 2448 Wed, 30 November 2011 13:27
By: BlackSwan
  WINDOW SORT
Oracle 11g
By: sachi09 on Wed, 30 November 2011
5 3778 Wed, 30 November 2011 04:37
By: Michel Cadot
  Data type conversion impact on performance
By: patni123 on Mon, 28 November 2011
8 2042 Tue, 29 November 2011 03:59
By: cookiemonster
  Query performance decreased between order by ASC/DESC
By: euphORIA on Fri, 25 November 2011
11 1542 Mon, 28 November 2011 11:59
By: Flyby
  SGA AND PGA PARAMETER SETTINGS
WINDOWS 2000 SERVER ORACLE 9I
By: mrdb on Sun, 27 November 2011
5 3318 Sun, 27 November 2011 02:49
By: John Watson
  Table space with different block size inside same database
Oracle 10g, 10.2.0.1.0 Linux
By: Rags123 on Fri, 25 November 2011
14 1338 Fri, 25 November 2011 16:55
By: BlackSwan
  Reports Tuning
Oracle Report builder 6i or later ..
By: ramoradba on Wed, 23 November 2011
1 1016 Thu, 24 November 2011 02:02
By: ramoradba
  MVIEW huge temp space
10.2.0.3 linux
By: dee_bee_eh on Wed, 23 November 2011
6 2274 Wed, 23 November 2011 09:43
By: dee_bee_eh
  Elapsed Time in Trace file output (2 Merged)
Oracle 11g R2 on Windows 7
By: orapratap on Wed, 16 November 2011
1 18663 Wed, 23 November 2011 05:29
By: dee_bee_eh
  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 5630 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 749 Mon, 21 November 2011 20:47
By: BlackSwan
  Definition between 2 metrics "Physical Reads"
10gR2
By: nikko on Mon, 21 November 2011
3 986 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 1297 Fri, 18 November 2011 19:12
By: praveenkumarsr
  Need help for query tunning the below query
By: shefalik on Wed, 16 November 2011
5 1036 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 1091 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 1674 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 827 Wed, 16 November 2011 01:30
By: Michel Cadot
  index monitoring
oracle 10g
By: prashant_ora on Thu, 26 August 2010
23 3401 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 2975 Tue, 08 November 2011 04:35
By: LNossov
  Need help (2 Merged)
By: supriyadba1 on Mon, 07 November 2011
14 1139 Tue, 08 November 2011 00:53
By: supriyadba1
  SQL tuning
11.2.0.2
By: singh09 on Sun, 06 November 2011
3 1177 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 5977 Fri, 04 November 2011 05:00
By: LNossov
  Doubt about Tuning SQL
Oracle 11g R2
By: aucrun on Thu, 03 November 2011
8 1247 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 878 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 1019 Wed, 02 November 2011 05:25
By: Michel Cadot
  Parallelism in queries
By: manojbe09 on Thu, 20 October 2011
4 745 Sun, 30 October 2011 23:55
By: manojbe09
  Bulk update performance issue
Oracle 11g, Windows XP
By: ninan on Sat, 01 October 2011
26 5683 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 2988 Fri, 28 October 2011 16:12
By: LNossov
  Reading explain plan
11GR2 RAC on Windows
By: Kwisatz78 on Mon, 24 October 2011
4 979 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 1031 Fri, 28 October 2011 06:41
By: cookiemonster
  Tuning my first query
11GR2 RAC on Windows
By: Kwisatz78 on Wed, 26 October 2011
10 1299 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 1277 Thu, 27 October 2011 02:31
By: drovnik
  Proving OTT undo reads
In post
By: Roachcoach on Wed, 26 October 2011
3 1216 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 716 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 8325 Wed, 26 October 2011 06:01
By: Kevin Meade
  Performance Tuning
Aix
By: sher297 on Sun, 23 October 2011
5 826 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 929 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 1620 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 2002 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 9885 Tue, 25 October 2011 02:02
By: LNossov
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: Sat Oct 01 08:52:11 CDT 2016

Total time taken to generate the page: 0.08536 seconds