Translation Please/ V$sysstat

[Mr.Hanky]

SQL> select STATISTIC#, NAME, CLASS, VALUE
from v$sysstat
order by 2


STATISTIC# NAME CLASS VALUE
15 session uga memory 1 9.709E+11
97 redo size 2 4.871E+09

Can someone explain what these values mean, the last time I checked "E" was not a number.

Thanks
MH

[marist89]

It's just your format from sqlplus. For example:

SQL> l
  1* select 123*1000000000 theVal from dual
SQL> /

    THEVAL
----------
1.2300E+11

SQL> col theval for 999999999999.99
SQL> /

          THEVAL
----------------
 123000000000.00

[Mr.Hanky]

You are a man amongst men, thanks.
MH