RE: Which one is good in terms of performance

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 23 Dec 2004 13:21:21 -0700

Well, if you were to read any docs, you would see that dbms_stats is the =
prefered method for gathering schema stats.  As afr as the options you =
have specified, you will need to read up to see if these fit, as you =
have provided no information on your hardware, database, etc.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From:   oracle-l-bounce@xxxxxxxxxxxxx on behalf of Seema Singh
Sent:   Thu 12/23/2004 1:05 PM
To:     oracle-l@xxxxxxxxxxxxx
Cc:=09
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


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




This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender  of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

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

Other related posts: