Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 build-in store procedure, or it need to be custom build store procedure...

How I can detect, after I get those values, is it a mormal, heavy, extreme work load. What are criterias.

share|improve this question

1 Answer 1

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.