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

    Replies Views Last message
icon6.gif sticky: How to tune SQL or Identify Performance Problem and Bottleneck
By: Michel Cadot on Fri, 22 June 2007
6 60680 Thu, 22 August 2013 04:09
By: Michel Cadot
  What should be recommended percentage of memory to be used for oracle
11.2.0.3 Standard Edition, SLES SP 3 64 bit
By: juniordbanewbie on Wed, 28 January 2015
3 390 Wed, 28 January 2015 18:40
By: juniordbanewbie
  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
1 618 Tue, 20 January 2015 02:08
By: John Watson
  AWR - licensing question
By: piotrtal on Tue, 12 July 2011
28 6049 Mon, 19 January 2015 10:58
By: Kevin Meade
  Updating compressed rows
All with compression options
By: Roachcoach on Tue, 13 January 2015
0 1474 Tue, 13 January 2015 08:22
By: Roachcoach
  table lock in past
Oracle 10.2.0.4.0, Aix 6.1
By: oradba123 on Mon, 12 January 2015
7 446 Mon, 12 January 2015 13:42
By: BlackSwan
  advice to rewrite a query with a bad desing
By: jojoyk on Sat, 10 January 2015
9 888 Sat, 10 January 2015 14:59
By: John Watson
  redo buffer allocation retries not near 0, how do I set _log_parallelism_max
11.2.0.3 SE, SLES 11 SP3
By: juniordbanewbie on Thu, 08 January 2015
4 2759 Fri, 09 January 2015 00:34
By: Michel Cadot
  Performance Monitor looked ugly
11.2.04
By: bvo65 on Wed, 07 January 2015
4 2042 Thu, 08 January 2015 07:44
By: BlackSwan
icon11.gif Oracle Database 11g 11.2.0.4.0 running slow
Oracle Database 11g 11.2.0.4.0
By: DevilzAdvocate on Sat, 03 January 2015
13 3471 Thu, 08 January 2015 02:09
By: DevilzAdvocate
  max and min function taking lot of time
oracle 10g
By: vivek_rol on Tue, 06 January 2015
4 1810 Wed, 07 January 2015 22:45
By: Kevin Meade
  How To Check Performace Tuning
By: mastansky@gmail.com on Mon, 05 January 2015
8 3149 Tue, 06 January 2015 09:39
By: Kevin Meade
  Optimizing Dynamic SQL Usage
G12
By: FDAVIDOV on Mon, 29 December 2014
15 3678 Sat, 03 January 2015 10:30
By: FDAVIDOV
  LNS wait on SENDREQ+ARCH wait on SENDREQ on ASYNC dataguard at primary database
11g, 11.2.0.3, solaris10
By: ashishkumarmahanta80 on Fri, 02 January 2015
3 1133 Fri, 02 January 2015 10:43
By: Michel Cadot
  Optimisation of query sql
ORacle 9i
By: achraf_ef on Thu, 25 December 2014
35 3295 Mon, 29 December 2014 19:24
By: EdStevens
  Monitor performance
By: Banurs on Mon, 22 December 2014
11 5509 Sun, 28 December 2014 21:34
By: Banurs
  Library cache (PIPES)
11g
By: mrinouk on Fri, 19 December 2014
0 4626 Fri, 19 December 2014 08:10
By: mrinouk
  Complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR
Oracle SE 11.2.0.4.4 on Linux Red Hat 6
By: Malakay79 on Fri, 19 December 2014
1 1526 Fri, 19 December 2014 03:14
By: John Watson
  Remote query performance in BO reports
Oracle 11g
By: lavk on Mon, 15 December 2014
4 3093 Thu, 18 December 2014 09:48
By: BlackSwan
  tuning basics
Oracle 10g
By: m.abdulhaq on Thu, 11 December 2014
3 1158 Fri, 12 December 2014 16:23
By: Kevin Meade
  performance issue with sql query in UAT, But good in local
By: raja.i on Fri, 05 December 2014
2 385 Fri, 05 December 2014 03:45
By: cookiemonster
  Has anyone ever seen BEGIN_OUTLINE_DATA alone change a plan
11.2.0.4
By: Roachcoach on Fri, 05 December 2014
0 886 Fri, 05 December 2014 02:55
By: Roachcoach
  Effective way to update a column to null (based on a condition) quickly in a huge 800 GB table
Oracle 11.2.0.4 on Linux
By: orausern on Thu, 04 December 2014
2 215 Thu, 04 December 2014 13:05
By: orausern
  INTERNAL_FUNCTION appears at explain plan
11g, 11.2.0.3, solaris10
By: ashishkumarmahanta80 on Thu, 13 November 2014
4 444 Wed, 03 December 2014 00:02
By: ashishkumarmahanta80
  AWR report
oracle 12c - Windows server 2012 ( 1 2)
By: muktha_22 on Tue, 18 November 2014
41 1972 Tue, 02 December 2014 15:29
By: Kevin Meade
  SQL tuning
11g Enterprise Edition Release 11.2.0.3.0
By: rahul1982 on Fri, 28 November 2014
10 579 Sun, 30 November 2014 12:00
By: Kevin Meade
icon5.gif Change from LOGGING to NOLOGGING for a table
Oracle 11G R2
By: OlafCologne on Fri, 28 November 2014
1 200 Fri, 28 November 2014 08:20
By: John Watson
  Please help me to understand why the query works longer of server_A than on server_B
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: ecivgamer on Wed, 26 November 2014
10 708 Thu, 27 November 2014 06:22
By: ecivgamer
  A question about execution plan
Oracle 11.2.0.4. on Linux
By: orausern on Tue, 25 November 2014
2 361 Tue, 25 November 2014 12:52
By: orausern
  Index vs Full table scan on sysdate
11.2.0.3,Linux X86_64
By: preet_kumar on Wed, 12 November 2014
7 625 Tue, 25 November 2014 08:38
By: Andrey_R
  Decide on Partitioning Column/Purge Approach
Oracle 11g Release 2
By: azeem87 on Thu, 13 November 2014
9 589 Fri, 14 November 2014 08:33
By: cookiemonster
  Logging operation takes longer but no wait events
Oracle 11.2.0.4 EE, Linux 64 bit
By: d_seng on Mon, 01 September 2014
15 1186 Fri, 14 November 2014 05:54
By: d_seng
icon5.gif Cursor: Pin S Wait on X
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
By: ecivgamer on Thu, 13 November 2014
4 391 Fri, 14 November 2014 03:44
By: Michel Cadot
  PGA_AGREGATE_TARGET parameter
Oracle11g 11.2.0.3
By: shrinika on Mon, 10 November 2014
4 633 Tue, 11 November 2014 12:35
By: Michel Cadot
  Plan missing from cursor cache
Oracle 12.1 ,OEL 6
By: gkrishn on Sun, 09 November 2014
2 486 Sun, 09 November 2014 03:10
By: gkrishn
  Delete taking long due to index maintenance?
Oracle 11.2.0.3 / CentOS
By: ThomasG on Thu, 30 October 2014
14 1567 Wed, 05 November 2014 02:35
By: ThomasG
  Query in Loop causing performance issue
11i
By: nishantranjan00787 on Fri, 10 October 2014
12 1288 Mon, 03 November 2014 00:48
By: michael_bialik
  SQL tuning advisor being retarted
By: aliyesami on Mon, 22 September 2014
6 940 Thu, 23 October 2014 05:08
By: michael_bialik
  Table creation with nologging clause is stopped in between
10g, 10.2.0.4, hp unix
By: ashishkumarmahanta80 on Wed, 15 October 2014
7 496 Thu, 16 October 2014 04:09
By: gazzag
  Materialized view refresh thrashing DBWR
In post
By: Roachcoach on Tue, 23 September 2014
4 830 Wed, 15 October 2014 04:38
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: Wed Jan 28 18:46:06 CST 2015

Total time taken to generate the page: 5.94044 seconds