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

    Replies Views Last message
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
14 24609 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 593 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 607 Tue, 16 April 2013 09:13
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 396 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 471 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 1460 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 1013 Thu, 11 April 2013 10:55
By: sysdba007
  Regarding trace file &TKprof
By: ramanaapps on Wed, 10 April 2013
1 390 Wed, 10 April 2013 04:19
By: Michel Cadot
  Function takingg too long
Oracle Enterprise 11g
By: Tr0cken on Fri, 05 April 2013
5 532 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 892 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 747 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 1006 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 1931 Wed, 03 April 2013 00:19
By: michael_bialik
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 666 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 1179 Tue, 02 April 2013 00:12
By: michael_bialik
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 924 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 405 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 1086 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 645 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 1428 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 509 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 2175 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 880 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 619 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 891 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 557 Tue, 05 March 2013 01:55
By: John Watson
  PARALLEL when I don't want it
By: scottwmackey on Fri, 01 March 2013
9 864 Mon, 04 March 2013 02:51
By: Michel Cadot
  problem with statspack
By: thorin666 on Tue, 11 September 2007
13 3821 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 936 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 734 Fri, 01 March 2013 09:43
By: manubatham20
  performance tuning on SQL Queries
sql developer
By: Ganesh S on Tue, 26 February 2013
1 520 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 670 Sun, 24 February 2013 08:43
By: BlackSwan
  DELETE taking long time
10g r2
By: guddu_12 on Fri, 22 February 2013
2 522 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 1445 Thu, 21 February 2013 19:20
By: vikram1780
  Query Sql Server faster than Oracle
oracle 10g
By: ltubio on Thu, 21 February 2013
1 572 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 1301 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 546 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 462 Thu, 14 February 2013 01:16
By: Michel Cadot
  LONG to CLOB conversion in huge tables
11g 11.2.0.3
By: gnmurthy86 on Fri, 25 January 2013
6 1070 Wed, 13 February 2013 16:59
By: xtender
  Loading and reading at the sametime
Oracle 10g and 11g both
By: babhuko on Wed, 13 February 2013
1 297 Wed, 13 February 2013 13:21
By: BlackSwan
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: Mon Apr 21 06:00:04 CDT 2014

Total time taken to generate the page: 0.16441 seconds