Re: Privileges required for dbms_stats

Jack Wang wrote:

> Thanks. Any suggestion on whether having schema owner gather its own stats or having a central user
> in charge of gathering all other schemas' stats.
>
> - Jack

If you are talking production, and I presume you are, it should be done with DBMS_JOB as part of a scheduled job ... one job per application. And I prefer schema owners to SYS but only because too many things are done as SYS that don't need to be.

But if by schema owner you mean a person ... I'd say "no way."

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)