Exadata General (MOSC)

MOSC Banner

cell flash cache read hits and bytes over interconnect

edited Nov 18, 2014 10:02AM in Exadata General (MOSC) 3 commentsAnswered

Hello,

I ran below statements on exadata.As seen below the number of cell flash cache read hits increased on second execution of the pl/sql.

However,the physical read total IO requests increased from 813 to 1015 - query being the same.Could you please elaborate more on this?

SQL> conn sales/sales
Connected.
SQL> declare
a number;
s number :=0;
begin
for n in 1 .. 500 loop
select cust_credit_limit into a from customers where cust_id=n*2000;
s := s+a;
end loop;
dbms_output.put_line('Transaction total = '||s);
end;
/  2    3    4    5    6    7    8    9   10   11

PL/SQL procedure successfully completed.

SQL> select a.name,b.value from v$sysstat a,v$mystat b

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