Re: OPTIMAL question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 9 Jul 1999 09:34:41 +0100
Message-ID: <931509557.3185.0.nnrp-03.9e984b29@news.demon.co.uk>

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?
Received on Fri Jul 09 1999 - 03:34:41 CDT