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

From: Brian Tkatch <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK>
Date: Tue, 13 Aug 2002 10:43:49 -0400
Message-ID: <ho6ilu8mh1kdf63a52cotqrmgd4pd5r7if@4ax.com>

On 12 Aug 2002 15:02:22 -0700, enzoweb_at_hotmail.com (Andy) wrote:

>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.

Thank you.

Brian Received on Tue Aug 13 2002 - 09:43:49 CDT