Re: OPTIMAL question

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 09 Jul 1999 09:26:28 -0700
Message-ID: <378622B4.A7C90142@us.oracle.com>

I have a feeling that what the original poster was seeing is the earlier version allowed the use of the OPTIMAL parameter in the default storage clause for the tablespace. It didn't actually do anything and was removed as supported syntax. Just a thought.

Pete

Jonathan Lewis wrote:

> It works on other platforms, call it in as a bug.
>
> create public rollback segment jpl
> tablespace rollback_data
> storage (initial 50K next 50K optimal 250K)
> ;
>
> alter rollback segment jpl online;
>
> select optsize from V$rollstat;
>
> OPTSIZE
> ---------
>
> 307200
> 307200
> 307200
> 307200
> 307200
> 307200
> 256000 <<-- honest, it's this one.
>
> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
> .......
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Huy Vu wrote in message ...
> >Hi all,
> >
> >Why the oracle 8.0.4 (Dec Unix 4.0D) doesn't support OPTIMAL clause in
> >STORAGE for rollback tablspace tuning?

--
Regards

Pete

Received on Fri Jul 09 1999 - 11:26:28 CDT