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

    Replies Views Last message
  Which is correct solution for ORA-01555 - Increase Undo size or Undo retention?
Oracle 10.2.0.3.0 on AIX
By: sysdba007 on Mon, 22 April 2013
13 3429 Mon, 22 April 2013 19:28
By: Kevin Meade
  Identify performance for a query manually i.e. without STATPACK, AWR, ADDM etc.
Oracle 10g Release 2
By: Manoj.Gupta.91 on Fri, 19 April 2013
12 1029 Mon, 22 April 2013 06:30
By: nlnkapardi
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
14 28487 Mon, 22 April 2013 06:05
By: nlnkapardi
  Performance degrade after 10.2.0.5 patch upgrade and downgrade
10.2.0.4
By: neetesh.jathan on Wed, 17 April 2013
5 699 Thu, 18 April 2013 10:39
By: cookiemonster
  Tune function
Windows 2003, Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: rahul1982 on Fri, 12 April 2013
11 709 Tue, 16 April 2013 09:13
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 447 Mon, 15 April 2013 09:31
By: Michel Cadot
  Avg time taken by an execution plan
Oracle 10 G
By: getamaze on Fri, 12 April 2013
7 545 Fri, 12 April 2013 15:55
By: getamaze
  Tuning options while using RBO
Oracle 10.2.0.3.0 AIX
By: sysdba007 on Wed, 27 March 2013
11 1779 Thu, 11 April 2013 12:33
By: LNossov
  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 1361 Thu, 11 April 2013 10:55
By: sysdba007
  Regarding trace file &TKprof
By: ramanaapps on Wed, 10 April 2013
1 447 Wed, 10 April 2013 04:19
By: Michel Cadot
  Function takingg too long
Oracle Enterprise 11g
By: Tr0cken on Fri, 05 April 2013
5 611 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 1101 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 914 Wed, 03 April 2013 17:11
By: BlackSwan
  Capacity Planning for 250 user OLTP shop
Oracle 11g on Linux
By: Andrey_R on Tue, 19 March 2013
2 1093 Wed, 03 April 2013 07:12
By: Andrey_R
  select column list vs select *
Oracle 10.1.0.4
By: pointers on Wed, 20 March 2013
19 2227 Wed, 03 April 2013 00:19
By: michael_bialik
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 781 Wed, 03 April 2013 00:12
By: michael_bialik
  Full table scan. Indexes are available.
10.2.0.1, window7
By: ishika_20 on Wed, 20 March 2013
13 1311 Tue, 02 April 2013 00:12
By: michael_bialik
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 1155 Mon, 01 April 2013 05:02
By: VersatileAjay
  Why would you want to avoid and how do you limit oracle redo?
Oracle
By: steves on Sun, 24 March 2013
2 482 Sun, 24 March 2013 08:44
By: BlackSwan
  How to reduce cost of query ...Give Indexing on FT Scan
Oracle 10g
By: swapnil_naik on Thu, 21 March 2013
4 1408 Fri, 22 March 2013 16:10
By: michael_bialik
  Full table scan
10.2.0.1 , window 7
By: ishika_20 on Wed, 20 March 2013
3 716 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 1906 Wed, 20 March 2013 02:56
By: isri
  dbms_xplan for format model
10.1.0.4.0
By: pointers on Mon, 18 March 2013
3 626 Mon, 18 March 2013 09:12
By: pointers
  Execution Plan Changing with same SQL Profile
Oracle 10.2.0.3.0 on AIX
By: sysdba007 on Tue, 05 March 2013
6 2720 Sun, 17 March 2013 18:43
By: LNossov
  execute to parse % - 50%
10.2.0.5.0, windows 7
By: ishika_20 on Tue, 12 March 2013
11 1012 Thu, 14 March 2013 06:21
By: ishika_20
  Analyzing non-sequential snapshots in AWR
Oracle 11gR2
By: belf on Tue, 05 March 2013
9 702 Tue, 12 March 2013 17:01
By: alan.kendall@nfl.com
  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 1085 Tue, 12 March 2013 16:53
By: alan.kendall@nfl.com
  Hybrid Columnar Compression
ORACLE Exadata V2 and V3, 11.2.0.2 , Linux
By: pzlj6x on Mon, 04 March 2013
2 627 Tue, 05 March 2013 01:55
By: John Watson
  PARALLEL when I don't want it
By: scottwmackey on Fri, 01 March 2013
9 985 Mon, 04 March 2013 02:51
By: Michel Cadot
  problem with statspack
By: thorin666 on Tue, 11 September 2007
13 4030 Sun, 03 March 2013 03:23
By: Michel Cadot
  Explain plan - cost(CPU%)
10g, 10.2.0.5, windows
By: ishika_20 on Tue, 26 February 2013
17 1074 Sat, 02 March 2013 04:05
By: ishika_20
  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 851 Fri, 01 March 2013 09:43
By: manubatham20
  performance tuning on SQL Queries
sql developer
By: Ganesh S on Tue, 26 February 2013
1 589 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 819 Sun, 24 February 2013 08:43
By: BlackSwan
  DELETE taking long time
10g r2
By: guddu_12 on Fri, 22 February 2013
2 617 Fri, 22 February 2013 07:49
By: guddu_12
  Please help me in rewriting the below query in optimized way
Oracle 11g
By: vikram1780 on Wed, 23 January 2013
29 1660 Thu, 21 February 2013 19:20
By: vikram1780
  Query Sql Server faster than Oracle
oracle 10g
By: ltubio on Thu, 21 February 2013
1 645 Thu, 21 February 2013 03:09
By: Michel Cadot
  Joins and in-line views
Oracle 11.2
By: lakshmis on Mon, 03 December 2012
8 1528 Mon, 18 February 2013 03:18
By: TuneMyQuery
icon14.gif Improve DDL operation performance (2 Merged)
oracle, 11.2.0.2, AIX6.1
By: soft_doctor on Thu, 14 February 2013
2 625 Thu, 14 February 2013 09:46
By: cookiemonster
  Collection count high in Memory
11.2.0.3.0
By: rishwinger on Wed, 13 February 2013
4 529 Thu, 14 February 2013 01:16
By: Michel Cadot
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: Thu Oct 23 01:17:45 CDT 2014

Total time taken to generate the page: 0.11254 seconds