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
High System I/O Wait Class on AWR Oracle 10.2.0.4 EE 64-bit, Solaris 10 By: cklh2000 on Fri, 04 January 2013	10	9750	Thu, 30 May 2013 09:16 By: sysdba007
Extended Statistics By: alantany on Thu, 03 January 2013	12	1943	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	3194	Fri, 04 January 2013 05:41 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	2789	Thu, 03 January 2013 22:33 By: rishwinger
OCI client result cache 11.2.x By: John Watson on Wed, 02 January 2013	4	1684	Thu, 03 January 2013 07:03 By: John Watson
Memory_target and sga_target in oracle 11gR2 Linux, Oracle 11g, 11.2.0 By: suresh.wst on Sat, 29 December 2012	6	9481	Thu, 03 January 2013 19:32 By: alan.kendall@nfl.com
Sql Running Slowly 9i By: snehal123 on Mon, 31 December 2012	11	1421	Wed, 02 January 2013 09:55 By: LNossov
Help in tuning the query Oracle DB, 11.1.0.7.0, AIX 6 By: kiranpuli on Mon, 24 December 2012	6	1639	Mon, 24 December 2012 08:38 By: Michel Cadot
Sql query taking High CPU and execution time in oracle 11gR2 Oracle 11g R2 By: pappu123 on Mon, 24 December 2012	15	8735	Wed, 26 December 2012 23:49 By: BlackSwan
indexing Oracle 10g By: arif_md2009 on Fri, 21 December 2012	5	1202	Sat, 29 December 2012 03:26 By: arif_md2009
Adaptive cursor sharing Doubt!! Oracle 11g (11.2.0.3.0 ) - Linux By: rishwinger on Tue, 18 December 2012	10	2384	Wed, 19 December 2012 04:52 By: rishwinger
SQL Tuning...? Oracle 10G By: gblackiv on Thu, 13 December 2012	6	1210	Thu, 13 December 2012 10:41 By: cookiemonster
RBS usage and longops in toad By: nunnaravi@yahoo.com on Tue, 11 December 2012	1	3263	Tue, 11 December 2012 06:40 By: Michel Cadot
Please help me on tune this query Oracle 11g By: ajaykumarkona on Mon, 10 December 2012	8	1386	Wed, 12 December 2012 11:50 By: Kevin Meade
Please help me on tune this query Oracle 11g By: ajaykumarkona on Tue, 11 December 2012	27	2649	Wed, 30 October 2013 08:49 By: pablolee
what's operation can cause these wait event? By: lonion on Thu, 06 December 2012	2	1834	Wed, 19 December 2012 12:45 By: alan.kendall@nfl.com
Tuning the sql query 10.2.0.4 By: grpatwari on Wed, 05 December 2012	29	2975	Tue, 01 January 2013 23:31 By: grpatwari
Help in Oracle Query Optimization Oracle 10g By: sanand7984 on Tue, 04 December 2012	3	1263	Tue, 04 December 2012 17:01 By: Kevin Meade
Parallel Feature 11g R2 By: TRaj on Tue, 04 December 2012	1	955	Tue, 04 December 2012 09:50 By: BlackSwan
Please help me to tune this query Oracle 11g By: ajaykumarkona on Tue, 04 December 2012	2	1498	Wed, 05 December 2012 14:35 By: Flyby
Joins and in-line views Oracle 11.2 By: lakshmis on Mon, 03 December 2012	8	2907	Mon, 18 February 2013 03:18 By: TuneMyQuery
suggestion for increasing the buffer cache Oracle, 9.2.0.8, sunOS By: savugar on Fri, 30 November 2012	11	1957	Fri, 04 January 2013 00:59 By: Michel Cadot
Bloom filters 11.2.0.3 By: John Watson on Fri, 30 November 2012	0	2829	Fri, 30 November 2012 02:35 By: John Watson
need more memory for hash joins 9i / 10g / 11gR2 By: Kevin Meade on Wed, 28 November 2012	5	7746	Tue, 04 December 2012 21:03 By: Kevin Meade
Top 5 long running using DBA_* hist views Oracle 11g, Linux By: ram anand on Wed, 28 November 2012	1	732	Wed, 28 November 2012 07:40 By: Michel Cadot
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	1814	Mon, 17 December 2012 17:14 By: LNossov
Query rewrite - high temp utilization Oracle, 8.1.7.4.0, sunOS By: sathik on Tue, 27 November 2012	3	1749	Tue, 27 November 2012 05:16 By: Michel Cadot
How to capture the problem with some sql timeout Oracle 10.2.0.4, AIX 5.3 64bit By: snowball on Mon, 26 November 2012	4	887	Tue, 27 November 2012 01:11 By: pvsarat
Inner join query tuning 10.2.0.3, windows XP By: ishika_20 on Thu, 22 November 2012	7	1740	Sat, 24 November 2012 05:55 By: ishika_20
Oracle memory parameters Oracle 9.2.0.8, Solaris 9 By: milicab on Sun, 18 November 2012	2	1384	Wed, 21 November 2012 13:59 By: alan.kendall@nfl.com
Tune the materialized view 10.2.4.0 By: grpatwari on Thu, 15 November 2012	13	2682	Wed, 28 November 2012 03:22 By: grpatwari
Options for optimising SQL running against Wide tables 11g By: jasontilbury on Tue, 13 November 2012	9	1976	Mon, 19 November 2012 15:16 By: rleishman
Tuning SELECT-WHERE-BETWEEN Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 By: rop4 on Mon, 12 November 2012	4	1282	Tue, 13 November 2012 05:52 By: rleishman
dba_hist_sqlstat 11.2.0.3 \|\| Solaris By: Roachcoach on Mon, 12 November 2012	5	3534	Wed, 14 November 2012 20:16 By: alan.kendall@nfl.com
Alternate Query instead of querying the table twice Oracle 11G,R2 By: prashanth7582 on Sun, 11 November 2012	5	1518	Wed, 14 November 2012 08:29 By: Kevin Meade
how to examine the impact of a too long varchar2 field Oracle Database 10g R2 By: beingman on Tue, 06 November 2012	13	1848	Mon, 12 November 2012 12:56 By: Kevin Meade
Long running query Oracle 11.2 By: lakshmis on Tue, 06 November 2012	9	1815	Sun, 11 November 2012 23:50 By: lakshmis
TKprof generation for short duration 10.2.0.1, linux-4.5 By: ishika_20 on Mon, 05 November 2012	7	1513	Sat, 24 November 2012 05:58 By: ishika_20
DBMS_AUTO_SQLTUNE CentOS 6.2 64-bit, Oracle11gR2 11.2.0.3.0 By: debrucer2 on Mon, 05 November 2012	2	5707	Mon, 05 November 2012 23:54 By: Michel Cadot
Different SQL ID for same SQL/HASH_VALUE 10.2.0.3, Solaris 5.9 By: suddhasatwa_bhaumik on Fri, 02 November 2012	10	6926	Mon, 05 November 2012 11:40 By: LNossov