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

    Replies Views Last message
  package size
oracle 11.2.g OS windows,
By: anncao on Thu, 06 February 2014
6 4979 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 3457 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 5200 Mon, 03 February 2014 12:33
By: orausern
  I/O Tuning
11.2.0.2
By: varunvir on Fri, 31 January 2014
1 3754 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 4493 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 4923 Mon, 27 January 2014 05:44
By: cookiemonster
  Is this example correct?
Generic
By: manubatham20 on Fri, 24 January 2014
3 17559 Sat, 25 January 2014 08:59
By: manubatham20
  More Hash Value
Oracle 10g
By: shakthi@chettinadmail.com on Sat, 25 January 2014
1 3913 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 4306 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 4273 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 5259 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 4052 Tue, 14 January 2014 02:51
By: ishika_20
  Query Regarding, Average Active Session
By: VIP2013 on Mon, 13 January 2014
3 5116 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 4581 Mon, 13 January 2014 12:27
By: Amine
  Checking Lock history
By: VIP2013 on Mon, 13 January 2014
1 5314 Mon, 13 January 2014 09:46
By: BlackSwan
  Tuning suggestions on query
Oracle 11g;window2007
By: mohan1760 on Tue, 07 January 2014
3 4466 Fri, 10 January 2014 08:35
By: Kevin Meade
  Performance issue
oracle 11g r2
By: kurki on Tue, 31 December 2013
13 8089 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 5645 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 8644 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 5169 Sun, 29 December 2013 08:03
By: Kevin Meade
  Bitmap causing deadlock
11.2.0.3
By: rishwinger on Mon, 23 December 2013
12 12467 Sun, 29 December 2013 07:59
By: Kevin Meade
  Performance Issue
Oracle 10g, Windows
By: pstanand on Thu, 19 December 2013
20 8053 Mon, 23 December 2013 05:19
By: michael_bialik
  Oracle alerts
11.2.0.3
By: ivojames on Thu, 19 December 2013
14 8350 Fri, 20 December 2013 12:24
By: BlackSwan
  Query taking more time
By: nishant87 on Tue, 17 December 2013
39 10329 Thu, 19 December 2013 12:53
By: BlackSwan
  Performance Monitoring .
By: VIP2013 on Thu, 19 December 2013
1 3733 Thu, 19 December 2013 05:22
By: martijn
  Optimizing Select from VIEW
Oracle 10G
By: gauravgautam135 on Thu, 12 December 2013
3 4578 Sat, 14 December 2013 15:30
By: Kevin Meade
  SQL Tuning Advisor
11g
By: srikanthreddy001 on Fri, 13 December 2013
3 5057 Fri, 13 December 2013 04:12
By: martijn
  how avoid merge join cartesian.
Oracle 11g
By: na.dharma@gmail.com on Thu, 05 December 2013
4 18121 Thu, 12 December 2013 02:10
By: michael_bialik
  how to avoid negative values to number datatype in oracle
Oracle 11g
By: na.dharma@gmail.com on Wed, 11 December 2013
13 7685 Wed, 11 December 2013 04:48
By: Lalit Kumar B
  look like same query, but huge query plan different.
Oracle 11g
By: na.dharma@gmail.com on Tue, 10 December 2013
7 4829 Wed, 11 December 2013 03:08
By: John Watson
  SQL with BIND Variable Slow - Bind Peeking
11.2
By: prax_14 on Mon, 09 December 2013
3 4139 Wed, 11 December 2013 01:10
By: John Watson
  How to correct completely wrong cardinality shown in query plan
10.2.0.4 on Linux
By: orausern on Thu, 05 December 2013
29 11343 Fri, 06 December 2013 11:11
By: orausern
  FTS on table
Oracle 11g, Unix
By: a_oracle on Thu, 05 December 2013
4 5294 Fri, 06 December 2013 08:35
By: Kevin Meade
  Changing the defaut number of Plans checked by optimzer
Aix
By: deadpoet69 on Tue, 03 December 2013
3 4298 Wed, 04 December 2013 04:07
By: Roachcoach
  Need help in tuning query
By: nishant87 on Fri, 29 November 2013
5 7437 Sun, 01 December 2013 17:29
By: Kevin Meade
  Automatic SQL Tuning
oracle 10.2.0.4 - Windows server 2003
By: muktha_22 on Thu, 28 November 2013
3 4409 Fri, 29 November 2013 01:20
By: Lalit Kumar B
  Need help in tuning query
11i
By: nishant87 on Tue, 26 November 2013
4 4499 Tue, 26 November 2013 11:34
By: BlackSwan
  Performance degrade
Oracle 11gr2 , linux AS5
By: oradba123 on Sat, 23 November 2013
3 4082 Tue, 26 November 2013 08:08
By: Kevin Meade
  fast query
By: narang79 on Mon, 25 November 2013
6 4598 Tue, 26 November 2013 08:00
By: Kevin Meade
  Please help me my query performance is bad.
Oracle 11g
By: ramya_162 on Wed, 20 November 2013
24 9074 Mon, 25 November 2013 06:18
By: ramya_162
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 Mar 28 20:31:24 CDT 2024