Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is wrong with this rollback segment stmt ?
I believe that your problem is the setting of storage parameters of rollback segments.
Since the extent size is 500k, and minimal number of extents is 50, i.e.
the minimal size
of one rollback segment is 25M, so that 4 rollback segments will occupy
100M space out
of your 110M. When some large transactions are running, and rollback
segments related
need more space, remained 10M space may be not enough.
In this case, you may set the MINEXTENTS to a little value such as 10
and OPTIMAL to 10M.
Atif Ahmad Khan wrote:
>
> I was having rollback segment blues.
> create tablespace RBS datafile 'rbsWG73' size 110M autoextend on next 1M
> maxsize 200M ;
>
> // Created the four rollback segments and brought them back online.
> create public rollback segment r01 tablespace RBS storage
> (initial 500K NEXT 500K OPTIMAL 25M MINEXTENTS 50 MAXEXTENTS 400);
> alter rollback segment r01 online ;
>
> After a run few large transactions, the tablespace gets full and I start
> getting errors related to space problems on the system tablespace.
> I thought I would never run into problems with the above setup. The 4
> rollback segments have an optimal size of 25M. The tablespace should
> never be more than 55% full. I checked available space on tablespace RBS
> then and it had .14% available. Now, after several hours it has about
> 50.2% available. Could anybody please point to what I did wrong ?
>
-- Hui, Kwok Miu (Xu, Guo Miao) E-Mail: huikomix_at_dt.com.hk Assistant MIS Manager Tel : (00852)2589 3369 Cho Yang (Hong Kong) Co., Ltd. Fax : (00852)2559 3049Received on Tue Feb 11 1997 - 00:00:00 CST