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
Table Partioning Issue Oracle 11g By: VersatileAjay on Thu, 28 March 2013	9	3935	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	2341	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	8254	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	2534	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	5924	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	3009	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	8659	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	4003	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	3734	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	4467	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	2127	Tue, 05 March 2013 01:55 By: John Watson
PARALLEL when I don't want it By: scottwmackey on Fri, 01 March 2013	9	3570	Mon, 04 March 2013 02:51 By: Michel Cadot
problem with statspack By: thorin666 on Tue, 11 September 2007	13	9228	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	6280	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	2433	Fri, 01 March 2013 09:43 By: manubatham20
performance tuning on SQL Queries sql developer By: Ganesh S on Tue, 26 February 2013	1	1989	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	2997	Sun, 24 February 2013 08:43 By: BlackSwan
DELETE taking long time 10g r2 By: guddu_12 on Fri, 22 February 2013	2	2038	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	5060	Thu, 21 February 2013 19:20 By: vikram1780
Query Sql Server faster than Oracle oracle 10g By: ltubio on Thu, 21 February 2013	1	2080	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	4730	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	2500	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	2020	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	3917	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	2036	Wed, 13 February 2013 13:21 By: BlackSwan
Oracle Statistics Oracle 11g2.0.3 By: Rumak18 on Tue, 29 January 2013	16	5664	Mon, 11 February 2013 07:15 By: John Watson
Server Specification Capacity Building By: emorka on Thu, 10 January 2013	7	5410	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	4869	Thu, 07 February 2013 03:55 By: Michel Cadot
SQL ordered by Elapsed Time 10g By: gatetec on Sat, 02 February 2013	9	23289	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	5557	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	4236	Thu, 24 January 2013 21:41 By: alantany
Physical Reads & Logical Reads 10g By: gatetec on Fri, 18 January 2013	9	7841	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	3791	Tue, 15 January 2013 09:29 By: alantany
Tune a cursor By: cherryreddi on Mon, 14 January 2013	3	2263	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	1828	Fri, 11 January 2013 08:33 By: Michel Cadot
cpu utilizaton By: maninderkrb on Tue, 08 January 2013	6	2370	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	2386	Mon, 07 January 2013 16:12 By: LNossov
Need the Tuinng Tips for Tuning The package By: mvrkr44 on Mon, 07 January 2013	5	2040	Mon, 07 January 2013 01:55 By: Michel Cadot
Extended Statistics By: alantany on Thu, 03 January 2013	12	4233	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	7284	Fri, 04 January 2013 05:41 By: Michel Cadot