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
Index overhead Oracle, 9.2x, Unix By: balajisundar on Thu, 08 November 2007	2	2678	Thu, 08 November 2007 11:40 By: DreamzZ
How to improve a group by sql stmt (merged) By: dasgupta.amitava@gmail on Wed, 07 November 2007	4	4151	Thu, 08 November 2007 09:26 By: S.Rajaram
INDEX CREATION oracle 9.2x , UNIX By: balajisundar on Tue, 06 November 2007	3	2550	Wed, 07 November 2007 03:29 By: balajisundar
Slow performance Oracle 10.2.0.2, Solaris 5.8 By: kamragulshan on Wed, 07 November 2007	1	2349	Wed, 07 November 2007 02:49 By: Michel Cadot
IN Sub-query select performing poorly Oracle DB 10.2.0.2 RHEL4 By: TLegend33 on Tue, 06 November 2007	6	2419	Tue, 06 November 2007 13:33 By: TLegend33
Performance Bottleneck!!! Oracle 10.2.0.1.0, HP-UX v1 By: Muhammad Ahmad on Tue, 06 November 2007	1	1841	Tue, 06 November 2007 07:13 By: Michel Cadot
sql slow By: mwansalovewell on Tue, 06 November 2007	5	2748	Tue, 06 November 2007 04:07 By: mwansalovewell
Help Please By: balajisundar on Mon, 05 November 2007	5	2536	Mon, 05 November 2007 15:46 By: BlackSwan
Help needed in querying View By: seventhstar on Sun, 04 November 2007	2	2574	Sun, 04 November 2007 16:33 By: BlackSwan
Different Query Plan and execution time of same Query ORACLE 10g By: junaidsystems on Fri, 02 November 2007	2	3069	Fri, 02 November 2007 06:46 By: rleishman
Anti-Join (HASH_AJ) with multiple columns in the "NOT IN" clause By: hellcat on Wed, 31 October 2007	4	8039	Thu, 01 November 2007 21:58 By: rleishman
reading AWR report oracle 10g windown 2003 server By: skumar.dba on Thu, 01 November 2007	0	10456	Thu, 01 November 2007 12:25 By: skumar.dba
find out query is taking full table scan or index scan By: skumar.dba on Mon, 29 October 2007	2	2577	Thu, 01 November 2007 09:05 By: Mohammad Taj
performance problem By: Nokia on Wed, 24 October 2007	13	5005	Wed, 31 October 2007 17:23 By: Nokia
Parallel Query yields High Consistent Gets vs Serial Oracle RDBMS 9.2.7 By: mdoakes42 on Tue, 30 October 2007	1	1993	Tue, 30 October 2007 17:48 By: BlackSwan
statspack report oracle 10g windows 2003 server By: skumar.dba on Tue, 30 October 2007	1	1810	Tue, 30 October 2007 15:16 By: Michel Cadot
export statistics form production to test database oracle 10g, solaris 9 , redhat linux AS4 By: skumar.dba on Mon, 29 October 2007	11	7080	Tue, 30 October 2007 00:08 By: Michel Cadot
Fragmented Tables By: rubhatta on Mon, 29 October 2007	2	3608	Mon, 29 October 2007 20:50 By: rleishman
difference between locking and disabling statistics oracle10g By: oradba16 on Mon, 29 October 2007	1	1685	Mon, 29 October 2007 14:47 By: Michel Cadot
How to place many datafile on large tablespace? 9.2i, OS AIX By: sailor_man on Fri, 26 October 2007	3	2080	Mon, 29 October 2007 03:21 By: Michel Cadot
hint: first_rows By: tanmoy1048 on Sun, 28 October 2007	13	4870	Sun, 28 October 2007 23:01 By: tanmoy1048
Speed Diffrence By: nirajksharmacpr on Thu, 25 October 2007	4	2226	Sat, 27 October 2007 12:29 By: michael_bialik
want to reduce the COST Oracle 11i , DB - 9.2.0 By: AshaAtrey on Thu, 25 October 2007	7	2485	Sat, 27 October 2007 05:07 By: michael_bialik
find the query/plsql block which is causing performance hurt oracle 10.2.0.2 solaris 10 By: skumar.dba on Thu, 25 October 2007	1	2001	Thu, 25 October 2007 11:48 By: Michel Cadot
Slow SQL with dedicated server? By: hristo on Thu, 25 October 2007	4	2401	Thu, 25 October 2007 04:52 By: Michel Cadot
materialized view By: send.shakthi on Thu, 25 October 2007	1	2031	Thu, 25 October 2007 02:03 By: Michel Cadot
How to creating index? for best performance How to creating index? for best performance By: alwinsanjaya on Wed, 17 October 2007	2	2265	Thu, 25 October 2007 01:22 By: send.shakthi
Join query gettin poor performance By: hb_venkatesh on Wed, 24 October 2007	2	2547	Wed, 24 October 2007 00:58 By: Michel Cadot
Cached Cursor By: preet_kumar on Tue, 23 October 2007	2	4348	Tue, 23 October 2007 11:13 By: Michel Cadot
Performance impact on Oracle websphere application, oracle 9 database By: oraclechick on Tue, 23 October 2007	3	2501	Tue, 23 October 2007 09:12 By: Michel Cadot
why ESTD_PHYSICAL_READS and ESTD_PHYSICAL_READ_TIME are not change in proportional in v$db_cache_a By: wqhhust on Sun, 21 October 2007	1	3894	Sun, 21 October 2007 10:09 By: Michel Cadot
Optimizing specific client query Optimizing specific client query By: mleduc on Thu, 18 October 2007	1	2134	Thu, 18 October 2007 10:16 By: BlackSwan
collect Plan By: Majaa on Thu, 18 October 2007	1	2236	Thu, 18 October 2007 08:16 By: Michel Cadot
DB Block Buffer value By: Creems on Thu, 18 October 2007	2	4329	Thu, 18 October 2007 02:59 By: Creems
Processes and Sessions By: dirish on Fri, 27 July 2007	25	6437	Thu, 18 October 2007 02:58 By: Michel Cadot
Interpretation of Alert Log Errors By: Creems on Thu, 18 October 2007	1	2372	Thu, 18 October 2007 02:37 By: Mohammad Taj
EXPLAIN PLAN CHANGE After migration plan getting changed. By: arunprasad_bh on Tue, 16 October 2007	21	6748	Wed, 17 October 2007 16:47 By: flyboy
Stats Gathering on Whole Schema By: faiz_hyd on Tue, 16 October 2007	4	3271	Wed, 17 October 2007 12:31 By: BlackSwan
Running queries parallely By: vkrmhj on Wed, 17 October 2007	1	2328	Wed, 17 October 2007 07:04 By: Michel Cadot
autotrace autotrace on By: ashishmcajec on Mon, 15 October 2007	6	2420	Wed, 17 October 2007 05:10 By: rikfair