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

    Replies Views Last message
  A way to identify the top sql other than AWR
11.2.0.4 on Linux
By: orausern on Tue, 04 August 2015
5 762 Tue, 04 August 2015 11:46
By: orausern
  TKPROF output analysis
windows 2012, oracle 12c
By: muktha_22 on Wed, 22 July 2015
4 1198 Thu, 23 July 2015 01:39
By: Michel Cadot
  Response time
12.1.0.1.0, solaris
By: kapilavastu on Tue, 21 July 2015
5 1112 Mon, 24 August 2015 21:02
By: Kevin Meade
  Help for tuning the sql Query
11.2.0.1
By: grpatwari on Wed, 15 July 2015
9 1293 Thu, 16 July 2015 03:22
By: cookiemonster
  Change in he execution plan
12c
By: jinga on Mon, 13 July 2015
8 1114 Wed, 15 July 2015 02:48
By: cookiemonster
  Drop Unused columns
12.1.0.2.0,Linux x86_64
By: preet_kumar on Thu, 16 July 2015
3 632 Thu, 16 July 2015 09:28
By: bpeasland
  Query not have much cost on Explain Plan but very very slow
oracle 10g
By: toom2525 on Sun, 12 July 2015
4 1019 Mon, 13 July 2015 02:07
By: John Watson
  Tuning data deletion that is taking long time
11.2.0.4 on Linux
By: orausern on Sat, 11 July 2015
16 1712 Fri, 17 July 2015 05:59
By: orausern
  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 702 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 1208 Tue, 07 July 2015 04:22
By: John Watson
  'Configuration' wait class in AWR report
12
By: karthik4u on Sun, 05 July 2015
4 2484 Sun, 05 July 2015 08:29
By: John Watson
  flashback
Oracle 11g
By: ashish.tiwari on Sat, 04 July 2015
8 1164 Mon, 06 July 2015 03:22
By: gazzag
  Oracle Optimizer cost (merged)
Oracle11g
By: shrinika on Tue, 30 June 2015
8 1151 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 2109 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 1398 Thu, 11 June 2015 01:23
By: Lalit Kumar B
  Query in active session for more than 2 hours
11.2.0.4
By: varunvir on Mon, 08 June 2015
5 1189 Sun, 06 September 2015 10:14
By: Kevin Meade
  Oracle does not use a conditional index
oracle 11g
By: iblazquez on Mon, 08 June 2015
7 2371 Mon, 06 July 2015 13:46
By: John Watson
  Oracle Performance Issue linked to Concurrency
11G
By: sachinj on Mon, 01 June 2015
4 1220 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 1010 Tue, 02 June 2015 02:35
By: Roachcoach
  properly tune parallel parameters?
By: dba2015 on Sun, 31 May 2015
1 532 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 1452 Tue, 26 May 2015 09:04
By: cookiemonster
  Select statement taking Long time to execute
Oracle 10g
By: P1Oracle on Thu, 21 May 2015
7 1908 Thu, 21 May 2015 23:18
By: rleishman
  Materialized view option (suggestion)
Oracle 11.2.0.4, Linux x86 64
By: hitesh.bhatt on Fri, 22 May 2015
5 735 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 1020 Fri, 22 May 2015 01:19
By: hitesh.bhatt
  Set NOLOGGING for tables in UAT
windows 2012, oracle 12c
By: muktha_22 on Wed, 20 May 2015
6 900 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 641 Thu, 14 May 2015 08:01
By: BlackSwan
  How to check index is re-built
11g, 11.2.0.3, Window server
By: ashishkumarmahanta80 on Thu, 30 April 2015
3 801 Thu, 30 April 2015 02:21
By: ashishkumarmahanta80
  ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION - Kevin Meade's book corner
By: paolfili on Sun, 19 April 2015
9 2406 Tue, 12 May 2015 10:29
By: paolfili
  indexing nulls
oracle 11.2.0.4 on Linux
By: orausern on Fri, 10 April 2015
6 1193 Fri, 10 April 2015 11:24
By: Lalit Kumar B
  performance
By: rameshk0316@gmail.com on Tue, 31 March 2015
3 902 Tue, 31 March 2015 08:57
By: Michel Cadot
  Query running very slow
oracle 9i, windows 2003 server
By: zkdba on Thu, 16 April 2015
5 1139 Sun, 19 April 2015 13:40
By: Kevin Meade
  INDEX FULL SCAN (MIN/MAX)
11.2.0.3
By: Roachcoach on Mon, 06 April 2015
4 1492 Mon, 13 April 2015 02:35
By: Roachcoach
  performance
By: rameshk0316@gmail.com on Tue, 31 March 2015
2 602 Wed, 01 April 2015 00:15
By: Michel Cadot
  Image File Size
oracle 11 g
By: simplesanju on Tue, 24 March 2015
0 715 Tue, 24 March 2015 02:35
By: simplesanju
  Bind variable for date type takes longer time in a query
toad 10g
By: nciteamo on Fri, 20 March 2015
3 1178 Sun, 29 March 2015 07:53
By: Kevin Meade
  Performance improvement required
Oracle 10G
By: saurabh.sha on Wed, 18 March 2015
10 14388 Fri, 11 September 2015 09:12
By: BlackSwan
  CPU consumption calculation for sqls
Oracle 11.2.0.4, AIX 6.1
By: saurabhshukladba on Mon, 16 March 2015
1 935 Mon, 16 March 2015 11:27
By: Michel Cadot
  Compression benefits and options
Oracle 11.2.0.4 on Linux
By: orausern on Thu, 12 March 2015
8 1064 Sun, 15 March 2015 12:27
By: orausern
  Information to provide when asking for tuning help.
By: Kevin Meade on Wed, 11 March 2015
0 684 Wed, 11 March 2015 20:43
By: Kevin Meade
  Same Data, Two machines but different timings. Why?
10.2.0.1.0
By: bluetooth420 on Mon, 09 March 2015
10 1101 Tue, 10 March 2015 22:43
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: Sun Nov 19 09:53:58 CST 2017

Total time taken to generate the page: 0.01478 seconds