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

    Replies Views Last message
  How long lock should be in order to take snapshot of locks
11.2.0.4, windows 2012 SE
By: juniordbanewbie on Tue, 24 January 2017
6 5221 Thu, 08 February 2018 02:49
By: juniordbanewbie
  Can we delete specific execution plan in the db buffer for a statement
12.1.0.2 DB Linux 64 Bit
By: juniordbanewbie on Mon, 28 August 2017
2 13659 Thu, 08 February 2018 02:36
By: juniordbanewbie
  Move unused partitioned from one tablespace to another tablespace.
Oracle 12c (12.1.0.1.0)- Unix
By: daulat01 on Thu, 04 January 2018
2 4143 Wed, 07 February 2018 03:23
By: daulat01
  View Performance Tuning
By: dancko on Tue, 30 January 2018
7 4518 Tue, 30 January 2018 10:34
By: cookiemonster
  Is there a equivalent of delete nologging operations
11.2.0.4 SE, Windows 2012 r2 Datacenter
By: juniordbanewbie on Tue, 19 September 2017
4 6099 Thu, 25 January 2018 18:13
By: juniordbanewbie
  Driving Table is not given more speed result
Oracle 11g
By: venkat_kayal on Thu, 18 January 2018
15 8288 Thu, 25 January 2018 03:46
By: venkat_kayal
  Non-value Added Indexes
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 02 January 2018
12 7612 Mon, 15 January 2018 08:15
By: msol25
  Consuming a more time (low performance)
Oracle8i Enterprise Edition Release 8.1.7.0.0, for 32-bit Windows
By: shawaj on Fri, 17 November 2017
3 5524 Fri, 15 December 2017 07:06
By: JohnMax
  Query taking 20 minutes in Production
ORACLE 11g
By: manoj12 on Fri, 17 November 2017
3 4797 Fri, 15 December 2017 03:26
By: cookiemonster
  AWR Interpretation and analysis
oracle 11gr2 on linux
By: dba4oracle on Tue, 05 December 2017
7 4757 Fri, 08 December 2017 02:04
By: trantuananh24hg
  DB Health checks
oracle 11gr2 on linux
By: dba4oracle on Tue, 05 December 2017
16 6305 Thu, 07 December 2017 05:43
By: dba4oracle
  Running out of 64gb Temp Space
12c
By: dbogey on Tue, 05 December 2017
2 3890 Tue, 05 December 2017 15:05
By: BlackSwan
  Session Trace file Location - Oracle 12c
oracle 12c Windows 2012
By: muthukrish104 on Mon, 04 December 2017
3 3508 Mon, 04 December 2017 03:24
By: muthukrish104
  Undo tablespace(monitoring and avoiding ORA-01555
oracle 11grw on linux
By: dba4oracle on Mon, 30 October 2017
8 5157 Sat, 11 November 2017 08:02
By: trantuananh24hg
  Performance Issue
Oracle8i Enterprise Edition Release 8.1.7.0.0,TNS for 32-bit Windows
By: shawaj on Thu, 09 November 2017
6 33283 Sat, 11 November 2017 00:59
By: shawaj
  Hints
Oracle 11g
By: sathishsr on Wed, 25 October 2017
3 115656 Wed, 25 October 2017 07:53
By: BlackSwan
  using sysdate from dual takes longer time
By: manikandan23 on Tue, 17 October 2017
10 98251 Wed, 18 October 2017 09:42
By: manikandan23
  Statspack snap shot at level 7 is slow
11.2.0.4. windows 2012 r2 Datacentre
By: juniordbanewbie on Wed, 04 October 2017
15 85138 Fri, 06 October 2017 15:08
By: John Watson
  How to partition unpartitioned existing table
12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: jokrasa on Wed, 20 September 2017
3 70025 Wed, 20 September 2017 15:23
By: BlackSwan
  Performace issue
By: Genesys on Tue, 29 August 2017
6 16901 Fri, 08 September 2017 04:12
By: Clanner
  sql need tuning - high cpu_time and buffer gets
oracle 12cR1 EE RAC, RHEL 6.5
By: gniewko on Wed, 23 August 2017
5 14635 Thu, 24 August 2017 09:34
By: Alien
  Join on index and adding default_where
Forms 11G
By: Ilonke on Tue, 15 August 2017
14 5521 Tue, 15 August 2017 06:47
By: cookiemonster
  Performance issue to Update data
Oracle 11g
By: newuser on Sat, 22 July 2017
7 3703 Mon, 24 July 2017 08:21
By: Bill B
  insert query
oracle 11g
By: POGAKU_SANTHOSH on Thu, 20 July 2017
4 3373 Fri, 21 July 2017 01:41
By: John Watson
  insert time is drastically reduced
Oracle 12.1.0.2 ,Windows server 2012 64bit
By: fabi88 on Mon, 03 July 2017
23 7639 Fri, 07 July 2017 22:53
By: BlackSwan
  Why my function based did not use?
Oracle 11gr2, any platform
By: trantuananh24hg on Wed, 05 July 2017
7 3279 Wed, 05 July 2017 20:37
By: trantuananh24hg
  SQL hint between view & table
11.2.0.4 on Solaris 10
By: kamragulshan on Wed, 28 June 2017
4 2913 Sat, 01 July 2017 14:29
By: kamragulshan
  create partitioning a table
Linux, oracle 11.2
By: kar116 on Wed, 21 June 2017
7 3426 Tue, 27 June 2017 23:11
By: trantuananh24hg
  Full table scan
Oracle 11g
By: samiran_cts on Tue, 19 July 2016
8 8510 Mon, 26 June 2017 04:44
By: samiran_cts
  While creating of M-View, lock the SYS.OBJ$ table
SunOS 5.8 - 9.2.0.5.0
By: hitesh.bhatt on Tue, 20 June 2017
11 3636 Wed, 21 June 2017 09:14
By: Michel Cadot
  Gathering Statistics of Partitioned table
Oracle 11g
By: saipradyumn on Thu, 15 June 2017
20 6677 Mon, 19 June 2017 05:22
By: saipradyumn
  query issue with execute immediate
11.2.0.4
By: grpatwari on Thu, 01 June 2017
8 6831 Sun, 11 June 2017 22:59
By: trantuananh24hg
  PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared
Oracle 11.2.0.4 / Solaris 11
By: SamuelJk on Thu, 01 June 2017
3 6165 Thu, 01 June 2017 18:54
By: BlackSwan
  Same query runs way better in 10g than in 12c
Oracle 10g, 12c
By: Asfakul on Thu, 18 May 2017
6 6909 Tue, 23 May 2017 14:35
By: LNossov
  cannot see a-rows while querying dbms_xplan.display_cursor
Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX
By: Andrey_R on Thu, 03 May 2012
17 14309 Sun, 14 May 2017 07:18
By: BlackSwan
  How to identify index type for partitioned tables
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Wed, 01 February 2017
16 6889 Mon, 24 April 2017 22:16
By: trantuananh24hg
  Number of values in Not in list
Oracle 11 g
By: saipradyumn on Tue, 14 March 2017
6 3104 Mon, 24 April 2017 01:20
By: saipradyumn
  Help Tuning slow query
Oracle 12c
By: James_s on Sat, 15 April 2017
6 5787 Tue, 18 April 2017 01:16
By: James_s
  Query became very slow
Oracle 11.2.0.3
By: lotusdeva on Wed, 08 February 2017
8 3695 Fri, 24 March 2017 02:54
By: Roachcoach
  IM Column Store ( indexes,lob data)
Oracle 12.1.0.2
By: chad_2000 on Sat, 18 February 2017
27 8588 Sat, 04 March 2017 02:33
By: LNossov
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 Mar 04 01:19:05 CST 2021