oracle Monitoring project

Jan 6 posted in Oracle (RSS), 84 views.

oracle Monitoring project

1. An instance of it online monitoring of

2. Monitoring shared pool shared pool of

■ library cache memory size whether the threshold

■ library cache hit ratio

■ data dictionary cache hit ratio

3. Monitoring database buffer cache

■ database buffer cache memory size of whether the threshold

■ database buffer cache hit ratio

■ database buffer cache utilization of free block

■ dirty buffer data block usage

■ clean buffer data block usage

■ free buffer data block usage

■ pin buffer data block usage

4. Control log buffer cache

■ log buffer cache memory size

■ log buffer cache hit ratio

■ log buffer cache Redo log

■ log buffer cache Redo log files of written records

5.pmon, smon, ckpt, dbwn, lgwr, mman background process monitoring and control

■ pmon background process to release resources

■ smon background process to resume operation instance

■ dbwn background process to write dirty blocks of

■ ckpt background process checkpoint record to the redo log block address

Control file and data files to the head of

■ lgwr background process to write the log file of the implementation of

■ mman background process view the PGA automatically allocates the memory component of

6.session session connection monitoring

■ session the number of connections

■ session of sid, serial #

■ session waiting time consuming

■ session connection hit rate

■ session Total Physical Read

■ session logical reading of the total

■ session Total submission of affairs

■ session occupied by issuing SQL statements CPU

■ session to issue SQL statement memory occupied by

■ session where the machine name

■ session login time

■ session the process used

■ session state, such as: the connection is normal, whether the deadlock, whether to wait for

7.PGA program global area memory monitoring

8.SGA System Global Area memory component is the optimum allocation of monitoring, if it is automatic SGA management, while monitoring

Whether the various memory components of the most reasonable memory allocation.

9. Tablespace monitoring

■ table space utilization

■ share table space for each data file storage situation

■ table space growth

■ Is it too much table space debris

■ free table space capacity of the

■ have the capacity to use the table space

■ the use of data files, such as whether the full, for damage.

10. Redo log file group to monitor

■ log group members are online

■ log switch whether it is normal to switch

■ log file is damaged

■ log file group where the disks are normal.

■ the use of log files

11. Archive log files to monitor

■ archive log file sequence number is a continuous

■ archive log file exists merchandise in

■ archived log file is corrupted

■ archived log file directory where the disk is normal

12. Control file monitoring

■ Control the volume of documentation is normal

■ Control file where the disk is normal

■ Control file records database operations whether it is normal

13. Rollback segment monitor

■ Services existence of old snapshot of

■ undo_retention parameters are correct

■ retention_guarantee parameters are correct

■ monitor the size of rollback tablespace

■ active undo block size of the monitoring

■ inactive undo block size of the monitoring

■ expired undo block size of the monitoring

■ free und block size of the monitoring

■ undo segment extent districts to exchange information

14. User Rights Monitoring

■ monitoring of the user object permissions

■ monitor the user's system privileges

■ monitor the user's password complexity

15.SQL statement monitoring

■ SQL statement that the share system, the monitoring CPU

■ SQL statement is an instance of memory occupied monitoring

16. Network Monitoring

■ whether the server-side listener listening

■ examples of client and server-side connectivity monitoring

17. Safety Monitoring

■ oracle audit function is to open

■ Mandatory audit monitoring

■ monitoring of standard database auditing

■ Based on the value of the audit monitoring

■ Precise monitoring of the audit

■ DBA Audit Monitoring

18.job task of monitoring

■ job is to run at a specified time

19. Backup and recovery monitoring

■ archiving mode is prepared to complete the whole

■ archive mode, the difference is the completion of incremental backups

■ archive mode, the cumulative incremental backup is complete

■ archiving mode control file backup is complete

■ archiving mode parameter file backup is complete

20. Other Monitoring

■ Oracle data files monitoring of high-water mark

■ oracle to monitor the number of bad blocks

■ oracle cursor number of monitoring

■ latch locks the database to monitor

■ oracle deadlock resulting monitoring

■ Monitoring of the total amount of user process

■ active monitoring of user process