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
Clarification on using awrrpti.sql script Oracle 11.2.0.3.0 , Linux 5.7 By: Jack14 on Thu, 04 April 2013	5	4168	Fri, 05 April 2013 09:45 By: Michel Cadot
_library_cache_advice Oracle 10g By: gatetec on Wed, 03 April 2013	1	4039	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	2992	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	5684	Wed, 03 April 2013 00:19 By: michael_bialik
How to create index Oracle 11g , Solaris By: SSharma on Sat, 30 March 2013	3	2826	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	3846	Tue, 02 April 2013 00:12 By: michael_bialik
Table Partioning Issue Oracle 11g By: VersatileAjay on Thu, 28 March 2013	9	4231	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	2504	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	8690	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	2706	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	6085	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	3161	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	8987	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	4155	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	3937	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	4566	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	2250	Tue, 05 March 2013 01:55 By: John Watson
PARALLEL when I don't want it By: scottwmackey on Fri, 01 March 2013	9	3727	Mon, 04 March 2013 02:51 By: Michel Cadot
problem with statspack By: thorin666 on Tue, 11 September 2007	13	9421	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	6537	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	2637	Fri, 01 March 2013 09:43 By: manubatham20
performance tuning on SQL Queries sql developer By: Ganesh S on Tue, 26 February 2013	1	2101	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	3105	Sun, 24 February 2013 08:43 By: BlackSwan
DELETE taking long time 10g r2 By: guddu_12 on Fri, 22 February 2013	2	2138	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	5330	Thu, 21 February 2013 19:20 By: vikram1780
Query Sql Server faster than Oracle oracle 10g By: ltubio on Thu, 21 February 2013	1	2178	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	4898	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	2671	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	2111	Thu, 14 February 2013 01:16 By: Michel Cadot
LONG to CLOB conversion in huge tables 11g 11.2.0.3 By: gnmurthy86 on Fri, 25 January 2013	6	4026	Wed, 13 February 2013 16:59 By: xtender
Loading and reading at the sametime Oracle 10g and 11g both By: babhuko on Wed, 13 February 2013	1	2182	Wed, 13 February 2013 13:21 By: BlackSwan
Oracle Statistics Oracle 11g2.0.3 By: Rumak18 on Tue, 29 January 2013	16	6027	Mon, 11 February 2013 07:15 By: John Watson
Server Specification Capacity Building By: emorka on Thu, 10 January 2013	7	5529	Sat, 09 February 2013 10:31 By: vamsi kasina
ADDM Report Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production on LINUX 32bit server By: crussed_sonu on Thu, 07 February 2013	8	5223	Thu, 07 February 2013 03:55 By: Michel Cadot
SQL ordered by Elapsed Time 10g By: gatetec on Sat, 02 February 2013	9	24119	Mon, 04 February 2013 12:53 By: Michel Cadot
How can we verify the statistic info is not good Oracle 10.2 , 11.2 , AIX, Linux By: snowball on Wed, 23 January 2013	16	5751	Thu, 31 January 2013 05:14 By: snowball
what's mean of plh in SQL_TRACE? 11gr2 By: alantany on Thu, 24 January 2013	4	4434	Thu, 24 January 2013 21:41 By: alantany
Physical Reads & Logical Reads 10g By: gatetec on Fri, 18 January 2013	9	8042	Tue, 22 January 2013 17:57 By: alan.kendall@nfl.com
does 11g not do a soft parse when we set cursor_cached_curosr? 11gr2 By: alantany on Tue, 15 January 2013	4	4052	Tue, 15 January 2013 09:29 By: alantany
Tune a cursor By: cherryreddi on Mon, 14 January 2013	3	2370	Mon, 14 January 2013 14:46 By: xtender