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

    Replies Views Last message
  Clarification on using awrrpti.sql script
Oracle 11.2.0.3.0 , Linux 5.7
By: Jack14 on Thu, 04 April 2013
5 1917 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 2008 Wed, 03 April 2013 17:11
By: BlackSwan
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 1172 Wed, 03 April 2013 00:12
By: michael_bialik
  How to find out session consuming high resource in the past?
Oracle 10.2.0.3.0 AIX
By: sysdba007 on Thu, 28 March 2013
8 3558 Thu, 11 April 2013 10:55
By: sysdba007
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 1925 Mon, 01 April 2013 05:02
By: VersatileAjay
  Tuning options while using RBO
Oracle 10.2.0.3.0 AIX
By: sysdba007 on Wed, 27 March 2013
11 2966 Thu, 11 April 2013 12:33
By: LNossov
  Why would you want to avoid and how do you limit oracle redo?
Oracle
By: steves on Sun, 24 March 2013
2 848 Sun, 24 March 2013 08:44
By: BlackSwan
  What is the most expensive dml transaction, insert, update, delete?
Oracle
By: steves on Sun, 24 March 2013
12 3162 Fri, 14 March 2014 17:49
By: youngryand
  How to reduce cost of query ...Give Indexing on FT Scan
Oracle 10g
By: swapnil_naik on Thu, 21 March 2013
4 3671 Fri, 22 March 2013 16:10
By: michael_bialik
  Full table scan. Indexes are available.
10.2.0.1, window7
By: ishika_20 on Wed, 20 March 2013
13 1865 Tue, 02 April 2013 00:12
By: michael_bialik
  select column list vs select *
Oracle 10.1.0.4
By: pointers on Wed, 20 March 2013
19 3091 Wed, 03 April 2013 00:19
By: michael_bialik
  Full table scan
10.2.0.1 , window 7
By: ishika_20 on Wed, 20 March 2013
3 1117 Wed, 20 March 2013 06:16
By: snowball
  SubQuery - Joins performance compare
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
By: isri on Tue, 19 March 2013
3 3897 Wed, 20 March 2013 02:56
By: isri
  Capacity Planning for 250 user OLTP shop
Oracle 11g on Linux
By: Andrey_R on Tue, 19 March 2013
2 1447 Wed, 03 April 2013 07:12
By: Andrey_R
  dbms_xplan for format model
10.1.0.4.0
By: pointers on Mon, 18 March 2013
3 1153 Mon, 18 March 2013 09:12
By: pointers
  execute to parse % - 50%
10.2.0.5.0, windows 7
By: ishika_20 on Tue, 12 March 2013
11 1703 Thu, 14 March 2013 06:21
By: ishika_20
  One job is hanging after SGA increase
ORACLE 10.2.0.3 HP UX 11.31
By: syed.samiullah on Mon, 11 March 2013
15 1844 Tue, 12 March 2013 16:53
By: alan.kendall@nfl.com
  Analyzing non-sequential snapshots in AWR
Oracle 11gR2
By: belf on Tue, 05 March 2013
9 1480 Tue, 12 March 2013 17:01
By: alan.kendall@nfl.com
  Execution Plan Changing with same SQL Profile
Oracle 10.2.0.3.0 on AIX
By: sysdba007 on Tue, 05 March 2013
6 5293 Sun, 17 March 2013 18:43
By: LNossov
  Hybrid Columnar Compression
ORACLE Exadata V2 and V3, 11.2.0.2 , Linux
By: pzlj6x on Mon, 04 March 2013
2 1012 Tue, 05 March 2013 01:55
By: John Watson
  Query Re-write for connect by
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: manubatham20 on Fri, 01 March 2013
0 1470 Fri, 01 March 2013 09:43
By: manubatham20
  Explain plan - cost(CPU%)
10g, 10.2.0.5, windows
By: ishika_20 on Tue, 26 February 2013
17 2072 Sat, 02 March 2013 04:05
By: ishika_20
  PARALLEL when I don't want it
By: scottwmackey on Fri, 01 March 2013
9 1652 Mon, 04 March 2013 02:51
By: Michel Cadot
  performance tuning on SQL Queries
sql developer
By: Ganesh S on Tue, 26 February 2013
1 933 Tue, 26 February 2013 03:57
By: Michel Cadot
  SQL ordered by Elapsed Time & SQL Module
10g & AIX 6.1
By: gatetec on Sun, 24 February 2013
5 1487 Sun, 24 February 2013 08:43
By: BlackSwan
  DELETE taking long time
10g r2
By: guddu_12 on Fri, 22 February 2013
2 1079 Fri, 22 February 2013 07:49
By: guddu_12
  Query Sql Server faster than Oracle
oracle 10g
By: ltubio on Thu, 21 February 2013
1 1138 Thu, 21 February 2013 03:09
By: Michel Cadot
icon14.gif Improve DDL operation performance (2 Merged)
oracle, 11.2.0.2, AIX6.1
By: soft_doctor on Thu, 14 February 2013
2 1177 Thu, 14 February 2013 09:46
By: cookiemonster
  Query Tuning -indexing
Oracle 10g/Solaris
By: prejib on Thu, 14 February 2013
8 2056 Tue, 23 April 2013 02:59
By: Michel Cadot
  Collection count high in Memory
11.2.0.3.0
By: rishwinger on Wed, 13 February 2013
4 892 Thu, 14 February 2013 01:16
By: Michel Cadot
  Loading and reading at the sametime
Oracle 10g and 11g both
By: babhuko on Wed, 13 February 2013
1 794 Wed, 13 February 2013 13:21
By: BlackSwan
  ADDM Report
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production on LINUX 32bit server
By: crussed_sonu on Thu, 07 February 2013
8 2107 Thu, 07 February 2013 03:55
By: Michel Cadot
  SQL ordered by Elapsed Time
10g
By: gatetec on Sat, 02 February 2013
9 15752 Mon, 04 February 2013 12:53
By: Michel Cadot
  Oracle Statistics
Oracle 11g2.0.3
By: Rumak18 on Tue, 29 January 2013
16 2646 Mon, 11 February 2013 07:15
By: John Watson
  what's mean of plh in SQL_TRACE?
11gr2
By: alantany on Thu, 24 January 2013
4 1862 Thu, 24 January 2013 21:41
By: alantany
  How can we verify the statistic info is not good
Oracle 10.2 , 11.2 , AIX, Linux
By: snowball on Wed, 23 January 2013
16 2724 Thu, 31 January 2013 05:14
By: snowball
  Please help me in rewriting the below query in optimized way
Oracle 11g
By: vikram1780 on Wed, 23 January 2013
29 2382 Thu, 21 February 2013 19:20
By: vikram1780
  LONG to CLOB conversion in huge tables
11g 11.2.0.3
By: gnmurthy86 on Fri, 25 January 2013
6 2034 Wed, 13 February 2013 16:59
By: xtender
  Physical Reads & Logical Reads
10g
By: gatetec on Fri, 18 January 2013
9 3940 Tue, 22 January 2013 17:57
By: alan.kendall@nfl.com
  does 11g not do a soft parse when we set cursor_cached_curosr?
11gr2
By: alantany on Tue, 15 January 2013
4 2268 Tue, 15 January 2013 09:29
By: alantany
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 Sep 19 06:49:38 CDT 2017

Total time taken to generate the page: 0.01423 seconds