any harm running "DBMS_UTILITY.ANALYZE_SCHEMA ('SCHEMA_NAME', 'COMPUTE'), " ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: any harm running "DBMS_UTILITY.ANALYZE_SCHEMA ('SCHEMA_NAME', 'COMPUTE'), " ??

  1. #1
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456

    any harm running "DBMS_UTILITY.ANALYZE_SCHEMA ('SCHEMA_NAME', 'COMPUTE'), " ??

    hi,

    I am just concern if there's any harm if I run "'DBMS_UTILITY.ANALYZE_SCHEMA ('SCHEMA_NAME', 'COMPUTE') " during non-peak database operation hour ?? will there be serious performance issue?

    any comments are appreciated

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    No.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hi yaba,

    are u sure about it?? is there anywhere that u can point to any doc. to support your comments?

    many thanks.

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Use your common sense man, if it was harmful why would oracle supply such package. And BTW its only gathering statistics for your schema... what are you expecting it would do, delete your datafiles or something like that... Read the manuals and you will have no doubts.

    And what support do you need... some document saying its not harmful... STW yourself...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by adewri
    Use your common sense man, if it was harmful why would oracle supply such package. And BTW its only gathering statistics for your schema... what are you expecting it would do, delete your datafiles or something like that... Read the manuals and you will have no doubts.

    And what support do you need... some document saying its not harmful... STW yourself...
    Not always adewri, Oracle has supplied to the dbms_utility.analyze_database

    Cheers

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