- Why Monitor Oracle Database
- Types of Oracle Database Monitoring
- 1. Status monitoring
- 2. Performance monitoring
- 3. Trend Analysis
Database need to be monitored to check the performance of the monitored database, so we can change the database parameter based on result from monitoring and keep the database in it’s best performance.
Database monitoring also needed so we always know the condition of database, and know the symptom of our database and we can take action right before more problem happens to database.
Database Monitoring can be grouped into three types :
This monitoring type monitors current status of an events and give reports or alert when it exceeds a defined threshold
Examples of Status Monitoring are, check tablespace where it’s about to fills up, check segment near their maximum extents.
Monitors oracle instance memory (sga, buffer, etc), sql query running in database, session which consumes a lot of memory, etc.
Examples of Performance monitoring are, query from v_$sqlarea to check what SQL has been running in our Oracle Machine, query from v$sgastat and query to get hit ratio for cache , library and buffer cache.
Collects historical data on specific event that occur in database like SGA status, segment that cannot extends, filled up tablespace and make analysis from that historical data so that we can predict the status of SGA in any given time or we can now when the tablespace will filled up.
Examples of Trend Analysis are, make a histroy table for events we monitored. We can make history table for tablespace so that from that history table we could gain information and make prediction when will the time the tablespace will be filled up. Or we can make history table from v_$session, so from that table we can know what time our database accessed by so many user.
