Different Values in V$sysstat / aggregated V$sesstat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Different Values in V$sysstat / aggregated V$sesstat

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    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


  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    it seems that the value in v$systat is the cumulated Val?
    ( What sense makes this for memory ?)
    Orca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width