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 :)

No.

hi yaba,

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

many thanks.

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...

Quote:

---

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 :D

Cheers