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

    Replies Views Last message
icon4.gif A oracle query causing 100% cpu utilization and blocking other sessions.
oracle 11g,(11.2.0.3), Sun Solaris
By: RamanaRocks on Sun, 22 February 2015
10 1169 Mon, 23 February 2015 04:00
By: John Watson
  Union (all) and outline hints
11.2.0.3
By: Roachcoach on Fri, 20 February 2015
3 1095 Sat, 21 March 2015 04:05
By: billgate123
  Execution plan
oracle,11.2.0.2,RHEL
By: Prathikesh on Thu, 12 February 2015
4 918 Fri, 20 February 2015 16:31
By: Kevin Meade
  Index skip scan
11.2.0.4
By: Roachcoach on Thu, 02 April 2015
7 1385 Mon, 06 April 2015 02:41
By: Roachcoach
  Why does monitoring index fix performance?
Oracle Database/Forms 11g, Windows 7
By: nait1234 on Sun, 15 February 2015
8 1185 Wed, 18 February 2015 15:04
By: Michel Cadot
  Alert log file size can impact database performance
10g, 10.2.0.1, window server 2008
By: ashishkumarmahanta80 on Tue, 10 February 2015
3 704 Tue, 10 February 2015 07:31
By: cookiemonster
  Updating text string to mask address characters
Oracle 11
By: brown_zzz on Thu, 05 February 2015
20 1645 Sun, 08 February 2015 23:42
By: FDAVIDOV
  update statement takes too long
11.2.0.1.0
By: OraFerro on Sun, 01 February 2015
16 1994 Sat, 07 February 2015 09:20
By: Kevin Meade
  what is ** TRANSIENT: 12029568
oracle db 11.2.0.3 on solaris
By: mshrkshl on Fri, 30 January 2015
2 1404 Thu, 05 February 2015 03:13
By: Michel Cadot
  Explain plan
oracle 10g windows 7
By: hdba on Thu, 29 January 2015
10 993 Thu, 29 January 2015 06:26
By: hdba
  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 1651 Thu, 29 January 2015 01:31
By: John Watson
  Updating compressed rows
All with compression options
By: Roachcoach on Tue, 13 January 2015
0 2024 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 902 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 1535 Sat, 10 January 2015 14:59
By: John Watson
  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 1582 Fri, 17 April 2015 20:38
By: juniordbanewbie
  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 4016 Fri, 09 January 2015 00:34
By: Michel Cadot
  Performance Monitor looked ugly
11.2.04
By: bvo65 on Wed, 07 January 2015
5 2842 Mon, 09 March 2015 07:42
By: paolfili
  How To Check Performace Tuning
By: mastansky@gmail.com on Mon, 05 January 2015
8 3751 Tue, 06 January 2015 09:39
By: Kevin Meade
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
14 8540 Sat, 07 February 2015 17:02
By: LNossov
  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 3397 Fri, 02 January 2015 10:43
By: Michel Cadot
  Optimizing Dynamic SQL Usage
G12
By: FDAVIDOV on Mon, 29 December 2014
15 4048 Sat, 03 January 2015 10:30
By: FDAVIDOV
  Optimisation of query sql
ORacle 9i
By: achraf_ef on Thu, 25 December 2014
35 4130 Mon, 29 December 2014 19:24
By: EdStevens
  Monitor performance
By: Banurs on Mon, 22 December 2014
11 7004 Sun, 28 December 2014 21:34
By: Banurs
  Library cache (PIPES)
11g
By: mrinouk on Fri, 19 December 2014
0 4917 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 1851 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 3536 Thu, 18 December 2014 09:48
By: BlackSwan
  tuning basics
Oracle 10g
By: m.abdulhaq on Thu, 11 December 2014
3 1619 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 915 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 1468 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 535 Thu, 04 December 2014 13:05
By: orausern
  SQL tuning
11g Enterprise Edition Release 11.2.0.3.0
By: rahul1982 on Fri, 28 November 2014
10 1243 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 473 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 1336 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 754 Tue, 25 November 2014 12:52
By: orausern
  AWR report
oracle 12c - Windows server 2012 ( 1 2)
By: muktha_22 on Tue, 18 November 2014
41 2690 Tue, 02 December 2014 15:29
By: Kevin Meade
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 1462 Fri, 14 November 2014 03:44
By: Michel Cadot
  Decide on Partitioning Column/Purge Approach
Oracle 11g Release 2
By: azeem87 on Thu, 13 November 2014
9 1115 Fri, 14 November 2014 08:33
By: cookiemonster
  INTERNAL_FUNCTION appears at explain plan
11g, 11.2.0.3, solaris10
By: ashishkumarmahanta80 on Thu, 13 November 2014
4 935 Wed, 03 December 2014 00:02
By: ashishkumarmahanta80
  Index vs Full table scan on sysdate
11.2.0.3,Linux X86_64
By: preet_kumar on Wed, 12 November 2014
7 1013 Tue, 25 November 2014 08:38
By: Andrey_R
  PGA_AGREGATE_TARGET parameter
Oracle11g 11.2.0.3
By: shrinika on Mon, 10 November 2014
4 1100 Tue, 11 November 2014 12:35
By: Michel Cadot
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: Mon Sep 25 13:34:46 CDT 2017

Total time taken to generate the page: 0.01477 seconds