monitor database connections/sessions
Hi, i would know if anyone has suggestion on how i can monitor the number of connections to the db from a particular host?
From the oracle client's oracle enterprise manager console, i can go network->database->instance->sessions, i can see the which remote host is the connection coming from and what program is using the connection.
From the OS level i could do a primitive `ps -ef | grep ORACLE_SID ` to see and count the total number of connections.( but i cant see which remote is the connection coming from)
I would like to achieve the purpose of remotely monitoring of the DB, if there are too many sessions coming from a particular host, running a particular program, send out alerts.
Are there any oracle commands or OS scripting that i can use?