I ran it in "debug" mode for a particular schema and the debug mode =
showed that it was going to analyze a partitioned table. If you analyze =
the table then all the partitions will be analyzed also.
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Koivu, Lisa
> Sent: mercredi, 28. janvier 2004 11:41
> To: oracle-l_at_freelists.org
> Subject: Analyze script written by Connor McDonald
>=20
>=20
> Has anyone used this analyze script, dbstat.sql, near the=20
> bottom of the
> page
> =20
>=20
> http://www.oaktable.net/userFiles.jsp;jsessionid=3D230CBA14E84B5
> 5C04DED4CC
> 2FF26E224
>=20
> =20
>=20
> written by Connor McDonald? For some reason it doesn't select the
> partitioned tables for a schema analyze and I don't know enough about
> the sys.$ tables to understand why. I'm looking at it in 9204. I see
> that p_part_name isn't being populated but I don't know where=20
> the value
> would come from.
>=20
> =20
>=20
> I'm just curious... thanks
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jan 28 2004 - 14:10:06 CST
