Re: Rollback segment question

From: Luis Moreno Campos <moreno_at_teleweb.pt>
Date: Fri, 8 Oct 1999 19:27:16 +0100
Message-ID: <7tldao$5od$1@fenix.maxitel.pt>

You have missed using the following comand before you run the query/report:

SQL> alter session set transaction read only; -- this will mark the select has a transaction
SQL> ... long running query ...
SQL> commit; -- This will free out the space reserved in the rollback space

Tony Adolph <tony.adolph_at_viaginterkom.de> wrote in message news:7tl0fo$mar$1_at_nnrp1.deja.com...
> Hello All,
>
> I am getting
>
> *** 1999.09.08.12.26.34.717
> SMON: following errors trapped and ignored:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01555: snapshot too old: rollback segment number 33 with name
> "BIG_RBS01" too small
>
> I have 33 rollback segments with an initial and next extent of 102400
> and BIG_RBS01 which has an initial of 150M and next of 1M.
>
> It was my intention for only the reports scripts to use BIG_RBS01 via
> the alter session use rollback.....etc. All of the rollback segs are
> private and there seems to be freespace enough for all of the segments
> to grow.
>
> What have I missed out?
>
> Thanks in advance
> Tony Adolph
>
> PS Ora 7.3.4 on NT4
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 08 1999 - 13:27:16 CDT