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