RE: Which one is good in terms of performance

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Fri, 24 Dec 2004 08:41:19 -0000
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F6301C5D394@UKWMXM04>

No 1) is the latest utility supplied by Oracle and so would seem to be = the best one to start with.
However this is very easy to test yourself, just set autotrace on, run = all 3 commands on a schema with a variety of different sized tables (and then report on what you have found)

I think locking issues may come into play, especially with the Analyze = table command

John

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: Thursday, December 23, 2004 8:06 PM To: oracle-l_at_freelists.org
Subject: Which one is good in terms of performance

Hi,

1)
exec dbms_stats.gather_schema_stats(ownname =3D>'''||username|| ''',degree=3D>4,cascade =3D>TRUE,options=3D>''GATHER STALE''); 2)DBMS_UTILITY.ANALYZE_SCHEMA('USERNAME','COMPUTE'); 3)ANALYZE TABLE <TABLENAME> COMPUTE STATTISTICS FOR ALL INDEXES COLUMNS; Please suggest which is best in case of cost based optimizer in = Oracle9i.
thanks

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 24 2004 - 02:36:47 CST