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

    Replies Views Last message
  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
6 5466 Thu, 29 January 2015 01:31
By: John Watson
  AWR - licensing question
By: piotrtal on Tue, 12 July 2011
28 21068 Mon, 19 January 2015 10:58
By: Kevin Meade
  Updating compressed rows
All with compression options
By: Roachcoach on Tue, 13 January 2015
0 4364 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 3271 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 4601 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 9117 Fri, 09 January 2015 00:34
By: Michel Cadot
  max and min function taking lot of time
oracle 10g
By: vivek_rol on Tue, 06 January 2015
4 5030 Wed, 07 January 2015 22:45
By: Kevin Meade
  How To Check Performace Tuning
By: mastansky@gmail.com on Mon, 05 January 2015
8 6483 Tue, 06 January 2015 09:39
By: Kevin Meade
  Optimizing Dynamic SQL Usage
G12
By: FDAVIDOV on Mon, 29 December 2014
15 9601 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 8596 Fri, 02 January 2015 10:43
By: Michel Cadot
  Optimisation of query sql
ORacle 9i
By: achraf_ef on Thu, 25 December 2014
35 10959 Mon, 29 December 2014 19:24
By: EdStevens
  Monitor performance
By: Banurs on Mon, 22 December 2014
11 11901 Sun, 28 December 2014 21:34
By: Banurs
  Library cache (PIPES)
11g
By: mrinouk on Fri, 19 December 2014
0 6894 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 3952 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 6124 Thu, 18 December 2014 09:48
By: BlackSwan
  tuning basics
Oracle 10g
By: m.abdulhaq on Thu, 11 December 2014
3 4523 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 3154 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 3549 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 2607 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 3608 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 11109 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 4778 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 2377 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 5011 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 2848 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 4081 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 4437 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 7572 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 5452 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 3758 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 3280 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 7601 Wed, 05 November 2014 02:35
By: ThomasG
  Query in Loop causing performance issue
11i
By: nishantranjan00787 on Fri, 10 October 2014
12 6812 Mon, 03 November 2014 00:48
By: michael_bialik
  SQL tuning advisor being retarted
By: aliyesami on Mon, 22 September 2014
6 4740 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 4261 Thu, 16 October 2014 04:09
By: gazzag
  Materialized view refresh thrashing DBWR
In post
By: Roachcoach on Tue, 23 September 2014
4 4356 Wed, 15 October 2014 04:38
By: Roachcoach
  Need to tune package.
Oracle 11.2.0.3.0
By: swap19 on Sat, 11 October 2014
18 7803 Mon, 13 October 2014 01:49
By: John Watson
  Default value of SEND_BUF_SIZE and RECV_BUF_SIZE for IBM Aix 7
Aix 7
By: morad_dba on Sun, 12 October 2014
1 5090 Sun, 12 October 2014 09:31
By: BlackSwan
  Query chooses bitmap index and runs slower
11.2.0.2/11.2.0.4 Enterprise, RHL
By: d_seng on Wed, 01 October 2014
27 13518 Fri, 10 October 2014 09:18
By: Kevin Meade
  improve performance for the query
Oracle 11g
By: sumanh on Wed, 08 October 2014
2 3287 Wed, 08 October 2014 02:12
By: flyboy
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 May 19 20:20:01 CDT 2022