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

    Replies Views Last message
  Assigning Quota on morethan one tablespace
Oracle Database, 10.2.0.5.0,Windows Server 2003
By: Guna4324 on Tue, 28 January 2014
4 881 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 1338 Mon, 27 January 2014 05:44
By: cookiemonster
  More Hash Value
Oracle 10g
By: shakthi@chettinadmail.com on Sat, 25 January 2014
1 662 Sat, 25 January 2014 00:35
By: BlackSwan
  Is this example correct?
Generic
By: manubatham20 on Fri, 24 January 2014
3 7750 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 1715 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 1299 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 1184 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 1215 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 922 Tue, 14 January 2014 02:51
By: ishika_20
  Query Regarding, Average Active Session
By: VIP2013 on Mon, 13 January 2014
3 1566 Mon, 13 January 2014 12:29
By: VIP2013
  Checking Lock history
By: VIP2013 on Mon, 13 January 2014
1 899 Mon, 13 January 2014 09:46
By: BlackSwan
  Performance issue
9.2.0.8 and 11.2.0.3
By: Amine on Fri, 10 January 2014
4 1262 Mon, 13 January 2014 12:27
By: Amine
  Tuning suggestions on query
Oracle 11g;window2007
By: mohan1760 on Tue, 07 January 2014
3 1215 Fri, 10 January 2014 08:35
By: Kevin Meade
  DBA_HIST_SEG_STAT view
11.2.0.3
By: rishwinger on Mon, 06 January 2014
7 6118 Fri, 20 June 2014 00:50
By: Michel Cadot
  Please help me merge query is taking more time
Oracle 11g
By: ramya_162 on Sat, 04 January 2014
10 1493 Mon, 06 January 2014 02:44
By: cookiemonster
  Performance issue
oracle 11g r2
By: kurki on Tue, 31 December 2013
13 2152 Wed, 08 January 2014 00:39
By: pablolee
  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 2797 Sat, 04 January 2014 07:20
By: Kevin Meade
  Bitmap causing deadlock
11.2.0.3
By: rishwinger on Mon, 23 December 2013
12 4985 Sun, 29 December 2013 07:59
By: Kevin Meade
  Oracle alerts
11.2.0.3
By: ivojames on Thu, 19 December 2013
14 2698 Fri, 20 December 2013 12:24
By: BlackSwan
  Performance Issue
Oracle 10g, Windows
By: pstanand on Thu, 19 December 2013
20 2472 Mon, 23 December 2013 05:19
By: michael_bialik
  Normally why count (*) taking so much of time when compare to select *
By: na.dharma@gmail.com on Thu, 19 December 2013
4 1575 Sun, 29 December 2013 08:03
By: Kevin Meade
  Performance Monitoring .
By: VIP2013 on Thu, 19 December 2013
1 716 Thu, 19 December 2013 05:22
By: martijn
  Query taking more time
By: nishant87 on Tue, 17 December 2013
39 3548 Thu, 19 December 2013 12:53
By: BlackSwan
  SQL Tuning Advisor
11g
By: srikanthreddy001 on Fri, 13 December 2013
3 1088 Fri, 13 December 2013 04:12
By: martijn
  Optimizing Select from VIEW
Oracle 10G
By: gauravgautam135 on Thu, 12 December 2013
3 1055 Sat, 14 December 2013 15:30
By: Kevin Meade
  how to avoid negative values to number datatype in oracle
Oracle 11g
By: na.dharma@gmail.com on Wed, 11 December 2013
13 1682 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 1081 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 1106 Wed, 11 December 2013 01:10
By: John Watson
  how avoid merge join cartesian.
Oracle 11g
By: na.dharma@gmail.com on Thu, 05 December 2013
4 7976 Thu, 12 December 2013 02:10
By: michael_bialik
  How to correct completely wrong cardinality shown in query plan
10.2.0.4 on Linux
By: orausern on Thu, 05 December 2013
29 2891 Fri, 06 December 2013 11:11
By: orausern
  FTS on table
Oracle 11g, Unix
By: a_oracle on Thu, 05 December 2013
4 1251 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 998 Wed, 04 December 2013 04:07
By: Roachcoach
  max and min function taking lot of time
oracle 10g
By: vivek_rol on Tue, 06 January 2015
4 2440 Wed, 07 January 2015 22:45
By: Kevin Meade
  Need help in tuning query
By: nishant87 on Fri, 29 November 2013
5 2619 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 965 Fri, 29 November 2013 01:20
By: Lalit Kumar B
  Need help in tuning query
11i
By: nishant87 on Tue, 26 November 2013
4 1283 Tue, 26 November 2013 11:34
By: BlackSwan
  fast query
By: narang79 on Mon, 25 November 2013
6 1205 Tue, 26 November 2013 08:00
By: Kevin Meade
  SQL & PL/SQL
By: varshbugad on Mon, 25 November 2013
1 816 Mon, 25 November 2013 02:04
By: pablolee
  Performance degrade
Oracle 11gr2 , linux AS5
By: oradba123 on Sat, 23 November 2013
3 847 Tue, 26 November 2013 08:08
By: Kevin Meade
  Please help me my query performance is bad.
Oracle 11g
By: ramya_162 on Wed, 20 November 2013
24 2341 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: Mon Oct 23 01:28:31 CDT 2017

Total time taken to generate the page: 0.05116 seconds