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
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	2586	Mon, 17 December 2012 17:14 By: LNossov
SQL Tuning...? Oracle 10G By: gblackiv on Thu, 13 December 2012	6	2263	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	2670	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	4996	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	2150	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	10771	Tue, 04 December 2012 21:03 By: Kevin Meade
Help in Oracle Query Optimization Oracle 10g By: sanand7984 on Tue, 04 December 2012	3	1911	Tue, 04 December 2012 17:01 By: Kevin Meade
Parallel Feature 11g R2 By: TRaj on Tue, 04 December 2012	1	2251	Tue, 04 December 2012 09:50 By: BlackSwan
Checkpoint not complete By: David King on Thu, 15 September 2005	6	24145	Sat, 01 December 2012 19:51 By: alliejane
Bloom filters 11.2.0.3 By: John Watson on Fri, 30 November 2012	0	4186	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	1881	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	1209	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	3920	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	2404	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	1452	Tue, 27 November 2012 01:11 By: pvsarat
TKprof generation for short duration 10.2.0.1, linux-4.5 By: ishika_20 on Mon, 05 November 2012	7	2437	Sat, 24 November 2012 05:58 By: ishika_20
Inner join query tuning 10.2.0.3, windows XP By: ishika_20 on Thu, 22 November 2012	7	2704	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	2239	Wed, 21 November 2012 13:59 By: alan.kendall@nfl.com
Options for optimising SQL running against Wide tables 11g By: jasontilbury on Tue, 13 November 2012	9	3317	Mon, 19 November 2012 15:16 By: rleishman
dba_hist_sqlstat 11.2.0.3 \|\| Solaris By: Roachcoach on Mon, 12 November 2012	5	6241	Wed, 14 November 2012 20:16 By: alan.kendall@nfl.com
Slow Join between dba_tab_cols and dba_types By: ocdeveloper on Wed, 14 November 2012	1	2755	Wed, 14 November 2012 13:20 By: BlackSwan
Alternate Query instead of querying the table twice Oracle 11G,R2 By: prashanth7582 on Sun, 11 November 2012	5	2620	Wed, 14 November 2012 08:29 By: Kevin Meade
Tuning SELECT-WHERE-BETWEEN Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 By: rop4 on Mon, 12 November 2012	4	2347	Tue, 13 November 2012 05:52 By: rleishman
how to examine the impact of a too long varchar2 field Oracle Database 10g R2 By: beingman on Tue, 06 November 2012	13	3095	Mon, 12 November 2012 12:56 By: Kevin Meade
Long running query Oracle 11.2 By: lakshmis on Tue, 06 November 2012	9	2583	Sun, 11 November 2012 23:50 By: lakshmis
Table rebuild should be done after removing most of its data? Oracle 10.2.0.4 on Solaris 10 By: orausern on Tue, 23 October 2012	4	3701	Mon, 05 November 2012 17:47 By: alan.kendall@nfl.com
Performance degrades as dB size increases Oracle 11gr2 Server 2008r2 By: segan1415 on Thu, 01 November 2012	1	2675	Fri, 02 November 2012 03:52 By: John Watson
SQL execution plan different on different hardware Oracle 11gR2, AIX By: hjoshi on Wed, 31 October 2012	3	2184	Thu, 01 November 2012 02:36 By: John Watson
NESTED LOOPS JOIN and DISTRIBUTED OPERATIONS 9i/10g/11g By: Kevin Meade on Tue, 30 October 2012	5	2670	Wed, 31 October 2012 08:13 By: Kevin Meade
Merge Join Cartesian in Outline Data Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Wed, 31 October 2012	0	2392	Wed, 31 October 2012 06:47 By: manubatham20
[11g]Direct-path insert / temp usage / PGA Oracle 11gr2 / linux 2.6 x86_64 By: nikko on Tue, 30 October 2012	3	4190	Wed, 31 October 2012 04:19 By: nikko
How tune the following query? Oracle 9i By: kumar_hi21@yahoo.com on Tue, 23 October 2012	4	5421	Mon, 29 October 2012 23:05 By: Kevin Meade
How Oracle optimizer choose joins (hash, Merge & nested loop join) By: ukumarjsr2 on Thu, 18 October 2012	2	2847	Mon, 29 October 2012 22:56 By: Kevin Meade
Proper index is not used ... Oracle, 11.2.0.2, Linux 5.5 By: ardhendu on Wed, 17 October 2012	4	2305	Fri, 19 October 2012 05:07 By: ardhendu
incremental stats not happening ORACLE 11GR2 SOLARIS By: guddu_12 on Mon, 15 October 2012	3	1981	Thu, 18 October 2012 12:28 By: Littlefoot
NOLOGGING in Oracle 11gr2 Oracle 11gr2 Server 2008r2 By: segan1415 on Tue, 16 October 2012	26	21525	Thu, 18 October 2012 09:18 By: segan1415
Improve performance postgre By: perfectioi on Wed, 10 October 2012	4	2474	Wed, 10 October 2012 11:39 By: BlackSwan
SSL on database connections Oracle EE ver 11, linux By: ndg123 on Wed, 10 October 2012	4	1786	Wed, 10 October 2012 05:36 By: ndg123
cluter in index oracle 11gr2 By: guddu_12 on Thu, 04 October 2012	4	1629	Fri, 05 October 2012 17:19 By: rleishman
Is this a bug on Oracle11gr2? 11gr2 By: alantany on Tue, 25 September 2012	5	3130	Thu, 04 October 2012 15:20 By: Flyby