Table 126 About the Monitoring Options (continued)
Available | Available to Which | Description |
Monitoring | Elements |
|
Options |
|
|
|
|
|
Free Physical | Host | The amount of free physical memory on |
Memory (KB) |
| the host. To receive this data from a |
|
| |
|
| file must be installed on the host. See the |
|
| Prerequisites section in the chapter for |
|
| installing the CIM Extension on AIX in the |
|
| Installation Guide. |
|
|
|
Free Virtual | Host | The amount of free virtual memory on the |
Memory (KB) |
| host. To receive this data from an AIX |
|
| host, the bos.perf.libperfstat file must be |
|
| installed on the host. |
|
|
|
In Memory Sort | Oracle | This ratio shows the proportion of sorts |
Ratio |
| that are performed in memory. |
|
| Optimally, most sorts should be |
|
| performed in memory. If the ratio is less |
|
| then 90 percent investigate further. You |
|
| may need to increase sort_area_size or |
|
| pga_aggregate_target (for Oracle 9i if |
|
| the workarea_ size_policy is auto.) |
|
|
|
Inode Cache Hits | NAS Filers (System) | The number of inode cache hits per |
Count per Second |
| second. |
|
|
|
Inode Cache | NAS Filers (System) | The number of inode cache misses per |
Misses Count per |
| second. |
Second |
|
|
|
|
|
Invalid CRC Errors | Storage Systems | The speed at which invalid cycle |
(errors/second) |
| redundancy checking (CRC) errors are |
|
| found. |
|
|
|
Library Cache Hit | Oracle | This gives an indication of how many |
Ratio |
| times parsed SQL or PL/SQL statements |
|
| needed to be reloaded, which requires a |
|
| reload/rebuild of the statement. If the |
|
| ratio is less then 95% investigate further. |
|
| You may need to increase |
|
| shared_pool_size. |
|
|
|
504 Viewing Performance Data