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

    Replies Views Last message
  query to data dictionary tables taking long time
11.2.0.4 on Linux
By: orausern on Tue, 24 February 2015
6 811 Tue, 24 February 2015 04:32
By: John Watson
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 1206 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 1104 Sat, 21 March 2015 04:05
By: billgate123
  Execution plan
oracle,11.2.0.2,RHEL
By: Prathikesh on Thu, 12 February 2015
4 967 Fri, 20 February 2015 16:31
By: Kevin Meade
  Index skip scan
11.2.0.4
By: Roachcoach on Thu, 02 April 2015
7 1425 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 1220 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 715 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 1696 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 2040 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 1421 Thu, 05 February 2015 03:13
By: Michel Cadot
  Explain plan
oracle 10g windows 7
By: hdba on Thu, 29 January 2015
10 1019 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 1686 Thu, 29 January 2015 01:31
By: John Watson
  Updating compressed rows
All with compression options
By: Roachcoach on Tue, 13 January 2015
0 2037 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 921 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 1563 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 1601 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 4056 Fri, 09 January 2015 00:34
By: Michel Cadot
  Performance Monitor looked ugly
11.2.04
By: bvo65 on Wed, 07 January 2015
5 2862 Mon, 09 March 2015 07:42
By: paolfili
  How To Check Performace Tuning
By: mastansky@gmail.com on Mon, 05 January 2015
8 3776 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 8693 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 3499 Fri, 02 January 2015 10:43
By: Michel Cadot
  Optimizing Dynamic SQL Usage
G12
By: FDAVIDOV on Mon, 29 December 2014
15 4081 Sat, 03 January 2015 10:30
By: FDAVIDOV
  Optimisation of query sql
ORacle 9i
By: achraf_ef on Thu, 25 December 2014
35 4214 Mon, 29 December 2014 19:24
By: EdStevens
  Monitor performance
By: Banurs on Mon, 22 December 2014
11 7042 Sun, 28 December 2014 21:34
By: Banurs
  Library cache (PIPES)
11g
By: mrinouk on Fri, 19 December 2014
0 4923 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 1860 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 3548 Thu, 18 December 2014 09:48
By: BlackSwan
  tuning basics
Oracle 10g
By: m.abdulhaq on Thu, 11 December 2014
3 1654 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 930 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 1472 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 545 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 1273 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 480 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 1366 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 770 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 2787 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 1518 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 1148 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 956 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 1034 Tue, 25 November 2014 08:38
By: Andrey_R
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: Tue Oct 17 08:28:56 CDT 2017

Total time taken to generate the page: 0.09371 seconds