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

    Replies Views Last message
  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 1626 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 1060 Sun, 29 December 2013 08:03
By: Kevin Meade
  Bitmap causing deadlock
11.2.0.3
By: rishwinger on Mon, 23 December 2013
12 2545 Sun, 29 December 2013 07:59
By: Kevin Meade
  Performance Issue
Oracle 10g, Windows
By: pstanand on Thu, 19 December 2013
20 1736 Mon, 23 December 2013 05:19
By: michael_bialik
  Oracle alerts
11.2.0.3
By: ivojames on Thu, 19 December 2013
14 1821 Fri, 20 December 2013 12:24
By: BlackSwan
  Query taking more time
By: nishant87 on Tue, 17 December 2013
39 2584 Thu, 19 December 2013 12:53
By: BlackSwan
  Performance Monitoring .
By: VIP2013 on Thu, 19 December 2013
1 403 Thu, 19 December 2013 05:22
By: martijn
  Optimizing Select from VIEW
Oracle 10G
By: gauravgautam135 on Thu, 12 December 2013
3 648 Sat, 14 December 2013 15:30
By: Kevin Meade
  SQL Tuning Advisor
11g
By: srikanthreddy001 on Fri, 13 December 2013
3 700 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 2866 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 995 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 655 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 695 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 1573 Fri, 06 December 2013 11:11
By: orausern
  FTS on table
Oracle 11g, Unix
By: a_oracle on Thu, 05 December 2013
4 703 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 635 Wed, 04 December 2013 04:07
By: Roachcoach
  Need help in tuning query
By: nishant87 on Fri, 29 November 2013
5 1307 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 627 Fri, 29 November 2013 01:20
By: Lalit Kumar B
  Need help in tuning query
11i
By: nishant87 on Tue, 26 November 2013
4 867 Tue, 26 November 2013 11:34
By: BlackSwan
  Performance degrade
Oracle 11gr2 , linux AS5
By: oradba123 on Sat, 23 November 2013
3 562 Tue, 26 November 2013 08:08
By: Kevin Meade
  fast query
By: narang79 on Mon, 25 November 2013
6 694 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 1485 Mon, 25 November 2013 06:18
By: ramya_162
  SQL & PL/SQL
By: varshbugad on Mon, 25 November 2013
1 378 Mon, 25 November 2013 02:04
By: pablolee
  Locking In application code.
By: VIP2013 on Mon, 18 November 2013
6 725 Fri, 22 November 2013 17:04
By: EdStevens
  SELECT works, INSERT+ SELECT hangs in SQLDeveloper Tools
Oracle, 11.2, SQLDeveloper
By: royalyogi on Tue, 19 November 2013
15 1151 Thu, 21 November 2013 02:38
By: cookiemonster
  Need advice on index to apply
Oracle 11.2, Window 2008
By: jxh461 on Tue, 19 November 2013
10 799 Wed, 20 November 2013 16:23
By: Kevin Meade
  Oracle DB Performance Tests
Oracle 11g
By: ind9 on Tue, 05 November 2013
6 1502 Wed, 13 November 2013 17:51
By: alan.kendall@nfl.com
  Please help me how to improve the performance of this query further.
Oracle 11g
By: ramya_162 on Thu, 07 November 2013
33 2179 Tue, 12 November 2013 11:15
By: cookiemonster
  forms 6i too slow when database have approximately 1 million records
Oracle 8i
By: qanita786 on Sat, 09 November 2013
4 799 Mon, 11 November 2013 05:58
By: Littlefoot
  Adaptive Cursor Sharing VS SPM
By: VIP2013 on Tue, 05 November 2013
3 718 Sat, 09 November 2013 13:45
By: VIP2013
  Which SQL is faster/better
Oracle
By: mokarem on Mon, 04 November 2013
11 1592 Wed, 06 November 2013 03:32
By: cookiemonster
  Performance issue in one sql
11i
By: nishantranjan87 on Fri, 18 October 2013
4 874 Tue, 05 November 2013 23:35
By: Kevin Meade
  Understanding ASH
Oracle 10g,10.2.0.4.0, windows server 2008
By: zahidbutt on Tue, 05 November 2013
1 560 Tue, 05 November 2013 01:47
By: Lalit Kumar B
  Tiff Images and Oracle
Oracle 10, 11 and 12
By: Diego Pafumi on Thu, 31 October 2013
6 1190 Fri, 01 November 2013 11:22
By: gazzag
  DB performance problem or "bad" SQL query
Oracle 10g
By: rc3d on Thu, 24 October 2013
30 2504 Wed, 30 October 2013 12:25
By: Michel Cadot
  Please help me on tune this query
Oracle 11g
By: ajaykumarkona on Tue, 11 December 2012
27 1892 Wed, 30 October 2013 08:49
By: pablolee
  XML/XPath rewrites and plan baselines
11.2.0.4 RHEL
By: Roachcoach on Tue, 29 October 2013
6 805 Wed, 30 October 2013 04:12
By: Roachcoach
  standard SQL query to benchmark Oracle DB response time (performance)
Oracle 10g
By: rc3d on Sat, 26 October 2013
1 635 Sat, 26 October 2013 06:17
By: Michel Cadot
  How To Increase Data Reterival / Insertion Speed
Oacle 8i and Forms 6i
By: qanita786 on Thu, 24 October 2013
2 955 Thu, 24 October 2013 04:47
By: Michel Cadot
  db file parallel read
11.2.0.3.0
By: rishwinger on Fri, 11 October 2013
4 2189 Mon, 21 October 2013 03:38
By: michael_bialik
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: Tue May 05 00:11:11 CDT 2015

Total time taken to generate the page: 0.13188 seconds