cell flash cache hits increased during insert
Hello,
Pls refer below and not sure why the cell flash cache read hits increased on inserting the rows.
SQL> conn sales/sales
Connected.
SQL> select b.value,a.name from v$mystat b,v$sysstat a where a.statistic#=b.statistic# and a.name like '%cell flash%';
VALUE NAME
---------- ----------------------------------------------------------------
0 cell flash cache read hits
SQL> create table emp(rol number(10));
Table created.
SQL> declare i number;
2 begin
3 for i in 1 .. 10000
4 loop
5 insert into emp values(i);
6 end loop;
7 end;
8 /
PL/SQL procedure successfully completed.
SQL> select b.value,a.name from v$mystat b,v$sysstat a where a.statistic#=b.statistic# and a.name like '%cell flash%';