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 deal with 'Free buffer waits' event
Oracle 11g R2 , Linux 64bit
By: kangfei on Sun, 13 March 2016
7 595 Mon, 14 March 2016 06:56
By: John Watson
  Query Optimization
Oracle SQL Devloper
By: Ranjeet29590 on Fri, 11 March 2016
4 726 Sun, 13 March 2016 11:15
By: garan
  Size of SYSAUX is getting bigger
Oracle 10g R2 10.2.0.4
By: snehalgandhi on Wed, 02 March 2016
9 614 Wed, 02 March 2016 03:17
By: Michel Cadot
  Select with Union Performance issue
Oracle 11g
By: emyk on Tue, 01 March 2016
3 523 Wed, 02 March 2016 02:59
By: cookiemonster
  Performance issue enq: TX index contention
Linux, Oracle 11g RAC
By: ninan on Tue, 23 February 2016
22 759 Tue, 23 February 2016 10:03
By: John Watson
  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 1040 Wed, 10 February 2016 00:30
By: Kevin Meade
  Oracle index creation
Oracle 10g
By: donep on Mon, 18 January 2016
13 9534 Wed, 10 February 2016 00:26
By: Kevin Meade
  Please help for Improving Query Performance
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 15 December 2015
31 1218 Wed, 03 February 2016 20:57
By: Kevin Meade
  Sql Query Tuning
11.2
By: mnraju999 on Mon, 11 January 2016
4 814 Wed, 03 February 2016 20:23
By: Kevin Meade
  Oracle ROWID RANGE SCAN
AIX 6
By: sinida1984 on Wed, 20 January 2016
9 1087 Wed, 03 February 2016 20:14
By: Kevin Meade
  Oracle SQL performance analysis
oracle 12c
By: gorants on Sun, 31 January 2016
2 590 Wed, 03 February 2016 20:04
By: Kevin Meade
  Tune query for Sum function
By: rohit_shinez on Wed, 03 February 2016
7 423 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 439 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 573 Sun, 24 January 2016 03:10
By: samiyabulushi
  Understanding oracle sql explain plan
12c
By: gorants on Mon, 18 January 2016
1 462 Mon, 18 January 2016 14:02
By: Michel Cadot
  Parallel Server for Dummies Checklist
By: WolfBrother on Wed, 06 January 2016
2 435 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 1106 Tue, 05 January 2016 23:36
By: garan
  Materialized View
Oracle 11g-Windows
By: arunOracle on Thu, 31 December 2015
4 653 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 683 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 935 Tue, 15 December 2015 04:12
By: Roachcoach
  PLAN_TABLE_OUTPUT
Oracle 11g
By: thiruvari on Thu, 10 December 2015
12 941 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 656 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 524 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 755 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 493 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 820 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 1854 Sun, 29 November 2015 05:56
By: orausern
  Execution plan cost
11.2.0.3
By: pointers on Wed, 25 November 2015
3 1673 Thu, 26 November 2015 00:25
By: pointers
  dbms_xplan
Oracle 11.2.0.3
By: pointers on Tue, 27 October 2015
3 747 Tue, 24 November 2015 05:54
By: pointers
  Locking modes
10g
By: m.abdulhaq on Fri, 23 October 2015
14 1213 Wed, 11 November 2015 10:35
By: cookiemonster
  SQL*Net roundtrips
Oracle 12c on LInux
By: gkrishn on Sat, 07 November 2015
9 617 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 388 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 554 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 578 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 1318 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 616 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 723 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 555 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 424 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 842 Mon, 05 October 2015 09:36
By: bpeasland
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: Tue Aug 30 16:07:46 CDT 2016

Total time taken to generate the page: 0.18219 seconds