RE: Analyze script written by Connor McDonald
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jan 2004 12:10:06 -0800
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Koivu, Lisa
> Sent: mercredi, 28. janvier 2004 11:41
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
