Oracle monitoring db status

Posted on

Question :

I am looking for a way to monitor Oracle database status (health) via PHP script executing SQL query. There are system variables containing actual number of connection, sessions, work load, etc…

How I can access to those values: via regular SELECT statement, or built-in stored procedure, or it need to be custom build stored procedure…

How I can detect, after I get those values, is it a normal, heavy, extreme work load. What are the criteria?

Answer :

What is ‘normal’ will depend on your situation. An OLTP database and a warehouse will have very different usage profiles.

If you use a connection pool, then you probably don’t expect to see a wide variation in the number of connections or sessions. Such a change would indicate a problem.

Generally you are best off looking for dramatic changes in your measures.

Grab SQL Developer 3 Early Adopter edition from the Oracle website. Check out some of the system reports, and look at the underlying SQLs.

Leave a Reply

Your email address will not be published. Required fields are marked *