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

    Replies Views Last message
  Need help in performance tunning for querying table
oracle 10g
By: supiash on Sun, 19 May 2013
4 2852 Sun, 19 May 2013 08:39
By: Michel Cadot
  enable row movement - ok, but why internally this thing is needed
11.2.0.3.0
By: piotrtal on Fri, 17 May 2013
4 6239 Fri, 17 May 2013 14:43
By: Flyby
  commit_write in 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
3 3553 Fri, 17 May 2013 00:51
By: Michel Cadot
  db cache advice 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
2 2916 Thu, 16 May 2013 17:55
By: TRaj
  Oracle generates different execution plans for test and prod environments
Oracle Database 11g
By: httr on Wed, 08 May 2013
11 10726 Wed, 15 May 2013 14:07
By: pointers
  Is there any way to have the DB articulate why PDML is blocked
11.2.0.3
By: Roachcoach on Fri, 10 May 2013
10 4296 Wed, 15 May 2013 06:17
By: Roachcoach
  why this query is utilizing my undo so rapidly?
By: piotrtal on Sat, 11 May 2013
9 8223 Sat, 11 May 2013 14:39
By: piotrtal
  delete is very slow
10.2.0.4
By: grpatwari on Fri, 26 April 2013
13 8471 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 3183 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 8851 Tue, 07 May 2013 00:02
By: BlackSwan
  Performance for Table analysis
11.2.0.1
By: grpatwari on Fri, 03 May 2013
5 2628 Fri, 03 May 2013 08:54
By: BlackSwan
  Ideas for fixing plan cardinality error
By: Kevin Meade on Tue, 30 April 2013
11 4683 Wed, 01 May 2013 10:51
By: Kevin Meade
  Oracle Tuning
Oracle 11g
By: orauser001 on Thu, 25 April 2013
7 3780 Tue, 30 April 2013 08:58
By: Kevin Meade
  Sql query running slowly
oracle 10g
By: anand.oracle on Sat, 27 April 2013
2 2974 Mon, 29 April 2013 22:45
By: Kevin Meade
  How to Improve query performance
By: panyamravi on Tue, 23 April 2013
5 3661 Sun, 28 April 2013 07:02
By: Kevin Meade
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 3235 Fri, 26 April 2013 06:15
By: John Watson
  v$sql_plan.object_owner incorrect?
By: DKATyler on Thu, 25 April 2013
2 3271 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 5485 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 3375 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 3348 Tue, 23 April 2013 03:22
By: Michel Cadot
  Query Tuning -indexing
Oracle 10g/Solaris
By: prejib on Thu, 14 February 2013
8 4794 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 26654 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 4398 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 3227 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 4428 Tue, 16 April 2013 09:13
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 2737 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 3574 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 5558 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 6695 Thu, 11 April 2013 10:55
By: sysdba007
  Regarding trace file &TKprof
By: ramanaapps on Wed, 10 April 2013
1 2269 Wed, 10 April 2013 04:19
By: Michel Cadot
  Function takingg too long
Oracle Enterprise 11g
By: Tr0cken on Fri, 05 April 2013
5 2828 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 3966 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 3796 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 2803 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 5490 Wed, 03 April 2013 00:19
By: michael_bialik
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 2649 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 3637 Tue, 02 April 2013 00:12
By: michael_bialik
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 3859 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 2300 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 8111 Fri, 22 March 2013 16:10
By: michael_bialik
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 Aug 04 11:18:30 CDT 2021