Listing cache statistics for the database


Listing cache statistics for the database
Prev	About SmartIO caching for Oracle databases on VxFS file systems	Next

A DBA can monitor the cache usage and hit ratio at a database level. You can use the statistics to evaluate the current cache policies. If the hit ratio is not satisfactory, you can consult Oracle AWR reports and change the policies.

To list cache statistics for a database

To view cache statistics for all of the mountpoints of the database, use the following command:

$ sfcache app cachearea=cachearea_name oracle -S $ORACLE_SID \
-H $ORACLE_HOME -o stat

INFO: Oracle Instance tpcc is running
INFO: Store DB details at /tpccdata/.CACHE_INFO
                VxFS SmartIO Statistics
               --------- -----------------------
Cache Size = 1.096 TB
 Cache Utilization = 64.3 GB ( 5.73 %)
Mount       Hit Ratio Cached Pinned  Read      Written  Data
                      Files  Files   Bytes     Bytes    Pinned
-----       --------- -----  ------  --------  -------- ------
/tpccdata   67.80 %   445    10      134.4 GB  179.0 GB 160 KB
/tpcclog    38.10 %   9      0       4 KB      8 KB     0 KB

Prev	Up	Next
Listing cache policy details for the database	Home	About SmartIO caching for databases on VxVM volumes