Monitoring Recipes

Monitoring

Recipes for monitoring your Oracle database — find blocking sessions, track code changes, detect errors, manage tablespace, and more.

Identify and diagnose blocking sessions using v$session and v$lock views.

Query locked database objects with session information to quickly spot problems.

See who's connected, what SQL they're running, and which sessions consume the most resources.

Set up a trigger-based system to log all DDL changes in your database.

Find out how long you have to wait for a query to finish using v$session_longops.

Query v$instance or v$session to find out how long your database has been running.

Monitor tablespace capacity and find what's consuming the most storage.

Identify invalid objects after schema changes and recompile them automatically.

Use a logon trigger to block specific applications from connecting to your database.

Create a trigger to log all database errors with full context information.