Re: How do I check if a tablespace was create with OPTIMAL keyword?

From: Andy <enzoweb_at_hotmail.com>
Date: 12 Aug 2002 15:02:22 -0700
Message-ID: <8d4033cd.0208121402.53fe0eff@posting.google.com>

Tablespaces aren't created with Optimal, Rollback segments are. Run this:

select NAME, XACTS, EXTENTS,

floor(RSSIZE/1024/1024)||'M' RSSIZE,
floor(OPTSIZE/1024/1024)||'M' OPTSIZE,
floor(HWMSIZE/1024/1024)||'M' HWMSIZE,

GETS, WAITS, abs(WRITES) WRITES,
SHRINKS, EXTENDS, WRAPS, AVESHRINK,
AVEACTIVE, STATUS
from v$rollstat t1, v$rollname t2
where t1.usn=t2.usn
and name != 'SYSTEM'
order by abs(WRITES) desc;

for lots of info on your rollback segments. If the OPTSIZE just says 'M' then Optimal is not set.

Brian Tkatch <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK> wrote in message news:<390glug21fe985mr2k7ks5iqj6bkkocb3m_at_4ax.com>...
> How do I check if a tablespace was create with OPTIMAL keyword?
Received on Mon Aug 12 2002 - 17:02:22 CDT