OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
db cache advice 10g Oracle 10g, AIX By: TRaj on Thu, 16 May 2013	2	2761	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	10565	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	4110	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	7974	Sat, 11 May 2013 14:39 By: piotrtal
delete is very slow 10.2.0.4 By: grpatwari on Fri, 26 April 2013	13	8081	Thu, 09 May 2013 16:53 By: alan.kendall@nfl.com
Query performance tuning for ETL Oracle 11g By: Pms_SARA07 on Wed, 08 May 2013	2	3028	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	8692	Tue, 07 May 2013 00:02 By: BlackSwan
Performance for Table analysis 11.2.0.1 By: grpatwari on Fri, 03 May 2013	5	2512	Fri, 03 May 2013 08:54 By: BlackSwan
Ideas for fixing plan cardinality error By: Kevin Meade on Tue, 30 April 2013	11	4535	Wed, 01 May 2013 10:51 By: Kevin Meade
Oracle Tuning Oracle 11g By: orauser001 on Thu, 25 April 2013	7	3636	Tue, 30 April 2013 08:58 By: Kevin Meade
Sql query running slowly oracle 10g By: anand.oracle on Sat, 27 April 2013	2	2845	Mon, 29 April 2013 22:45 By: Kevin Meade
How to Improve query performance By: panyamravi on Tue, 23 April 2013	5	3516	Sun, 28 April 2013 07:02 By: Kevin Meade
Bind variable issue Oracle 9i By: savugar on Fri, 26 April 2013	7	3019	Fri, 26 April 2013 06:15 By: John Watson
v$sql_plan.object_owner incorrect? By: DKATyler on Thu, 25 April 2013	2	3161	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	5236	Thu, 25 April 2013 03:31 By: grpatwari
alert.log question Oracle DB 11, SLES 11 By: Shamall on Tue, 23 October 2012	3	3248	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	3178	Tue, 23 April 2013 03:22 By: Michel Cadot
Query Tuning -indexing Oracle 10g/Solaris By: prejib on Thu, 14 February 2013	8	4603	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	26023	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	4172	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	3086	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	4255	Tue, 16 April 2013 09:13 By: cookiemonster
Application services production server By: lovelyjo on Mon, 15 April 2013	2	2589	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	3379	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	5401	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	6503	Thu, 11 April 2013 10:55 By: sysdba007
Regarding trace file &TKprof By: ramanaapps on Wed, 10 April 2013	1	2142	Wed, 10 April 2013 04:19 By: Michel Cadot
Function takingg too long Oracle Enterprise 11g By: Tr0cken on Fri, 05 April 2013	5	2546	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	3820	Fri, 05 April 2013 09:45 By: Michel Cadot
_library_cache_advice Oracle 10g By: gatetec on Wed, 03 April 2013	1	3683	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	2683	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	5175	Wed, 03 April 2013 00:19 By: michael_bialik
How to create index Oracle 11g , Solaris By: SSharma on Sat, 30 March 2013	3	2536	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	3508	Tue, 02 April 2013 00:12 By: michael_bialik
Table Partioning Issue Oracle 11g By: VersatileAjay on Thu, 28 March 2013	9	3725	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	2197	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	7813	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	2352	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	5757	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	2877	Mon, 18 March 2013 09:12 By: pointers