What's the aveactive column of the v$rollstat column about?

From: Steve Orr <sorr_at_arzoo.com>
Date: Mon, 25 Sep 2000 12:02:45 -0700
Message-Id: <10630.117790@fatcity.com>

G'Day and Howdy y'all,

What's the "aveactive" column of the v$rollstat column about? Yeah, I know the manual says it's the "Current size of active extents, averaged over time..." but what does that mean? My RBS are in a locally managed tablespace with 32 uniform extents of 512KB. I'm getting sporadic ORA-1595 and ORA-1594 alerts which Metalink says can be safely ignored. This is curious because I'm not experiencing any shrinks. (Despite numerous recommendations I avoid psychiatrists ;-) Should I increase my extent size to 1MB or more? Or should I just filter the ORA-1595 and ORA-1594 alerts out of my alertlog checker script?

TIA!
Steve Orr

FYI for the curious, here's a couple of queries:

---

select substr(NAME,1,6) Name,

         RSSIZE,
         OPTSIZE,
         HWMSIZE,
         WRAPS,
         SHRINKS,
         AVEACTIVE
from     sys.v_$rollstat a, sys.v_$rollname b

where a.USN=b.USN
order by NAME;

NAME RSSIZE OPTSIZE HWMSIZE WRAPS SHRINKS AVEACTIVE ------ -------- -------- -------- ----- ------- ----------

RBS01  16760832 16777216 16760832    10       0     341477
RBS02  16760832 16777216 16760832    14       0     515183
RBS03  16760832 16777216 16760832    13       0     416095
RBS04  16760832 16777216 16760832    12       0     527469
RBS05  16760832 16777216 16760832    14       0     469793
RBS06  16760832 16777216 16760832    10       0     341477
RBS07  16760832 16777216 16760832    16       0     628819
RBS08  16760832 16777216 16760832    10       0     341477
RBS09  16760832 16777216 16760832    16       0     919843
RBS10  16760832 16777216 16760832    11       0     388781
RBS11  16760832 16777216 16760832     8       0     297402
RBS12  16760832 16777216 16760832    10       0     341477
RBS13  16760832 16777216 16760832    10       0     341477
RBS14  16760832 16777216 16760832    11       0     359758
RBS15  16760832 16777216 16760832    10       0     341477
RBS16  16760832 16777216 16760832    15       0     762196


------------------------------------------------------------

select   substr(NAME,1,6) Name,
         GETS,
         WRITES,
         WAITS,
         round(((GETS-WAITS)*100)/GETS,2) HitRatio
from     sys.v_$rollstat a, sys.v_$rollname b

where a.USN = b.USN;

NAME GETS WRITES WAITS HITRATIO ---------- ---------- ---------- ---------- ----------

RBS01           32373    2653906          0        100
RBS02           32529    4723972          0        100
RBS03           32557    4354672          0        100
RBS04           32527    4239850          1        100
RBS05           32462    4717838          0        100
RBS06           32438    2992156          0        100
RBS07           39142    5575648          0        100
RBS08          163188    3150230          0        100
RBS09           32576    6562104          0        100
RBS10           32309    3519890          0        100
RBS11           36344    2597418          0        100
RBS12           32357    3068614          0        100
RBS13           32653    2870054          0        100
RBS14           32303    2985778          0        100
RBS15           32390    2870490          0        100
RBS16           32435    5465210          0        100

Received on Mon Sep 25 2000 - 14:02:45 CDT