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

    Replies Views Last message
  delete is very slow
10.2.0.4
By: grpatwari on Fri, 26 April 2013
13 1782 Thu, 09 May 2013 16:53
By: alan.kendall@nfl.com
icon5.gif Query performance tuning for ETL
Oracle 11g
By: Pms_SARA07 on Wed, 08 May 2013
2 1007 Wed, 08 May 2013 14:59
By: Pms_SARA07
  Does partitioning need constraints to be copied
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: bhawnakaamra on Sat, 04 May 2013
10 3811 Tue, 07 May 2013 00:02
By: BlackSwan
  Performance for Table analysis
11.2.0.1
By: grpatwari on Fri, 03 May 2013
5 652 Fri, 03 May 2013 08:54
By: BlackSwan
  Ideas for fixing plan cardinality error
By: Kevin Meade on Tue, 30 April 2013
11 1490 Wed, 01 May 2013 10:51
By: Kevin Meade
  Oracle Tuning
Oracle 11g
By: orauser001 on Thu, 25 April 2013
7 1416 Tue, 30 April 2013 08:58
By: Kevin Meade
  Sql query running slowly
oracle 10g
By: anand.oracle on Sat, 27 April 2013
2 1061 Mon, 29 April 2013 22:45
By: Kevin Meade
  How to Improve query performance
By: panyamravi on Tue, 23 April 2013
5 1450 Sun, 28 April 2013 07:02
By: Kevin Meade
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 933 Fri, 26 April 2013 06:15
By: John Watson
  v$sql_plan.object_owner incorrect?
By: DKATyler on Thu, 25 April 2013
2 1223 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 1557 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 1417 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 1467 Tue, 23 April 2013 03:22
By: Michel Cadot
  Query Tuning -indexing
Oracle 10g/Solaris
By: prejib on Thu, 14 February 2013
8 1717 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 9934 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 1556 Mon, 22 April 2013 06:30
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 1004 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 1175 Tue, 16 April 2013 09:13
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 661 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 897 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 2593 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 2788 Thu, 11 April 2013 10:55
By: sysdba007
  Regarding trace file &TKprof
By: ramanaapps on Wed, 10 April 2013
1 681 Wed, 10 April 2013 04:19
By: Michel Cadot
  Function takingg too long
Oracle Enterprise 11g
By: Tr0cken on Fri, 05 April 2013
5 828 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 1634 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 1608 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 1322 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 2819 Wed, 03 April 2013 00:19
By: michael_bialik
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 1064 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 1685 Tue, 02 April 2013 00:12
By: michael_bialik
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 1683 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 717 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 2670 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 1014 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 3372 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 945 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 4384 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 1480 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 1225 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 1594 Tue, 12 March 2013 16:53
By: alan.kendall@nfl.com
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: Sat Jul 23 16:35:54 CDT 2016

Total time taken to generate the page: 0.04654 seconds