Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Analyze script written by Connor McDonald

Analyze script written by Connor McDonald

From: Koivu, Lisa <Lisa.Koivu_at_Cendant-TRG.com>
Date: Wed, 28 Jan 2004 14:41:19 -0500
Message-ID: <840C139B79E7CC4496B2594E9E35E96703E7D451@floexmailbe2.ffci.com>


Has anyone used this analyze script, dbstat.sql, near the bottom of the page  

http://www.oaktable.net/userFiles.jsp;jsessionid=230CBA14E84B55C04DED4CC 2FF26E224  

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 the value would come from.  

I'm just curious... thanks  

Lisa Koivu
Dumb Big A$$ (how I've been made to feel today, anyway).  

"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 - 13:41:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US