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

    Replies Views Last message
  sql need tuning - high cpu_time and buffer gets
oracle 12cR1 EE RAC, RHEL 6.5
By: gniewko on Wed, 23 August 2017
1 51 Wed, 23 August 2017 17:56
By: BlackSwan
  Join on index and adding default_where
Forms 11G
By: Ilonke on Tue, 15 August 2017
14 432 Tue, 15 August 2017 06:47
By: cookiemonster
  Performance issue to Update data
Oracle 11g
By: newuser on Sat, 22 July 2017
7 371 Mon, 24 July 2017 08:21
By: Bill B
  insert query
oracle 11g
By: POGAKU_SANTHOSH on Thu, 20 July 2017
4 286 Fri, 21 July 2017 01:41
By: John Watson
  Why my function based did not use?
Oracle 11gr2, any platform
By: trantuananh24hg on Wed, 05 July 2017
7 233 Wed, 05 July 2017 20:37
By: trantuananh24hg
  insert time is drastically reduced
Oracle 12.1.0.2 ,Windows server 2012 64bit
By: fabi88 on Mon, 03 July 2017
23 726 Fri, 07 July 2017 22:53
By: BlackSwan
  SQL hint between view & table
11.2.0.4 on Solaris 10
By: kamragulshan on Wed, 28 June 2017
4 336 Sat, 01 July 2017 14:29
By: kamragulshan
  create partitioning a table
Linux, oracle 11.2
By: kar116 on Wed, 21 June 2017
7 367 Tue, 27 June 2017 23:11
By: trantuananh24hg
  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 382 Wed, 21 June 2017 09:14
By: Michel Cadot
  Gathering Statistics of Partitioned table
Oracle 11g
By: saipradyumn on Thu, 15 June 2017
20 1035 Mon, 19 June 2017 05:22
By: saipradyumn
  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 273 Thu, 01 June 2017 18:54
By: BlackSwan
  query issue with execute immediate
11.2.0.4
By: grpatwari on Thu, 01 June 2017
8 452 Sun, 11 June 2017 22:59
By: trantuananh24hg
  Same query runs way better in 10g than in 12c
Oracle 10g, 12c
By: Asfakul on Thu, 18 May 2017
6 483 Tue, 23 May 2017 14:35
By: LNossov
  Help Tuning slow query
Oracle 12c
By: James_s on Sat, 15 April 2017
7 573 Tue, 18 April 2017 01:17
By: James_s
  Number of values in Not in list
Oracle 11 g
By: saipradyumn on Tue, 14 March 2017
6 574 Mon, 24 April 2017 01:20
By: saipradyumn
  Performance issue in oracle 10g database
WINDOW SERVER 2008
By: NIJ1611 on Thu, 23 February 2017
4 405 Thu, 23 February 2017 08:26
By: cookiemonster
  IM Column Store ( indexes,lob data)
Oracle 12.1.0.2
By: chad_2000 on Sat, 18 February 2017
27 1342 Sat, 04 March 2017 02:33
By: LNossov
  Query is taking longer duration
Oracle 11g 11.2.0.1.0
By: manoj12 on Fri, 10 February 2017
19 794 Wed, 22 February 2017 16:03
By: mikek
  Query became very slow
Oracle 11.2.0.3
By: lotusdeva on Wed, 08 February 2017
8 831 Fri, 24 March 2017 02:54
By: Roachcoach
  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 961 Mon, 24 April 2017 22:16
By: trantuananh24hg
  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
5 406 Wed, 25 January 2017 02:24
By: John Watson
  Tuning update query - for more than 3 billion rows
By: kurki on Fri, 20 January 2017
12 839 Mon, 23 January 2017 03:41
By: Roachcoach
  query Dead Slow
oRACLE EBS R12
By: annu-agi on Fri, 20 January 2017
9 717 Fri, 20 January 2017 10:37
By: Michel Cadot
  Avoiding the -ve execute to parse for MV refresh(highest parse calls total than execution totals)
Oracle 11
By: saipradyumn on Wed, 18 January 2017
11 666 Thu, 19 January 2017 03:37
By: saipradyumn
  Identify index key entry by rowid
Oracle SE 11.2.0.4.0
By: michael_bialik on Tue, 17 January 2017
14 1169 Tue, 24 January 2017 04:51
By: Michel Cadot
  slow while inserting
10g
By: arifmd1705 on Sun, 08 January 2017
4 657 Mon, 09 January 2017 00:50
By: Michel Cadot
  db file sequential read causing Performance Issues
Oracle 12c
By: subbaiyan on Fri, 06 January 2017
11 723 Fri, 06 January 2017 07:47
By: BlackSwan
  Full table scan
Oracle 11g
By: samiran_cts on Tue, 19 July 2016
8 1361 Mon, 26 June 2017 04:44
By: samiran_cts
  SGA AND PGA TUNING
Oracle 11.2
By: arin.oradba on Thu, 05 January 2017
20 1156 Fri, 13 January 2017 01:57
By: arin.oradba
  Identifying the parsing of the query (merged by MC)
Oracle 11g
By: saipradyumn on Tue, 27 December 2016
13 835 Thu, 29 December 2016 06:36
By: Michel Cadot
  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 945 Mon, 27 February 2017 13:00
By: Caffeine+
  Union all tables with View and using the Index
Oracle 11g
By: preet_kumar on Fri, 23 December 2016
5 677 Tue, 03 January 2017 03:48
By: cookiemonster
  Which index to choose local or global for attached scenario
10.2.0.3 db and AIX OS
By: oratech10 on Mon, 19 December 2016
24 1314 Tue, 20 December 2016 21:19
By: John Watson
  stale stats
Oracle 12c
By: srinivas.k2005 on Wed, 07 December 2016
18 1071 Tue, 13 December 2016 03:44
By: srinivas.k2005
  Oracle Advance Queue consumes messages very slowly
Oracle 10g, HP-UX/ia64
By: panos9 on Wed, 07 December 2016
2 509 Wed, 07 December 2016 10:11
By: panos9
  query Dead Slow
11g, 11.2.0.3.0
By: annu-agi on Wed, 07 December 2016
2 482 Wed, 07 December 2016 09:06
By: John Watson
  ORA-01555 error during expdp
Oracle 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production, Windows Server 2008 R2
By: ashussain on Tue, 06 December 2016
4 705 Wed, 07 December 2016 06:44
By: Michel Cadot
  Materlized View
Oracle 11
By: meetmallela on Sat, 03 December 2016
5 1007 Mon, 05 December 2016 02:59
By: cookiemonster
  In-database archival
Oracle 12C
By: srinivas.k2005 on Thu, 01 December 2016
2 447 Thu, 01 December 2016 05:11
By: srinivas.k2005
  Query Tuning
Oracle 12c, Unix
By: pstanand on Sun, 27 November 2016
1 644 Mon, 28 November 2016 00:28
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: Wed Aug 23 18:20:11 CDT 2017

Total time taken to generate the page: 0.05021 seconds