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

    Replies Views Last message
  COUNT STOPKEY issue -- performance issue
oracle 11gr2/unix
By: balaji123 on Mon, 07 April 2014
2 2021 Tue, 08 April 2014 19:51
By: rleishman
  5M record insert takes two hours
11gR2
By: That Don Guy on Wed, 02 April 2014
4 1510 Mon, 07 April 2014 10:54
By: d_seng
  SQL performance
Oracle 11i
By: huda_10@yahoo.co.in on Sun, 30 March 2014
13 2826 Thu, 03 April 2014 05:32
By: michael_bialik
  elapsed_time_delta in dba_hist_sqlstat
By: VIP2013 on Wed, 26 March 2014
1 2073 Thu, 27 March 2014 10:07
By: VIP2013
  Would making indexes "invisible" be the right approach for this?
11.2.0.3 / CentOS Linux
By: ThomasG on Wed, 26 March 2014
4 1135 Thu, 17 April 2014 04:30
By: Lalit Kumar B
  Best Design for batch processing using BLOB Types
By: luxofmcc on Tue, 25 March 2014
1 892 Tue, 25 March 2014 14:43
By: BlackSwan
  sql result cache for improving the performance (merged 4)
11g
By: kiranrathodkr916 on Sat, 22 March 2014
21 2957 Tue, 25 March 2014 05:15
By: ashwanth77
  Please help me for getting best execution plan as my create view script is taking more time
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 25 March 2014
5 1107 Tue, 22 April 2014 09:52
By: BlackSwan
  statement with big cost
Oracle Database 11.2.0.2.0
By: Roger22 on Fri, 21 March 2014
9 1395 Fri, 21 March 2014 09:18
By: cookiemonster
  Debug Procedure
Oracle 11g,Win7 32 bit
By: Xandot on Thu, 26 June 2014
7 943 Thu, 26 June 2014 09:10
By: Xandot
  Use of Hints in Oracle 11g to get desired Execution Plan
Oracle 11g 2.0, Linux
By: rekha.singhal@tcs.com on Thu, 20 March 2014
9 1771 Mon, 24 March 2014 00:29
By: Kevin Meade
  session uga memory
By: ashu205 on Tue, 18 March 2014
1 2016 Wed, 19 March 2014 18:42
By: BlackSwan
  What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def
general
By: Kevin Meade on Tue, 18 March 2014
4 1275 Tue, 18 March 2014 06:09
By: Kevin Meade
  SQL Execution Runtime Measure
Oracle 11g Rel 2
By: ind9 on Fri, 14 March 2014
3 1579 Sat, 15 March 2014 05:45
By: John Watson
  Sql Tuning Advisor - Privileges (sqltrpt.sql)
Oracle DB 11g Enterprise - 11.2.0.3 - Linux x86 64-bit
By: hitesh.bhatt on Thu, 13 March 2014
2 4448 Thu, 13 March 2014 22:49
By: hitesh.bhatt
  database performance tuning
By: likhonisrat on Tue, 11 March 2014
1 728 Tue, 11 March 2014 06:42
By: John Watson
  SQL Repair
Oracle 11g , Unix
By: younusc on Mon, 10 March 2014
3 1031 Thu, 13 March 2014 00:02
By: Markwillium
  Query is taking long time
11i
By: Vivek_Garg on Sun, 09 March 2014
16 2099 Mon, 10 March 2014 04:49
By: John Watson
  Incorrect cardinalty estimate when using a local non-prefixed unique index
DB 12.1.0.1
By: John Watson on Fri, 07 March 2014
7 1553 Thu, 13 March 2014 20:04
By: rleishman
icon5.gif Difference in elapsed time of the query where everything in the trace seems to be identical
Oracle 11g, Windows 7
By: Vivek_Garg on Thu, 06 March 2014
1 662 Thu, 06 March 2014 07:09
By: John Watson
  How to find throughput by query, session and database wise?
Oracle 11.2.0.3, Redhat Linux 5.
By: suresh.wst on Sun, 02 March 2014
9 2056 Fri, 07 March 2014 01:41
By: suresh.wst
  Oracle contain clause performance issue
Oracle / 11g r2/unix
By: balaji123 on Fri, 28 February 2014
2 732 Fri, 28 February 2014 02:13
By: balaji123
  Materialized View not being used on production (works elsewhere)
Oracle 11.2.0.2 Enterprise 64 bit
By: d_seng on Wed, 26 February 2014
9 2376 Mon, 07 April 2014 10:32
By: d_seng
  Oracle Architecture
By: gasbie on Sun, 23 February 2014
2 1212 Mon, 24 February 2014 00:49
By: John Watson
  Bloom filter joins
By: Kevin Meade on Thu, 20 February 2014
4 3289 Fri, 21 February 2014 20:16
By: Kevin Meade
  AWR top events:: enq: TX - row lock contention
Oracle 11.2.0.3 on HP-UX (64-bit)
By: hitesh.bhatt on Thu, 20 February 2014
2 4824 Fri, 21 February 2014 20:44
By: Kevin Meade
  AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O"
Oracle 11.2.0.3.0 on HP-UX (64-Bit)
By: hitesh.bhatt on Tue, 18 February 2014
3 2007 Sun, 02 March 2014 22:03
By: trantuananh24hg
  result cache physical reads 0 on the first execution.What could be the reason
11g
By: ashwanth77 on Fri, 07 February 2014
1 726 Fri, 07 February 2014 07:51
By: John Watson
  package size
oracle 11.2.g OS windows,
By: anncao on Thu, 06 February 2014
6 1314 Sat, 08 February 2014 00:44
By: Kevin Meade
  Useful quotes to share with developers
11.2.0.2. on Linux
By: orausern on Sat, 01 February 2014
4 1884 Mon, 03 February 2014 12:33
By: orausern
  I/O Tuning
11.2.0.2
By: varunvir on Fri, 31 January 2014
1 874 Fri, 31 January 2014 11:12
By: BlackSwan
  Assigning Quota on morethan one tablespace
Oracle Database, 10.2.0.5.0,Windows Server 2003
By: Guna4324 on Tue, 28 January 2014
4 858 Tue, 28 January 2014 02:41
By: John Watson
icon5.gif Sudden decrease in performance of query
Oracle, 10g, Linux
By: qmg1 on Mon, 27 January 2014
4 1306 Mon, 27 January 2014 05:44
By: cookiemonster
  More Hash Value
Oracle 10g
By: shakthi@chettinadmail.com on Sat, 25 January 2014
1 644 Sat, 25 January 2014 00:35
By: BlackSwan
  Is this example correct?
Generic
By: manubatham20 on Fri, 24 January 2014
3 1202 Sat, 25 January 2014 08:59
By: manubatham20
  Tuning query without where clause
Oracle 11g, Windows Server 2008 using Toad 11
By: jxh461 on Tue, 21 January 2014
6 1670 Thu, 20 February 2014 06:57
By: Kevin Meade
  DB in snail's pace or bad SQL query or bad DB design?
Oracle 10g
By: rc3d on Tue, 21 January 2014
2 1275 Tue, 21 January 2014 22:17
By: Kevin Meade
  Tuning for select query
oracle 10g,win xp
By: Xandot on Tue, 14 January 2014
1 1170 Wed, 15 January 2014 03:12
By: cookiemonster
  something similar to mysqlslap (Load Emulation Client) for Oracle DB?
Oracle 10g
By: rc3d on Tue, 14 January 2014
1 1157 Tue, 14 January 2014 09:27
By: BlackSwan
  general view is also takin long time, all of sudden...
11g,11.2.0.3,solaris 10
By: ishika_20 on Mon, 13 January 2014
2 906 Tue, 14 January 2014 02:51
By: ishika_20
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 Aug 21 14:52:17 CDT 2017

Total time taken to generate the page: 0.01916 seconds