Different Values in V$sysstat / aggregated V$sesstat

Oracle 8.1.7 EE / OS/390, Z/OS


Hi, i try to search for a reason of os-memory-growth of oracle, which is not visible in the stats-tables. Now i have a problem : when i compare for example the stat 21 the values between v4sysstat/v$sesstat are very different;

Code:

---

-- session pga memory max/21
SELECT SUM(VALUE)  , 'SESS' TYPE FROM V$sesstat WHERE statistic# = 21
UNION
SELECT VALUE ,  'SYS' TYPE FROM V$sysstat WHERE statistic# = 21

SUM(VALUE)        TYPE
1184382896        SESS
20380838725184        SYS

---

Do you know why the values are not the same?

Thanks

Orca

:cool: :cool:

Hi,
it seems that the value in v$systat is the cumulated Val?
( What sense makes this for memory ?)
Orca
:cool: