patternMinor
Oracle monitoring db status
Viewed 0 times
oraclestatusmonitoring
Problem
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
How I can detect, after I get those values, is it a normal, heavy, extreme work load. What are the criteria?
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?
Solution
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.
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.
Context
StackExchange Database Administrators Q#1612, answer score: 5
Revisions (0)
No revisions yet.