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

    Replies Views Last message
  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 1401 Mon, 24 March 2014 00:29
By: Kevin Meade
  statement with big cost
Oracle Database 11.2.0.2.0
By: Roger22 on Fri, 21 March 2014
9 999 Fri, 21 March 2014 09:18
By: cookiemonster
  session uga memory
By: ashu205 on Tue, 18 March 2014
1 1162 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 1091 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 1205 Sat, 15 March 2014 05:45
By: John Watson
  What is the most expensive dml transaction, insert, update, delete?
Oracle
By: steves on Sun, 24 March 2013
12 2537 Fri, 14 March 2014 17:49
By: youngryand
  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 2948 Thu, 13 March 2014 22:49
By: hitesh.bhatt
  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 1210 Thu, 13 March 2014 20:04
By: rleishman
  SQL Repair
Oracle 11g , Unix
By: younusc on Mon, 10 March 2014
3 883 Thu, 13 March 2014 00:02
By: Markwillium
  database performance tuning
By: likhonisrat on Tue, 11 March 2014
1 576 Tue, 11 March 2014 06:42
By: John Watson
  Query is taking long time
11i
By: Vivek_Garg on Sun, 09 March 2014
16 1606 Mon, 10 March 2014 04:49
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 1765 Fri, 07 March 2014 01:41
By: suresh.wst
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 509 Thu, 06 March 2014 07:09
By: John Watson
  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 1476 Sun, 02 March 2014 22:03
By: trantuananh24hg
  Oracle contain clause performance issue
Oracle / 11g r2/unix
By: balaji123 on Fri, 28 February 2014
2 586 Fri, 28 February 2014 02:13
By: balaji123
  Oracle Architecture
By: gasbie on Sun, 23 February 2014
2 893 Mon, 24 February 2014 00:49
By: John Watson
  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 3545 Fri, 21 February 2014 20:44
By: Kevin Meade
  Bloom filter joins
By: Kevin Meade on Thu, 20 February 2014
4 1887 Fri, 21 February 2014 20:16
By: Kevin Meade
  Tuning query without where clause
Oracle 11g, Windows Server 2008 using Toad 11
By: jxh461 on Tue, 21 January 2014
6 1311 Thu, 20 February 2014 06:57
By: Kevin Meade
  package size
oracle 11.2.g OS windows,
By: anncao on Thu, 06 February 2014
6 931 Sat, 08 February 2014 00:44
By: Kevin Meade
  result cache physical reads 0 on the first execution.What could be the reason
11g
By: ashwanth77 on Fri, 07 February 2014
1 535 Fri, 07 February 2014 07:51
By: John Watson
  Useful quotes to share with developers
11.2.0.2. on Linux
By: orausern on Sat, 01 February 2014
4 1595 Mon, 03 February 2014 12:33
By: orausern
  I/O Tuning
11.2.0.2
By: varunvir on Fri, 31 January 2014
1 666 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 664 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 946 Mon, 27 January 2014 05:44
By: cookiemonster
  Is this example correct?
Generic
By: manubatham20 on Fri, 24 January 2014
3 941 Sat, 25 January 2014 08:59
By: manubatham20
  More Hash Value
Oracle 10g
By: shakthi@chettinadmail.com on Sat, 25 January 2014
1 457 Sat, 25 January 2014 00:35
By: BlackSwan
  DB in snail's pace or bad SQL query or bad DB design?
Oracle 10g
By: rc3d on Tue, 21 January 2014
2 967 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 924 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 790 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 721 Tue, 14 January 2014 02:51
By: ishika_20
  Query Regarding, Average Active Session
By: VIP2013 on Mon, 13 January 2014
3 1032 Mon, 13 January 2014 12:29
By: VIP2013
  Performance issue
9.2.0.8 and 11.2.0.3
By: Amine on Fri, 10 January 2014
4 1005 Mon, 13 January 2014 12:27
By: Amine
  Checking Lock history
By: VIP2013 on Mon, 13 January 2014
1 630 Mon, 13 January 2014 09:46
By: BlackSwan
  Tuning suggestions on query
Oracle 11g;window2007
By: mohan1760 on Tue, 07 January 2014
3 940 Fri, 10 January 2014 08:35
By: Kevin Meade
  Performance issue
oracle 11g r2
By: kurki on Tue, 31 December 2013
13 1765 Wed, 08 January 2014 00:39
By: pablolee
  Please help me merge query is taking more time
Oracle 11g
By: ramya_162 on Sat, 04 January 2014
10 1187 Mon, 06 January 2014 02:44
By: cookiemonster
  Query is taking huge time to display the record
Oracle e-business Suite 12.1.3.
By: ajit.jha31 on Mon, 30 December 2013
8 2018 Sat, 04 January 2014 07:20
By: Kevin Meade
  Normally why count (*) taking so much of time when compare to select *
By: na.dharma@gmail.com on Thu, 19 December 2013
4 1209 Sun, 29 December 2013 08:03
By: Kevin Meade
  Bitmap causing deadlock
11.2.0.3
By: rishwinger on Mon, 23 December 2013
12 3344 Sun, 29 December 2013 07:59
By: Kevin Meade
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 Feb 06 17:43:00 CST 2016

Total time taken to generate the page: 0.13074 seconds