Exadata General (MOSC)

MOSC Banner

cell flash cache hits increased during insert

edited Feb 13, 2015 10:02AM in Exadata General (MOSC) 3 commentsAnswered

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%';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center