-
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
-
Amar
"There is a difference between knowing the path and walking the path."
-
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...
Amar
"There is a difference between knowing the path and walking the path."
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|