-- Operating System Statistics
1. CPU Statistics
V$OSSTAT
- view captures machine-level information in the database, making it easier for you to determine if hardware-level resource issues exist.
V$SYSMETRIC_HISTORY
- view shows a one-hour history of the Host CPU Utilization metric, a representation of percentage of CPU usage at each one-minute interval
V$SYS_TIME_MODEL
- view supplies statistics on the CPU usage by the Oracle database. Using both sets of statistics enable you to determine whether the Oracle database or other system activity is the cause of the CPU problems
--
2. Memory
This command below includes a great deal of detail, including the size of the mapped segment, how much if it is RSS (Real memory), how much of that is shared, the sizes and permissions of the segment. It is the output above that can be ‘compared’ over time to see if a given process is growing, or leaking memory.
$ pmap -x $$
where $$ - process ID
3. Disk I/O Statistics
- Consumer group
V$IOSTAT_CONSUMER_GROUP view captures I/O statistics for all consumer groups that are part of the currently enabled resource plan
- Database file
I/O statistics of database files that are or have been accessed are captured in the V$IOSTAT_FILE view
select * from V$IOSTAT_FILE
- Database function
I/O statistics for database functions (such as the LGWR and DBWR) are captured in the V$IOSTAT_FUNCTION view.
select * from V$IOSTAT_FUNCTION
4. Network Statistics
V$IOSTAT_NETWORK - network I/O statistics
select * from V$IOSTAT_NETWORK
Operating System Data Gathering Tools
Table shows the various tools for gathering operating statistics on *NIX.
Component | UNIX Tool
CPU | sar, vmstat, mpstat, iostat
Memory | sar, vmstat
Disk | sar, iostat
Network |netstat
