Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gathering stats for system schemas (SYS and other non-business users)

AnneWSep 15 2021

DB version : 19c, 12.1.0.2

In my shop, I have Siebel DBs whereby optimizer stats are gathered using a custom stored proc.
But, this stored proc gathers stats only for objects in SIEBEL schema.

I don't this stored proc gathering stats for objects owned by sys user, plus other objects in SYSAUX, SYSTEM tablespaces.
What is the recommended way to separately gather stats for non-business schemas like these ?

Comments
Post Details
Added on Sep 15 2021
1 comment
472 views