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

    Replies Views Last message
  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 6031 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 8209 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 7549 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 5458 Fri, 15 December 2017 07:06
By: JohnMax
  Query taking 20 minutes in Production
ORACLE 11g
By: manoj12 on Fri, 17 November 2017
3 4750 Fri, 15 December 2017 03:26
By: cookiemonster
  AWR Interpretation and analysis
oracle 11gr2 on linux
By: dba4oracle on Tue, 05 December 2017
7 4698 Fri, 08 December 2017 02:04
By: trantuananh24hg
  DB Health checks
oracle 11gr2 on linux
By: dba4oracle on Tue, 05 December 2017
16 6244 Thu, 07 December 2017 05:43
By: dba4oracle
  Running out of 64gb Temp Space
12c
By: dbogey on Tue, 05 December 2017
2 3831 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 3449 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 5091 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 33227 Sat, 11 November 2017 00:59
By: shawaj
  Hints
Oracle 11g
By: sathishsr on Wed, 25 October 2017
3 115593 Wed, 25 October 2017 07:53
By: BlackSwan
  using sysdate from dual takes longer time
By: manikandan23 on Tue, 17 October 2017
10 98189 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 84928 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 69951 Wed, 20 September 2017 15:23
By: BlackSwan
  Performace issue
By: Genesys on Tue, 29 August 2017
6 16835 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 14581 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 5454 Tue, 15 August 2017 06:47
By: cookiemonster
  Performance issue to Update data
Oracle 11g
By: newuser on Sat, 22 July 2017
7 3649 Mon, 24 July 2017 08:21
By: Bill B
  insert query
oracle 11g
By: POGAKU_SANTHOSH on Thu, 20 July 2017
4 3321 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 7575 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 3225 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 2859 Sat, 01 July 2017 14:29
By: kamragulshan
  create partitioning a table
Linux, oracle 11.2
By: kar116 on Wed, 21 June 2017
7 3372 Tue, 27 June 2017 23:11
By: trantuananh24hg
  Full table scan
Oracle 11g
By: samiran_cts on Tue, 19 July 2016
8 7779 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 3568 Wed, 21 June 2017 09:14
By: Michel Cadot
  Gathering Statistics of Partitioned table
Oracle 11g
By: saipradyumn on Thu, 15 June 2017
20 6628 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 5631 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 5992 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 6328 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 13046 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 6807 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 3057 Mon, 24 April 2017 01:20
By: saipradyumn
  Help Tuning slow query
Oracle 12c
By: James_s on Sat, 15 April 2017
6 5661 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 3642 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 8527 Sat, 04 March 2017 02:33
By: LNossov
  Oracle 12c -Query CPU Cost is very high
Oracle 12c Release 1, Linux(Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)
By: anil_mk on Tue, 27 December 2016
5 5489 Mon, 27 February 2017 13:00
By: Caffeine+
  Performance issue in oracle 10g database
WINDOW SERVER 2008
By: NIJ1611 on Thu, 23 February 2017
4 2947 Thu, 23 February 2017 08:26
By: cookiemonster
  Query is taking longer duration
Oracle 11g 11.2.0.1.0
By: manoj12 on Fri, 10 February 2017
19 20945 Wed, 22 February 2017 16:03
By: mikek
  BULK INSERT PERFORMANCE ON PROD
Oracle 12c, RHEL 6
By: jesuisantony on Sat, 14 May 2016
7 4048 Mon, 30 January 2017 13:00
By: forums.sqltop
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 Jan 18 21:16:22 CST 2021