What do you recommend for regular database health check in Oracle? We want
to make it as standard procedure. Is it necessary? MSSQL has such
maintenance plan.

David wrote:
Oracle builds their "health check" functionality into Enterprise
Manager. With EM, it will check to ensure that the database is
available, tablespaces are not running out of space, performance metrics
are being met...and much, much more. SQL Server's maintenance plans, by
comparison, do very little.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

On Oct 24, 8:56 pm, "David" <da... (AT) mcp (DOT) com> wrote:
Oracle also has a tool called RDA, which just gathers basic info for
support calls. It might be an idea to run it regularly so you are
prepared and documented, as long as you are putting SOP together. Use
metalink.oracle.com to access Note:330760.1 or Note:314422.1 . Note:
460796.1 shows how to run it in cron. You should always post your
version and platform.

Here is a brief intro to this group: http://www.dbaoracle.net/readme-cdos.htm

jg
--
@home.com is bogus.
http://www.portfolio.com/executives/...ific-Inventors

But what about if I want to schedule the database health check?

--
--
http://allmoneysense.blogspot.com/

--
http://five-tips.blogspot.com/


"Brian Peasland" <dba (AT) nospam (DOT) peasland.net> wrote

David wrote:
Then get 11g. The built-in health management system contains both fully
automated and manual components. It makes the RDA tool all but obsolete
and has state-of-the-art capabilities.

Anyone interested in learning more about this can research:
Automatic Diagnostic Repository, DBMS_HM and DBMS_IR in Morgan's Library
at www.psoug.org. The docs at the usual place: http://tahiti.oracle.com.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org