1 person found this helpful
By impact Objects usage, may be you mean some "lock" which limit the access on the Object.
It is signalled that some "ORA-00054 resource busy and acquire with nowait specified or timeout expired" may happens if the Statistics are collected on a Materialized View during a Refresh. You'll find a Note on MOS on this point:
Anyway, gathering statistics is rather resource consuming, so it's better to do it during Maintenance Window. By default the Statistics are gathered from 10 pm to 2 am in week days and during week end.
Also, cursors may be invalidated when gathering statistics, please refer on the Note below:
Hope this help,
yes, i mean object locking. thanks for clarifying and suggestion.