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

    Replies Views Last message
  Please help for Improving the Explain plan
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 08 December 2015
8 1305 Wed, 10 February 2016 00:30
By: Kevin Meade
  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 813 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 707 Mon, 07 December 2015 05:40
By: Michel Cadot
  Making Oracle generate and use different execution plans for any sql
11.2.0.4
By: orausern on Sat, 28 November 2015
2 2063 Sun, 29 November 2015 05:56
By: orausern
  Testing SPM
Oracle 11.2.0.4 on Linux
By: orausern on Fri, 27 November 2015
12 1067 Tue, 01 December 2015 09:18
By: orausern
  Execution plan cost
11.2.0.3
By: pointers on Wed, 25 November 2015
3 1898 Thu, 26 November 2015 00:25
By: pointers
  SQL*Net roundtrips
Oracle 12c on LInux
By: gkrishn on Sat, 07 November 2015
9 798 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 476 Tue, 03 November 2015 16:12
By: John Watson
  OPT_PARAM - WORK_AREA_POLICY
11.2.0.4
By: rasikeg@gmail.com on Tue, 03 November 2015
2 793 Tue, 01 December 2015 21:57
By: Kevin Meade
  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 1008 Tue, 01 December 2015 22:24
By: Kevin Meade
  Unexplained SQL Slowness (AWR Supplied)
Oracle 11.2.4.0, Linux
By: ganna76 on Wed, 28 October 2015
5 727 Wed, 28 October 2015 10:19
By: ganna76
  dbms_xplan
Oracle 11.2.0.3
By: pointers on Tue, 27 October 2015
3 903 Tue, 24 November 2015 05:54
By: pointers
  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 696 Mon, 02 November 2015 03:10
By: cookiemonster
  Locking modes
10g
By: m.abdulhaq on Fri, 23 October 2015
14 1510 Wed, 11 November 2015 10:35
By: cookiemonster
  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 796 Sun, 18 October 2015 03:16
By: Michel Cadot
  Facing performance issues in simple insert statement from Oracle 10g
10g
By: toitdoctor on Fri, 16 October 2015
3 743 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 581 Thu, 15 October 2015 03:28
By: ThomasG
  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 938 Sat, 17 October 2015 01:20
By: Kevin Meade
  Can we manually assign certain query transaction between RAC nodes ?
11g R2
By: carillpower on Tue, 29 September 2015
11 1142 Mon, 05 October 2015 09:36
By: bpeasland
  Explain plan depends on Oracle client?
Oracle 11g
By: Buchas on Tue, 29 September 2015
4 727 Tue, 29 September 2015 08:57
By: John Watson
  Tuning
linux
By: eml2raghu on Wed, 23 September 2015
11 1314 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 1217 Mon, 28 September 2015 06:43
By: Kevin Meade
  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 1720 Mon, 19 October 2015 05:53
By: John Watson
  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 797 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 1042 Wed, 09 September 2015 01:35
By: John Watson
  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 1287 Wed, 16 September 2015 15:24
By: aft5425@anthem.com
  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 878 Fri, 04 September 2015 13:07
By: orausern
  Oracle noforce view creates force view
By: ram50958 on Tue, 25 August 2015
8 1942 Tue, 25 August 2015 11:13
By: Michel Cadot
  Interesting performance bottle neck issue
Oracle 11g
By: ram50958 on Wed, 19 August 2015
10 1154 Wed, 19 August 2015 10:09
By: BlackSwan
  Insert from Select - Performance Issue
Oracle 11 g
By: ram50958 on Thu, 20 August 2015
8 1346 Tue, 05 January 2016 23:36
By: garan
  statistics update
11.2.0.3 on Windows 2008 R2
By: sant_new1 on Thu, 13 August 2015
11 1060 Fri, 14 August 2015 12:07
By: BlackSwan
  Please help for Resolving Issue for Explain plan as query taking long time for execution
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 09 August 2015
15 1612 Fri, 14 August 2015 12:27
By: Kevin Meade
  query with hundreds of bind variables
Oracle database 11gR2 11.2.0.2.3
By: fplatel on Tue, 11 August 2015
2 633 Tue, 11 August 2015 21:55
By: John Watson
  Cost Issue while using row_number()
By: AJAYRAM on Thu, 06 August 2015
11 1334 Fri, 07 August 2015 04:48
By: cookiemonster
  Help to tune the query
11.2.0
By: grpatwari on Mon, 03 August 2015
11 1859 Fri, 07 August 2015 08:56
By: Kevin Meade
  A way to identify the top sql other than AWR
11.2.0.4 on Linux
By: orausern on Tue, 04 August 2015
5 747 Tue, 04 August 2015 11:46
By: orausern
  TKPROF output analysis
windows 2012, oracle 12c
By: muktha_22 on Wed, 22 July 2015
4 1156 Thu, 23 July 2015 01:39
By: Michel Cadot
  Response time
12.1.0.1.0, solaris
By: kapilavastu on Tue, 21 July 2015
5 1103 Mon, 24 August 2015 21:02
By: Kevin Meade
  Help for tuning the sql Query
11.2.0.1
By: grpatwari on Wed, 15 July 2015
9 1279 Thu, 16 July 2015 03:22
By: cookiemonster
  Change in he execution plan
12c
By: jinga on Mon, 13 July 2015
8 1104 Wed, 15 July 2015 02:48
By: cookiemonster
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: Fri Oct 20 09:31:54 CDT 2017

Total time taken to generate the page: 0.02847 seconds