Thanks.



"Yoav Givon " <oracledba-ezmlmshield-x96900741.[Email address protected]
05/31/2007 05:03 AM


To
"LazyDBA Discussion" <[Email address protected]

cc


Subject
RE: dbms_stats in 10G







You don't have to . All tables are in monitoring state as default and
the package will be run every night using the _stale mode

Yoav

-----Original Message-----
From: Sheuehua
[mailto:oracledba-ezmlmshield-x5754406.[Email address protected]
Sent: Thursday, May 31, 2007 12:46 AM
To: LazyDBA Discussion
Subject: dbms_stats in 10G


Hi all,
recently I have just installed 10G db. In 9i we have to run
dbms_stats every day; how about in 10G do we still
need to run it?

Thanks,

Sue
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




To: "LazyDBA Discussion" <[Email address protected]
cc:
From: "Yoav Givon "
<oracledba-ezmlmshield-x96900741.[Email address protected]

**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************

Oracle LazyDBA home page