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

    Replies Views Last message
  cost is more after releasing FTS on big table (partition table)
11g, 11.2.0.3, Window server
By: ashishkumarmahanta80 on Tue, 08 September 2015
11 1098 Wed, 09 September 2015 01:35
By: John Watson
  Query in active session for more than 2 hours
11.2.0.4
By: varunvir on Mon, 08 June 2015
5 1223 Sun, 06 September 2015 10:14
By: Kevin Meade
  Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high times on USER_IO_WAIT_TIME
11.2.0.4 on Linux
By: orausern on Fri, 04 September 2015
6 959 Fri, 04 September 2015 13:07
By: orausern
  Oracle noforce view creates force view
By: ram50958 on Tue, 25 August 2015
8 2189 Tue, 25 August 2015 11:13
By: Michel Cadot
  Response time
12.1.0.1.0, solaris
By: kapilavastu on Tue, 21 July 2015
5 1154 Mon, 24 August 2015 21:02
By: Kevin Meade
  Interesting performance bottle neck issue
Oracle 11g
By: ram50958 on Wed, 19 August 2015
10 1218 Wed, 19 August 2015 10:09
By: BlackSwan
  Please help for Resolving Issue for Explain plan as query taking long time for execution
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 09 August 2015
15 1698 Fri, 14 August 2015 12:27
By: Kevin Meade
  statistics update
11.2.0.3 on Windows 2008 R2
By: sant_new1 on Thu, 13 August 2015
11 1127 Fri, 14 August 2015 12:07
By: BlackSwan
  query with hundreds of bind variables
Oracle database 11gR2 11.2.0.2.3
By: fplatel on Tue, 11 August 2015
2 683 Tue, 11 August 2015 21:55
By: John Watson
  Help to tune the query
11.2.0
By: grpatwari on Mon, 03 August 2015
11 1944 Fri, 07 August 2015 08:56
By: Kevin Meade
  Cost Issue while using row_number()
By: AJAYRAM on Thu, 06 August 2015
11 1394 Fri, 07 August 2015 04:48
By: cookiemonster
  A way to identify the top sql other than AWR
11.2.0.4 on Linux
By: orausern on Tue, 04 August 2015
5 796 Tue, 04 August 2015 11:46
By: orausern
  TKPROF output analysis
windows 2012, oracle 12c
By: muktha_22 on Wed, 22 July 2015
4 1279 Thu, 23 July 2015 01:39
By: Michel Cadot
  Tuning data deletion that is taking long time
11.2.0.4 on Linux
By: orausern on Sat, 11 July 2015
16 1764 Fri, 17 July 2015 05:59
By: orausern
  Drop Unused columns
12.1.0.2.0,Linux x86_64
By: preet_kumar on Thu, 16 July 2015
3 658 Thu, 16 July 2015 09:28
By: bpeasland
  Help for tuning the sql Query
11.2.0.1
By: grpatwari on Wed, 15 July 2015
9 1334 Thu, 16 July 2015 03:22
By: cookiemonster
  Change in he execution plan
12c
By: jinga on Mon, 13 July 2015
8 1146 Wed, 15 July 2015 02:48
By: cookiemonster
  Query not have much cost on Explain Plan but very very slow
oracle 10g
By: toom2525 on Sun, 12 July 2015
4 1055 Mon, 13 July 2015 02:07
By: John Watson
  Please provide help for tuning the sql Query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 12 July 2015
1 728 Sun, 12 July 2015 07:19
By: John Watson
  Histograms - good or bad? (split from http://www.orafaq.com/forum/mv/msg/197539/638244/#msg_638244)
By: Roachcoach on Fri, 03 July 2015
8 1261 Tue, 07 July 2015 04:22
By: John Watson
  Oracle does not use a conditional index
oracle 11g
By: iblazquez on Mon, 08 June 2015
7 2412 Mon, 06 July 2015 13:46
By: John Watson
  flashback
Oracle 11g
By: ashish.tiwari on Sat, 04 July 2015
8 1189 Mon, 06 July 2015 03:22
By: gazzag
  'Configuration' wait class in AWR report
12
By: karthik4u on Sun, 05 July 2015
4 2744 Sun, 05 July 2015 08:29
By: John Watson
  Oracle Optimizer cost (merged)
Oracle11g
By: shrinika on Tue, 30 June 2015
8 1205 Wed, 01 July 2015 10:16
By: Lalit Kumar B
  SQL Tuning Advise
Oracle 11.2.0.4.0 - 64bit Production
By: avineshr on Thu, 18 June 2015
8 2212 Fri, 19 June 2015 11:57
By: BlackSwan
  ANALYZE and GATHER STATS
windows 2012, oracle 12c
By: muktha_22 on Wed, 10 June 2015
17 1452 Thu, 11 June 2015 01:23
By: Lalit Kumar B
  Oracle Performance Issue linked to Concurrency
11G
By: sachinj on Mon, 01 June 2015
4 1262 Wed, 03 June 2015 02:09
By: John Watson
  Please help for improving execution plan
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Mon, 01 June 2015
8 1056 Tue, 02 June 2015 02:35
By: Roachcoach
  properly tune parallel parameters?
By: dba2015 on Sun, 31 May 2015
1 557 Sun, 31 May 2015 13:53
By: Michel Cadot
  How Can I Tune this Query
Oracle SE 10g R2 - 10.2.0.1.0
By: mdsirajoddin on Fri, 22 May 2015
6 1480 Tue, 26 May 2015 09:04
By: cookiemonster
  Materialized view option (suggestion)
Oracle 11.2.0.4, Linux x86 64
By: hitesh.bhatt on Fri, 22 May 2015
5 772 Fri, 22 May 2015 09:34
By: bpeasland
  SQL execution takes long time
Oracle 11.2.0.3, Linux x86 64
By: hitesh.bhatt on Thu, 21 May 2015
7 1066 Fri, 22 May 2015 01:19
By: hitesh.bhatt
  Select statement taking Long time to execute
Oracle 10g
By: P1Oracle on Thu, 21 May 2015
7 1980 Thu, 21 May 2015 23:18
By: rleishman
  Set NOLOGGING for tables in UAT
windows 2012, oracle 12c
By: muktha_22 on Wed, 20 May 2015
6 939 Thu, 21 May 2015 09:24
By: bpeasland
  Find cpu MHz in Oracle view
Linux red hat 6.6, oracle 11.2.0.4
By: Malakay79 on Thu, 14 May 2015
2 668 Thu, 14 May 2015 08:01
By: BlackSwan
  ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION - Kevin Meade's book corner
By: paolfili on Sun, 19 April 2015
9 2550 Tue, 12 May 2015 10:29
By: paolfili
  How to check index is re-built
11g, 11.2.0.3, Window server
By: ashishkumarmahanta80 on Thu, 30 April 2015
3 833 Thu, 30 April 2015 02:21
By: ashishkumarmahanta80
  Query running very slow
oracle 9i, windows 2003 server
By: zkdba on Thu, 16 April 2015
5 1181 Sun, 19 April 2015 13:40
By: Kevin Meade
  Do we need to rebound instance when we Determine the Practical Range for FAST_START_MTTR_TARGET
11.2.0.3 Enterprise Edition
By: juniordbanewbie on Tue, 20 January 2015
3 1663 Fri, 17 April 2015 20:38
By: juniordbanewbie
  INDEX FULL SCAN (MIN/MAX)
11.2.0.3
By: Roachcoach on Mon, 06 April 2015
4 1577 Mon, 13 April 2015 02:35
By: Roachcoach
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 Jan 16 08:00:18 CST 2018

Total time taken to generate the page: 0.01673 seconds