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
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	820	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	466	Tue, 05 March 2013 01:55 By: John Watson
PARALLEL when I don't want it By: scottwmackey on Fri, 01 March 2013	9	801	Mon, 04 March 2013 02:51 By: Michel Cadot
problem with statspack By: thorin666 on Tue, 11 September 2007	13	3689	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	857	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	658	Fri, 01 March 2013 09:43 By: manubatham20
performance tuning on SQL Queries sql developer By: Ganesh S on Tue, 26 February 2013	1	484	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	549	Sun, 24 February 2013 08:43 By: BlackSwan
DELETE taking long time 10g r2 By: guddu_12 on Fri, 22 February 2013	2	470	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	1369	Thu, 21 February 2013 19:20 By: vikram1780
Query Sql Server faster than Oracle oracle 10g By: ltubio on Thu, 21 February 2013	1	474	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	1064	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	495	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	425	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	972	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	249	Wed, 13 February 2013 13:21 By: BlackSwan
Oracle Statistics Oracle 11g2.0.3 By: Rumak18 on Tue, 29 January 2013	16	1482	Mon, 11 February 2013 07:15 By: John Watson
Server Specification Capacity Building By: emorka on Thu, 10 January 2013	7	2489	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	703	Thu, 07 February 2013 03:55 By: Michel Cadot
SQL ordered by Elapsed Time 10g By: gatetec on Sat, 02 February 2013	9	4177	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	1567	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	652	Thu, 24 January 2013 21:41 By: alantany
Physical Reads & Logical Reads 10g By: gatetec on Fri, 18 January 2013	9	1475	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	943	Tue, 15 January 2013 09:29 By: alantany
Tune a cursor By: cherryreddi on Mon, 14 January 2013	3	615	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	510	Fri, 11 January 2013 08:33 By: Michel Cadot
cpu utilizaton By: maninderkrb on Tue, 08 January 2013	6	622	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	577	Mon, 07 January 2013 16:12 By: LNossov
Need the Tuinng Tips for Tuning The package By: mvrkr44 on Mon, 07 January 2013	5	473	Mon, 07 January 2013 01:55 By: Michel Cadot
Extended Statistics By: alantany on Thu, 03 January 2013	12	791	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	800	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	897	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	1058	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	3024	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	582	Thu, 03 January 2013 07:03 By: John Watson
Sql Running Slowly 9i By: snehal123 on Mon, 31 December 2012	11	689	Wed, 02 January 2013 09:55 By: LNossov
Tuning the sql query 10.2.0.4 By: grpatwari on Wed, 05 December 2012	29	1948	Tue, 01 January 2013 23:31 By: grpatwari
indexing Oracle 10g By: arif_md2009 on Fri, 21 December 2012	5	713	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	2167	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	644	Mon, 24 December 2012 08:38 By: Michel Cadot