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

Regarding the v$rollstat.aveactive column.

Here's an answer from OWS...
"General overview is that for most intents, v$rollstat.aveactive column is not a column worth perusal/analysis.... internal usage only by rdbms engine. As far as the 'active extents', that's the amount of the extent being used, not the allocated size of the extent..."

I'd call this a documentation bug because of the misleading verbiage. Isn't it still an interesting number to me worth analysis? Anyone?

Steve Orr

-----Original Message-----
From: Steve Orr [mailto:sorr_at_arzoo.com]
Sent: Monday, September 25, 2000 12:03 PM To: Ixora Answers; Oracle-L; Oracledba
Subject: What's the aveactive column of the v$rollstat column about?

G'Day and Howdy y'all,

What's the "v$rollstat.aveactive" 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 Received on Wed Sep 27 2000 - 10:55:11 CDT