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

    Replies Views Last message
  PLAN_TABLE_OUTPUT
Oracle 11g
By: P1Oracle on Thu, 10 December 2015
12 4549 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 3663 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 2665 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 4084 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 2371 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 3169 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 3331 Sun, 29 November 2015 05:56
By: orausern
  Execution plan cost
11.2.0.3
By: pointers on Wed, 25 November 2015
3 3340 Thu, 26 November 2015 00:25
By: pointers
  dbms_xplan
Oracle 11.2.0.3
By: pointers on Tue, 27 October 2015
3 2194 Tue, 24 November 2015 05:54
By: pointers
  Locking modes
10g
By: m.abdulhaq on Fri, 23 October 2015
14 4773 Wed, 11 November 2015 10:35
By: cookiemonster
  SQL*Net roundtrips
Oracle 12c on LInux
By: gkrishn on Sat, 07 November 2015
9 2730 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 1927 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 2284 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 2645 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 5432 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 2119 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 3387 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 2332 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 2122 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 3618 Mon, 05 October 2015 09:36
By: bpeasland
  Explain plan depends on Oracle client?
Oracle 11g
By: Buchas on Tue, 29 September 2015
4 2315 Tue, 29 September 2015 08:57
By: John Watson
  Tuning
linux
By: eml2raghu on Wed, 23 September 2015
11 4060 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 4903 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 4198 Wed, 16 September 2015 15:24
By: aft5425@anthem.com
  Performance improvement required
Oracle 10G
By: saurabh.sha on Wed, 18 March 2015
10 17359 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 2676 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 3279 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 3287 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 3214 Fri, 04 September 2015 13:07
By: orausern
  Oracle noforce view creates force view
By: ram50958 on Tue, 25 August 2015
8 4984 Tue, 25 August 2015 11:13
By: Michel Cadot
  Response time
12.1.0.1.0, solaris
By: kapilavastu on Tue, 21 July 2015
5 2998 Mon, 24 August 2015 21:02
By: Kevin Meade
  Interesting performance bottle neck issue
Oracle 11g
By: ram50958 on Wed, 19 August 2015
10 3850 Wed, 19 August 2015 10:09
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 6130 Fri, 14 August 2015 12:27
By: Kevin Meade
  statistics update
11.2.0.3 on Windows 2008 R2
By: sant_new1 on Thu, 13 August 2015
11 3649 Fri, 14 August 2015 12:07
By: BlackSwan
  query with hundreds of bind variables
Oracle database 11gR2 11.2.0.2.3
By: fplatel on Tue, 11 August 2015
2 2154 Tue, 11 August 2015 21:55
By: John Watson
  Help to tune the query
11.2.0
By: grpatwari on Mon, 03 August 2015
11 4912 Fri, 07 August 2015 08:56
By: Kevin Meade
  Cost Issue while using row_number()
By: AJAYRAM on Thu, 06 August 2015
11 3983 Fri, 07 August 2015 04:48
By: cookiemonster
  A way to identify the top sql other than AWR
11.2.0.4 on Linux
By: orausern on Tue, 04 August 2015
5 2574 Tue, 04 August 2015 11:46
By: orausern
  TKPROF output analysis
windows 2012, oracle 12c
By: muktha_22 on Wed, 22 July 2015
4 4712 Thu, 23 July 2015 01:39
By: Michel Cadot
  Tuning data deletion that is taking long time
11.2.0.4 on Linux
By: orausern on Sat, 11 July 2015
16 4594 Fri, 17 July 2015 05:59
By: orausern
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 May 25 13:22:56 CDT 2020