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 to partition unpartitioned existing table
12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: jokrasa on Wed, 20 September 2017
3 27347 Wed, 20 September 2017 15:23
By: BlackSwan
  Is there a equivalent of delete nologging operations
11.2.0.4 SE, Windows 2012 r2 Datacenter
By: juniordbanewbie on Tue, 19 September 2017
3 809 Tue, 19 September 2017 10:24
By: gazzag
  Why use Oracle In-Memory database from another perspective
Oracle In-Memory Database
By: RichardTo on Fri, 15 September 2017
1 15851 Sat, 16 September 2017 01:05
By: John Watson
  Is there a way to find out activities due to redo logs
11.2.0.4 Windows 2008 R2 Data Center
By: juniordbanewbie on Sun, 10 September 2017
1 27814 Sun, 10 September 2017 07:39
By: BlackSwan
  Performace issue
By: Genesys on Tue, 29 August 2017
6 6679 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 5415 Thu, 24 August 2017 09:34
By: Alien
  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
1 4713 Mon, 28 August 2017 02:09
By: Roachcoach
  Join on index and adding default_where
Forms 11G
By: Ilonke on Tue, 15 August 2017
14 507 Tue, 15 August 2017 06:47
By: cookiemonster
  Performance issue to Update data
Oracle 11g
By: newuser on Sat, 22 July 2017
7 437 Mon, 24 July 2017 08:21
By: Bill B
  insert query
oracle 11g
By: POGAKU_SANTHOSH on Thu, 20 July 2017
4 325 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 282 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 810 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 389 Sat, 01 July 2017 14:29
By: kamragulshan
  create partitioning a table
Linux, oracle 11.2
By: kar116 on Wed, 21 June 2017
7 417 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 421 Wed, 21 June 2017 09:14
By: Michel Cadot
  Gathering Statistics of Partitioned table
Oracle 11g
By: saipradyumn on Thu, 15 June 2017
20 1112 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 1080 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 508 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 544 Tue, 23 May 2017 14:35
By: LNossov
  Help Tuning slow query
Oracle 12c
By: James_s on Sat, 15 April 2017
7 636 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 609 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 439 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 1420 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 1026 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 890 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 1013 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 434 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 891 Mon, 23 January 2017 03:41
By: Roachcoach
  query Dead Slow
oRACLE EBS R12
By: annu-agi on Fri, 20 January 2017
9 767 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 714 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 1226 Tue, 24 January 2017 04:51
By: Michel Cadot
  slow while inserting
10g
By: arifmd1705 on Sun, 08 January 2017
4 682 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 792 Fri, 06 January 2017 07:47
By: BlackSwan
  Full table scan
Oracle 11g
By: samiran_cts on Tue, 19 July 2016
8 1430 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 4329 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 4535 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 1012 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 763 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 1566 Tue, 20 December 2016 21:19
By: John Watson
  stale stats
Oracle 12c
By: srinivas.k2005 on Wed, 07 December 2016
18 1524 Tue, 13 December 2016 03:44
By: srinivas.k2005
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: Sat Sep 23 15:11:08 CDT 2017

Total time taken to generate the page: 0.01298 seconds