Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Analyze script written by Connor McDonald
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."
![]() |
![]() |