RE: Analyze script written by Connor McDonald
- From: "Koivu, Lisa" <Lisa.Koivu@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Jan 2004 15:20:35 -0500
Hi Jacques,=20
I ran it in debug mode also and it doesn't list any of the partitioned
tables within the schema I'm selecting. =20
-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer@xxxxxxxxx]=20
Sent: Wednesday, January 28, 2004 3:10 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Analyze script written by Connor McDonald
I ran it in "debug" mode for a particular schema and the debug mode =3D
showed that it was going to analyze a partitioned table. If you analyze
=3D
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
>=3D20
>=3D20
> Has anyone used this analyze script, dbstat.sql, near the=3D20
> bottom of the
> page
> =3D20
>=3D20
> http://www.oaktable.net/userFiles.jsp;jsessionid=3D3D230CBA14E84B5
> 5C04DED4CC
> 2FF26E224
>=3D20
> =3D20
>=3D20
> 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=3D20
> the value
> would come from.
>=3D20
> =3D20
>=3D20
> 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
-----------------------------------------------------------------
"The sender believes that this E-Mail and any attachments were free of =
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission. By reading the message and opening any attachments, the =
recipient accepts full responsibility for taking proactive and remedial =
action about viruses and other defects. The sender's business entity is =
not liable for any loss or damage arising in any way from this message =
or its attachments."
----------------------------------------------------------------
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:
