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

    Replies Views Last message
  Tune function
Windows 2003, Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: rahul1982 on Fri, 12 April 2013
11 1939 Tue, 16 April 2013 09:13
By: cookiemonster
  Regarding trace file &TKprof
By: ramanaapps on Wed, 10 April 2013
1 836 Wed, 10 April 2013 04:19
By: Michel Cadot
  Function takingg too long
Oracle Enterprise 11g
By: Tr0cken on Fri, 05 April 2013
5 940 Mon, 08 April 2013 04:55
By: Michel Cadot
  Clarification on using awrrpti.sql script
Oracle 11.2.0.3.0 , Linux 5.7
By: Jack14 on Thu, 04 April 2013
5 1946 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 2044 Wed, 03 April 2013 17:11
By: BlackSwan
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 1187 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 3612 Thu, 11 April 2013 10:55
By: sysdba007
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 1955 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 3007 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 858 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 3604 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 3754 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 1910 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 3149 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 1129 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 3938 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 1457 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 1176 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 1742 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 1888 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 1516 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 5367 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 1026 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 1484 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 2139 Sat, 02 March 2013 04:05
By: ishika_20
  PARALLEL when I don't want it
By: scottwmackey on Fri, 01 March 2013
9 1685 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 943 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 1510 Sun, 24 February 2013 08:43
By: BlackSwan
  DELETE taking long time
10g r2
By: guddu_12 on Fri, 22 February 2013
2 1091 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 1149 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 1189 Thu, 14 February 2013 09:46
By: cookiemonster
  Query Tuning -indexing
Oracle 10g/Solaris
By: prejib on Thu, 14 February 2013
8 2097 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 908 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 810 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 2170 Thu, 07 February 2013 03:55
By: Michel Cadot
  SQL ordered by Elapsed Time
10g
By: gatetec on Sat, 02 February 2013
9 15924 Mon, 04 February 2013 12:53
By: Michel Cadot
  Oracle Statistics
Oracle 11g2.0.3
By: Rumak18 on Tue, 29 January 2013
16 2708 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 1903 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 2767 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 2456 Thu, 21 February 2013 19:20
By: vikram1780
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: Wed Oct 18 17:23:16 CDT 2017

Total time taken to generate the page: 0.20024 seconds