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
Query Tuning -indexing Oracle 10g/Solaris By: prejib on Thu, 14 February 2013	8	5661	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	31073	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	5462	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	4048	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	5506	Tue, 16 April 2013 09:13 By: cookiemonster
Application services production server By: lovelyjo on Mon, 15 April 2013	2	3627	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	4656	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	6536	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	8019	Thu, 11 April 2013 10:55 By: sysdba007
Regarding trace file &TKprof By: ramanaapps on Wed, 10 April 2013	1	3001	Wed, 10 April 2013 04:19 By: Michel Cadot
Function takingg too long Oracle Enterprise 11g By: Tr0cken on Fri, 05 April 2013	5	3524	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	4861	Fri, 05 April 2013 09:45 By: Michel Cadot
_library_cache_advice Oracle 10g By: gatetec on Wed, 03 April 2013	1	4695	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	3639	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	6363	Wed, 03 April 2013 00:19 By: michael_bialik
How to create index Oracle 11g , Solaris By: SSharma on Sat, 30 March 2013	3	3440	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	4539	Tue, 02 April 2013 00:12 By: michael_bialik
Table Partioning Issue Oracle 11g By: VersatileAjay on Thu, 28 March 2013	9	5107	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	3165	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	9735	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	3310	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	6593	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	3692	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	9978	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	4780	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	4520	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	5133	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	2761	Tue, 05 March 2013 01:55 By: John Watson
PARALLEL when I don't want it By: scottwmackey on Fri, 01 March 2013	9	4318	Mon, 04 March 2013 02:51 By: Michel Cadot
problem with statspack By: thorin666 on Tue, 11 September 2007	13	10194	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	7087	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	3367	Fri, 01 March 2013 09:43 By: manubatham20
performance tuning on SQL Queries sql developer By: Ganesh S on Tue, 26 February 2013	1	2643	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	3660	Sun, 24 February 2013 08:43 By: BlackSwan
DELETE taking long time 10g r2 By: guddu_12 on Fri, 22 February 2013	2	2666	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	5950	Thu, 21 February 2013 19:20 By: vikram1780
Query Sql Server faster than Oracle oracle 10g By: ltubio on Thu, 21 February 2013	1	2714	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	5568	Mon, 18 February 2013 03:18 By: TuneMyQuery
Improve DDL operation performance (2 Merged) oracle, 11.2.0.2, AIX6.1 By: soft_doctor on Thu, 14 February 2013	2	3252	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	2657	Thu, 14 February 2013 01:16 By: Michel Cadot