RE: Analyze script written by Connor McDonald

From: Koivu, Lisa <Lisa.Koivu_at_Cendant-TRG.com>
Date: Wed, 28 Jan 2004 15:20:35 -0500
Message-ID: <840C139B79E7CC4496B2594E9E35E9670419256F@floexmailbe2.ffci.com>

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_at_quest.com]=20 Sent: Wednesday, January 28, 2004 3:10 PM To: oracle-l_at_freelists.org
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_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

>=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_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
-----------------------------------------------------------------

"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_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:20:35 CST