DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Table Analysis

  1. #1
    Join Date
    Mar 2001
    Posts
    36
    How could I know that table analysis done by
    1. Analyze table
    2. DBMS_STATS.GATHER_SCHEMA_STATS Package.



  2. #2
    Join Date
    Mar 2001
    Posts
    36
    Is question wrong.....?
    Can anybody help...?

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    SQL> analyze table plan_table compute statistics;

    Table analyzed.


    In SQL* it tells you when it is complete, what is the problem?

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Mar 2001
    Posts
    36
    Is there any view or other facility so I can confirm that analyze done by analyze command or DBMS package.

  5. #5
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Not that I've heard of.

    Considering that they do exactly the same thing, why would you even care which one did it?

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width