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

    Replies Views Last message
  Oracle SQL performance analysis
oracle 12c
By: gorants on Sun, 31 January 2016
2 569 Wed, 03 February 2016 20:04
By: Kevin Meade
  Tune query for Sum function
By: rohit_shinez on Wed, 03 February 2016
7 401 Wed, 03 February 2016 19:48
By: Kevin Meade
  Wich index is used. Confusion in SQL-trace
Oracle 12.1.0.2.0
By: mats-larsson@iname.com on Mon, 25 January 2016
3 415 Mon, 25 January 2016 10:59
By: mats-larsson@iname.com
  Application slow down
Database 11.2.0.3.0
By: samiyabulushi on Sun, 24 January 2016
2 518 Sun, 24 January 2016 03:10
By: samiyabulushi
  Understanding oracle sql explain plan
12c
By: gorants on Mon, 18 January 2016
1 441 Mon, 18 January 2016 14:02
By: Michel Cadot
  Parallel Server for Dummies Checklist
By: WolfBrother on Wed, 06 January 2016
2 419 Thu, 07 January 2016 01:08
By: John Watson
  Insert from Select - Performance Issue
Oracle 11 g
By: ram50958 on Thu, 20 August 2015
8 1074 Tue, 05 January 2016 23:36
By: garan
  Materialized View
Oracle 11g-Windows
By: arunOracle on Thu, 31 December 2015
4 620 Fri, 01 January 2016 11:42
By: John Watson
  use_concat hint
DB12.1.0.2
By: John Watson on Wed, 23 December 2015
3 656 Thu, 24 December 2015 04:22
By: Alien
  Database slowness and high load due to IO Latencies?
Oracle 11.2.0.4 on Linux
By: orausern on Thu, 10 December 2015
9 911 Tue, 15 December 2015 04:12
By: Roachcoach
  PLAN_TABLE_OUTPUT
Oracle 11g
By: thiruvari on Thu, 10 December 2015
12 913 Thu, 10 December 2015 10:49
By: cookiemonster
  Export from table vs external table
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: mokarem on Mon, 07 December 2015
9 640 Tue, 08 December 2015 04:52
By: Michel Cadot
  MULTI TABLE INSERT USING BULK COLLECT
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: ramanaapps on Mon, 07 December 2015
8 507 Mon, 07 December 2015 05:40
By: Michel Cadot
  Please help for tuning .sql query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 03 November 2015
17 727 Tue, 01 December 2015 22:24
By: Kevin Meade
  OPT_PARAM - WORK_AREA_POLICY
11.2.0.4
By: rasikeg@gmail.com on Tue, 03 November 2015
2 463 Tue, 01 December 2015 21:57
By: Kevin Meade
  Testing SPM
Oracle 11.2.0.4 on Linux
By: orausern on Fri, 27 November 2015
12 796 Tue, 01 December 2015 09:18
By: orausern
  Making Oracle generate and use different execution plans for any sql
11.2.0.4
By: orausern on Sat, 28 November 2015
2 1816 Sun, 29 November 2015 05:56
By: orausern
  Execution plan cost
11.2.0.3
By: pointers on Wed, 25 November 2015
3 1652 Thu, 26 November 2015 00:25
By: pointers
  dbms_xplan
Oracle 11.2.0.3
By: pointers on Tue, 27 October 2015
3 719 Tue, 24 November 2015 05:54
By: pointers
  Locking modes
10g
By: m.abdulhaq on Fri, 23 October 2015
14 1177 Wed, 11 November 2015 10:35
By: cookiemonster
  SQL*Net roundtrips
Oracle 12c on LInux
By: gkrishn on Sat, 07 November 2015
9 587 Sun, 08 November 2015 01:41
By: gkrishn
  dynamic sampling precedence
Oracle DB 12.1.0.2
By: kal_youssef on Tue, 03 November 2015
2 378 Tue, 03 November 2015 16:12
By: John Watson
  Please help for tuning .sql query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 01 November 2015
2 539 Mon, 02 November 2015 03:10
By: cookiemonster
  Unexplained SQL Slowness (AWR Supplied)
Oracle 11.2.4.0, Linux
By: ganna76 on Wed, 28 October 2015
5 559 Wed, 28 October 2015 10:19
By: ganna76
  A SQL query with self join and analytical function is running slow
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: toitdoctor on Wed, 23 September 2015
14 1278 Mon, 19 October 2015 05:53
By: John Watson
  Memory issue with PGA and AMM (merged)
12.1.0.2.0,Oracle Linux 7,x86_64
By: preet_kumar on Wed, 14 October 2015
3 590 Sun, 18 October 2015 03:16
By: Michel Cadot
  Please help for Tuning sql Query.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 15 October 2015
13 701 Sat, 17 October 2015 01:20
By: Kevin Meade
  Facing performance issues in simple insert statement from Oracle 10g
10g
By: toitdoctor on Fri, 16 October 2015
3 528 Fri, 16 October 2015 14:56
By: Littlefoot
  Any good Way to get dNFS IOPS?
11.2.0.3 / CentOS 6
By: ThomasG on Thu, 15 October 2015
2 416 Thu, 15 October 2015 03:28
By: ThomasG
  Can we manually assign certain query transaction between RAC nodes ?
11g R2
By: carillpower on Tue, 29 September 2015
11 822 Mon, 05 October 2015 09:36
By: bpeasland
  Explain plan depends on Oracle client?
Oracle 11g
By: Buchas on Tue, 29 September 2015
4 502 Tue, 29 September 2015 08:57
By: John Watson
  Tuning
linux
By: eml2raghu on Wed, 23 September 2015
11 1019 Tue, 29 September 2015 08:50
By: BlackSwan
  Unable to interpret number of rows accessed during Full Table scan
Oracle Enterprise Edition 11.2.0.4.0 on Linux
By: orapratap on Wed, 23 September 2015
12 902 Mon, 28 September 2015 06:43
By: Kevin Meade
  Query does not error, but does not come back with a result set (as if it's in an endless loop)
Oracle 11G running on UNIX AIX 6.1 O/S
By: aft5425@anthem.com on Sun, 13 September 2015
20 931 Wed, 16 September 2015 15:24
By: aft5425@anthem.com
  Performance improvement required
Oracle 10G
By: saurabh.sha on Wed, 18 March 2015
10 13973 Fri, 11 September 2015 09:12
By: BlackSwan
  Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux
By: Michel Cadot on Tue, 08 September 2015
3 546 Wed, 09 September 2015 13:57
By: John Watson
  cost is more after releasing FTS on big table (partition table)
11g, 11.2.0.3, Window server
By: ashishkumarmahanta80 on Tue, 08 September 2015
11 710 Wed, 09 September 2015 01:35
By: John Watson
  Query in active session for more than 2 hours
11.2.0.4
By: varunvir on Mon, 08 June 2015
5 1029 Sun, 06 September 2015 10:14
By: Kevin Meade
  Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high times on USER_IO_WAIT_TIME
11.2.0.4 on Linux
By: orausern on Fri, 04 September 2015
6 635 Fri, 04 September 2015 13:07
By: orausern
  How to gather various statistics with respect to CDB and PDB in 12c?
12c
By: skmsamy on Tue, 25 August 2015
1 486 Tue, 25 August 2015 11:54
By: John Watson
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 Jul 23 22:05:18 CDT 2016

Total time taken to generate the page: 0.17466 seconds