in oracle 10G, which user should I log in to generate the sp report?

On 8/9/2006 2:44 PM, Krupetsky Milana <oracledba-ezmlmshield-x73775480.[Email address protected] wrote:
>BEGIN
> DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');
>END;
>
>-----Original Message-----
>From: Nizar Ahmed
>[mailto:oracledba-ezmlmshield-x82919106.[Email address protected]
>
>Sent: Tuesday, August 08, 2006 3:02 AM
>To: LazyDBA Discussion
>Subject: Stop Statistics gathering in 10G - How to freeze?
>
>
>
>In 10G the GATHER_STATS_JOB is created by default which runs the
>SYS.GATHER_STATS_PROG which in turn runs the
>dbms_stats.gather_database_stats_job_proc procedure.
>
>I am trying to freeze statistics for a weeks time to evaluate optimizer
>performance. How do I disable this job temporarilrt. I do not want
>to
>delete it.
>
>Thanks,
>
>Nizar
>
>
>Disclaimer: The information in this email and in any files transmitted
>with it,
>is intended only for the addressee and may contain confidential and/or
>privileged material.
>Access to this email by anyone else is unauthorized. If you receive
>this
>in error,
>please contact the sender immediately and delete the material from
>any
>computer.
>If you are not the intended recipient, any disclosure, copying,
>distribution or
>any action taken or omitted to be taken in reliance on it, is strictly
>prohibited.
>Statement and opinions expressed in this e-mail are those of the
>sender,
>and do not
>necessarily reflect those of STC.
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>


Oracle LazyDBA home page