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

    Replies Views Last message
  SQL*Net roundtrips
Oracle 12c on LInux
By: gkrishn on Sat, 07 November 2015
9 2261 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 1518 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 1881 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 2234 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 4777 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 1738 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 2934 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 1946 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 1704 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 3058 Mon, 05 October 2015 09:36
By: bpeasland
  Explain plan depends on Oracle client?
Oracle 11g
By: Buchas on Tue, 29 September 2015
4 1898 Tue, 29 September 2015 08:57
By: John Watson
  Tuning
linux
By: eml2raghu on Wed, 23 September 2015
11 3505 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 4400 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 3605 Wed, 16 September 2015 15:24
By: aft5425@anthem.com
  Performance improvement required
Oracle 10G
By: saurabh.sha on Wed, 18 March 2015
10 16855 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 2192 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 2740 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 2778 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 2616 Fri, 04 September 2015 13:07
By: orausern
  Oracle noforce view creates force view
By: ram50958 on Tue, 25 August 2015
8 4419 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 2554 Mon, 24 August 2015 21:02
By: Kevin Meade
  Interesting performance bottle neck issue
Oracle 11g
By: ram50958 on Wed, 19 August 2015
10 3251 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 5577 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 3203 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 1765 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 4369 Fri, 07 August 2015 08:56
By: Kevin Meade
  Cost Issue while using row_number()
By: AJAYRAM on Thu, 06 August 2015
11 3357 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 2177 Tue, 04 August 2015 11:46
By: orausern
  TKPROF output analysis
windows 2012, oracle 12c
By: muktha_22 on Wed, 22 July 2015
4 3927 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 4064 Fri, 17 July 2015 05:59
By: orausern
  Drop Unused columns
12.1.0.2.0,Linux x86_64
By: preet_kumar on Thu, 16 July 2015
3 1681 Thu, 16 July 2015 09:28
By: bpeasland
  Help for tuning the sql Query
11.2.0.1
By: grpatwari on Wed, 15 July 2015
9 3018 Thu, 16 July 2015 03:22
By: cookiemonster
  Change in he execution plan
12c
By: jinga on Mon, 13 July 2015
8 2494 Wed, 15 July 2015 02:48
By: cookiemonster
  Query not have much cost on Explain Plan but very very slow
oracle 10g
By: toom2525 on Sun, 12 July 2015
4 2401 Mon, 13 July 2015 02:07
By: John Watson
  Please provide help for tuning the sql Query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 12 July 2015
1 1787 Sun, 12 July 2015 07:19
By: John Watson
  Histograms - good or bad? (split from http://www.orafaq.com/forum/mv/msg/197539/638244/#msg_638244)
By: Roachcoach on Fri, 03 July 2015
8 3534 Tue, 07 July 2015 04:22
By: John Watson
  Oracle does not use a conditional index
oracle 11g
By: iblazquez on Mon, 08 June 2015
7 4114 Mon, 06 July 2015 13:46
By: John Watson
  flashback
Oracle 11g
By: ashish.tiwari on Sat, 04 July 2015
8 3388 Mon, 06 July 2015 03:22
By: gazzag
  'Configuration' wait class in AWR report
12
By: karthik4u on Sun, 05 July 2015
4 6869 Sun, 05 July 2015 08:29
By: John Watson
  Oracle Optimizer cost (merged)
Oracle11g
By: shrinika on Tue, 30 June 2015
8 3509 Wed, 01 July 2015 10:16
By: Lalit Kumar B
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 18 23:53:48 CDT 2019