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

    Replies Views Last message
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 527 Fri, 26 April 2013 06:15
By: John Watson
  v$sql_plan.object_owner incorrect?
By: DKATyler on Thu, 25 April 2013
2 725 Thu, 25 April 2013 11:56
By: DKATyler
  checking the delete performance in the package
10.2.0.4
By: grpatwari on Fri, 12 April 2013
13 1028 Thu, 25 April 2013 03:31
By: grpatwari
icon5.gif alert.log question
Oracle DB 11, SLES 11
By: Shamall on Tue, 23 October 2012
3 957 Tue, 23 April 2013 03:25
By: Michel Cadot
  update xml eating up a lot of time
11.2.0.2
By: ayush_anand on Wed, 26 September 2012
4 1029 Tue, 23 April 2013 03:22
By: Michel Cadot
  Query Tuning -indexing
Oracle 10g/Solaris
By: prejib on Thu, 14 February 2013
8 1320 Tue, 23 April 2013 02:59
By: Michel Cadot
  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 2776 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 961 Mon, 22 April 2013 06:30
By: nlnkapardi
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
14 26918 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 658 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 663 Tue, 16 April 2013 09:13
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 425 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 519 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 1688 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 1209 Thu, 11 April 2013 10:55
By: sysdba007
  Regarding trace file &TKprof
By: ramanaapps on Wed, 10 April 2013
1 425 Wed, 10 April 2013 04:19
By: Michel Cadot
  Function takingg too long
Oracle Enterprise 11g
By: Tr0cken on Fri, 05 April 2013
5 573 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 1009 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 838 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 1049 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 2094 Wed, 03 April 2013 00:19
By: michael_bialik
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 742 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 1254 Tue, 02 April 2013 00:12
By: michael_bialik
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 1094 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 451 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 1268 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 687 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 1664 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 575 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 2470 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 960 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 663 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 1006 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 593 Tue, 05 March 2013 01:55
By: John Watson
  PARALLEL when I don't want it
By: scottwmackey on Fri, 01 March 2013
9 934 Mon, 04 March 2013 02:51
By: Michel Cadot
  problem with statspack
By: thorin666 on Tue, 11 September 2007
13 3926 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 1009 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 793 Fri, 01 March 2013 09:43
By: manubatham20
  performance tuning on SQL Queries
sql developer
By: Ganesh S on Tue, 26 February 2013
1 557 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 755 Sun, 24 February 2013 08:43
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: Thu Jul 31 05:07:31 CDT 2014

Total time taken to generate the page: 0.09269 seconds