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

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

Hybrid View

  1. 04-23-2003, 03:41 AM #1
    ngwh
    ngwh is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 04-23-2003, 03:47 AM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    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!
    Reply With Quote Reply With Quote
  3. 04-23-2003, 03:56 AM #3
    ngwh
    ngwh is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  4. 04-23-2003, 04:06 AM #4
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    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!
    Reply With Quote Reply With Quote
  5. 04-23-2003, 04:25 AM #5
    aarroyob
    aarroyob is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width