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

From: Steve Orr <sorr_at_arzoo.com>
Date: Mon, 25 Sep 2000 13:11:49 -0700
Message-Id: <10630.117803@fatcity.com>

duh... I mean the v$rollstat TABLE...

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Steve Orr Sent: Monday, September 25, 2000 1:11 PM To: Multiple recipients of list ORACLE-L Subject: What's the aveactive column of the v$rollstat column about?

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

Also, the db block size is 16K.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve Orr
  INET: sorr_at_arzoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Mon Sep 25 2000 - 15:11:49 CDT