Smart Flash Cache and Smart Flash Logging - Oracle Exadata Recipes: A Problem-Solution Approach - page 526

Listing 18-2. lst18-02-sfc-mysess.sql
select stat.name,
sess.value value
from v$mystat sess,
v$statname stat
where stat.statistic# = sess.statistic#
and stat.name in ('cell flash cache read hits','physical read total bytes',
'physical reads','consistent gets','db block gets',
'physical read IO requests','session logical reads')
order by 1;
Before executing the query against the RCV_TRANSACTIONS table, our session level statistics from Listing 18-2
looked like this:
Statistic Value
---------------------------------------- ----------------
cell flash cache read hits 0
consistent gets 3
db block gets 0
physical read IO requests 2
physical read total bytes 16384
physical reads 2
session logical reads 3
Note in this output that our session had measured zero cell flash cache read hits. This database statistic is our
measuring for SFL cache hits. After executing the query for the first time, our session statistics showed these values:
Statistic Value
---------------------------------------- ----------------
cell flash cache read hits 0
consistent gets 7
db block gets 0
physical read IO requests 6
physical read total bytes 49152
physical reads 6
session logical reads 7
This output shows that we still witnessed zero cell flash cache read hits, but it also shows that we performed
(6-2) = 4 physical read I/O requests. These I/O requests were satisfied from disk. Now, we'll examine the metrics
from the flashcachecontent object on the storage cells:
[oracle@cm01dbm01 ]$ dcli -g ~/cell_group cellcli -e list flashcachecontent attributes
dbUniqueName,hitCount,missCount,cachedSize,objectNumber where objectNumber=3080102
cm01cel02: VISX 0 3 98304 3080102
[oracle@cm01dbm01 ]$ dcli -g ~/cell_group cellcli -e list flashcachecontent attributes
dbUniqueName,hitCount,missCount,cachedSize,objectNumber where objectNumber=3010199
cm01cel02: VISX 0 1 32768 3010199
[oracle@cm01dbm01 ]$