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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Oracle Statistics Oracle 11g2.0.3 By: Rumak18 on Tue, 29 January 2013	16	1597	Mon, 11 February 2013 07:15 By: John Watson
Server Specification Capacity Building By: emorka on Thu, 10 January 2013	7	2555	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	812	Thu, 07 February 2013 03:55 By: Michel Cadot
SQL ordered by Elapsed Time 10g By: gatetec on Sat, 02 February 2013	9	5668	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	1684	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	776	Thu, 24 January 2013 21:41 By: alantany
Physical Reads & Logical Reads 10g By: gatetec on Fri, 18 January 2013	9	1785	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	1067	Tue, 15 January 2013 09:29 By: alantany
Tune a cursor By: cherryreddi on Mon, 14 January 2013	3	671	Mon, 14 January 2013 14:46 By: xtender
AWR Baseline in RAC Oracle 10.2.0.3 on AIX By: sysdba007 on Fri, 11 January 2013	1	572	Fri, 11 January 2013 08:33 By: Michel Cadot
cpu utilizaton By: maninderkrb on Tue, 08 January 2013	6	668	Tue, 08 January 2013 08:41 By: BlackSwan
num_rows on user_indexes vs table_indexes 11.2 AIX 6.1 By: tom_watson on Mon, 07 January 2013	5	650	Mon, 07 January 2013 16:12 By: LNossov
Need the Tuinng Tips for Tuning The package By: mvrkr44 on Mon, 07 January 2013	5	503	Mon, 07 January 2013 01:55 By: Michel Cadot
Extended Statistics By: alantany on Thu, 03 January 2013	12	899	Fri, 04 January 2013 23:40 By: alantany
CURRENT_OBJ# -1 in v$active_session_history By: tom_watson on Thu, 03 January 2013	8	1062	Fri, 04 January 2013 05:41 By: Michel Cadot
suggestion for increasing the buffer cache Oracle, 9.2.0.8, sunOS By: savugar on Fri, 30 November 2012	11	976	Fri, 04 January 2013 00:59 By: Michel Cadot
SQL Plan Baseline Trouble!!! Oracle 11.2.0.3.0 & Oracle 10.2.0.1.0 By: rishwinger on Thu, 03 January 2013	9	1272	Thu, 03 January 2013 22:33 By: rishwinger
Memory_target and sga_target in oracle 11gR2 Linux, Oracle 11g, 11.2.0 By: suresh.wst on Sat, 29 December 2012	6	3880	Thu, 03 January 2013 19:32 By: alan.kendall@nfl.com
OCI client result cache 11.2.x By: John Watson on Wed, 02 January 2013	4	714	Thu, 03 January 2013 07:03 By: John Watson
Sql Running Slowly 9i By: snehal123 on Mon, 31 December 2012	11	745	Wed, 02 January 2013 09:55 By: LNossov
Tuning the sql query 10.2.0.4 By: grpatwari on Wed, 05 December 2012	29	2055	Tue, 01 January 2013 23:31 By: grpatwari
indexing Oracle 10g By: arif_md2009 on Fri, 21 December 2012	5	768	Sat, 29 December 2012 03:26 By: arif_md2009
Sql query taking High CPU and execution time in oracle 11gR2 Oracle 11g R2 By: pappu123 on Mon, 24 December 2012	15	2912	Wed, 26 December 2012 23:49 By: BlackSwan
Help in tuning the query Oracle DB, 11.1.0.7.0, AIX 6 By: kiranpuli on Mon, 24 December 2012	6	719	Mon, 24 December 2012 08:38 By: Michel Cadot
what's operation can cause these wait event? By: lonion on Thu, 06 December 2012	2	698	Wed, 19 December 2012 12:45 By: alan.kendall@nfl.com
Adaptive cursor sharing Doubt!! Oracle 11g (11.2.0.3.0 ) - Linux By: rishwinger on Tue, 18 December 2012	10	1064	Wed, 19 December 2012 04:52 By: rishwinger
How to run a query with an different plan_hash value then in GV$SQL_PLAN Oracle 10.2.0.4.0 RAC on Linux By: Andrey_R on Tue, 27 November 2012	2	997	Mon, 17 December 2012 17:14 By: LNossov
SQL Tuning...? Oracle 10G By: gblackiv on Thu, 13 December 2012	6	569	Thu, 13 December 2012 10:41 By: cookiemonster
Please help me on tune this query Oracle 11g By: ajaykumarkona on Mon, 10 December 2012	8	737	Wed, 12 December 2012 11:50 By: Kevin Meade
RBS usage and longops in toad By: nunnaravi@yahoo.com on Tue, 11 December 2012	1	983	Tue, 11 December 2012 06:40 By: Michel Cadot
Please help me to tune this query Oracle 11g By: ajaykumarkona on Tue, 04 December 2012	2	863	Wed, 05 December 2012 14:35 By: Flyby
need more memory for hash joins 9i / 10g / 11gR2 By: Kevin Meade on Wed, 28 November 2012	5	2428	Tue, 04 December 2012 21:03 By: Kevin Meade
Help in Oracle Query Optimization Oracle 10g By: sanand7984 on Tue, 04 December 2012	3	708	Tue, 04 December 2012 17:01 By: Kevin Meade
Parallel Feature 11g R2 By: TRaj on Tue, 04 December 2012	1	339	Tue, 04 December 2012 09:50 By: BlackSwan
Checkpoint not complete By: David King on Thu, 15 September 2005	6	20394	Sat, 01 December 2012 19:51 By: alliejane
Bloom filters 11.2.0.3 By: John Watson on Fri, 30 November 2012	0	1198	Fri, 30 November 2012 02:35 By: John Watson
Database Reorganisation Oracle 10g, IBM AIX 5.3 By: oradba123 on Sat, 15 October 2011	2	777	Fri, 30 November 2012 01:09 By: atcharao
Top 5 long running using DBA_* hist views Oracle 11g, Linux By: ram anand on Wed, 28 November 2012	1	367	Wed, 28 November 2012 07:40 By: Michel Cadot
Tune the materialized view 10.2.4.0 By: grpatwari on Thu, 15 November 2012	13	1580	Wed, 28 November 2012 03:22 By: grpatwari
Query rewrite - high temp utilization Oracle, 8.1.7.4.0, sunOS By: sathik on Tue, 27 November 2012	3	827	Tue, 27 November 2012 05:16 By: Michel Cadot