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

    Replies Views Last message
  Tuning data deletion that is taking long time
11.2.0.4 on Linux
By: orausern on Sat, 11 July 2015
16 1651 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 682 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 1150 Tue, 07 July 2015 04:22
By: John Watson
  'Configuration' wait class in AWR report
12
By: karthik4u on Sun, 05 July 2015
4 2174 Sun, 05 July 2015 08:29
By: John Watson
  flashback
Oracle 11g
By: ashish.tiwari on Sat, 04 July 2015
8 1124 Mon, 06 July 2015 03:22
By: gazzag
  Oracle Optimizer cost (merged)
Oracle11g
By: shrinika on Tue, 30 June 2015
8 1090 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 2002 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 1325 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 1165 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 2334 Mon, 06 July 2015 13:46
By: John Watson
  Oracle Performance Issue linked to Concurrency
11G
By: sachinj on Mon, 01 June 2015
4 1176 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 964 Tue, 02 June 2015 02:35
By: Roachcoach
  properly tune parallel parameters?
By: dba2015 on Sun, 31 May 2015
1 519 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 1398 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 1819 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 708 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 908 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 866 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 621 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 777 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 2257 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 1150 Fri, 10 April 2015 11:24
By: Lalit Kumar B
  performance
By: rameshk0316@gmail.com on Tue, 31 March 2015
3 870 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 1094 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 1429 Mon, 13 April 2015 02:35
By: Roachcoach
  performance
By: rameshk0316@gmail.com on Tue, 31 March 2015
2 587 Wed, 01 April 2015 00:15
By: Michel Cadot
  Image File Size
oracle 11 g
By: simplesanju on Tue, 24 March 2015
0 702 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 1149 Sun, 29 March 2015 07:53
By: Kevin Meade
  Performance improvement required
Oracle 10G
By: saurabh.sha on Wed, 18 March 2015
10 14329 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 903 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 1028 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 671 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 1049 Tue, 10 March 2015 22:43
By: Kevin Meade
  Database today's load vs yesterday
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: ind9 on Thu, 05 March 2015
9 866 Fri, 06 March 2015 10:49
By: ind9
  The differential between Index hint and no hint
Oracle 10gr2, RHEL5
By: trantuananh24hg on Mon, 02 March 2015
4 727 Tue, 03 March 2015 01:51
By: trantuananh24hg
  v$service_stats information
Oracle 11.2.0.4 on Linux RH6
By: Malakay79 on Mon, 02 March 2015
6 888 Mon, 02 March 2015 03:25
By: Michel Cadot
  How to take OSWatcher baseline
11.2.0.3 SLES SP 3
By: juniordbanewbie on Fri, 27 February 2015
1 625 Fri, 27 February 2015 00:28
By: BlackSwan
  Parallel direct path insert no quicker (merged 2 )
Oracle 11
By: brown_zzz on Tue, 24 February 2015
15 1182 Tue, 24 February 2015 08:39
By: Roachcoach
  How to improve performance? (merged)
Oracle Database 11g Release 11.2.0.1.0 - Production, WINDOWS 7
By: mokarem on Tue, 17 February 2015
15 1338 Thu, 26 February 2015 01:30
By: mokarem
  query to data dictionary tables taking long time
11.2.0.4 on Linux
By: orausern on Tue, 24 February 2015
6 790 Tue, 24 February 2015 04:32
By: John Watson
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 Sep 21 01:43:55 CDT 2017

Total time taken to generate the page: 0.02275 seconds