Home / server / Questions / 79439
Accepted
Roy
Asked: 2009-10-30 02:24:00 +0800 CST

Open source scripts for Oracle health check?

  • 772

I want to put together some scripts to run an automated health check of Oracle 9i and 10g databases. Before I start from scratch, I was wondering if anyone know of any available open source scripts that I could use as a base for this project.

oracle

5 Answers

  1. Best Answer

    If you have access to metalink - document 136697.1 has a healthcheck script.

    • 1

  2. I think the most important part of the health check is not the data extraction, but data analysis. We have our scripts built around statspacks, as they provide most reliable results and statistics.

    http://www.leaderside.com/oracle-health-check/oracle-healthcheck-2

    Learn more here.

    • 1

  3. Tim Hall has a great site for Oracle resources: oracle-base.com. I would bet there's a lot in there you could use.

    • 0

  4. http://www.evdbt.com/tools.htm has a whole bunch of healthcheck/monitoring/performance related scripts. Some of them are quite advanced but maybe they're worth a look in case you want to set up something more "powerful".

    • 0

  5. If you have 10g + the inbuilt DBCONSOLE website has quite an extensive set of monitoring and health checking features.

    I'd take a look at those before looking at external scripts.

    • 0