ubject: Re: Set transaction does not work
Under your situation of select only statement there is no use
of rollback
segment whether big or small. This error is a result of some
other long
running job using that rollback segment. Please advise
relevant developer
to check his code doing s
RDBMS 7.3.2.3
I am running this under SQLPLUS
set transaction use rollback segment BIG_ROLLBACK
select c1, c2
from giant_poorly_indexed_table
where unindexed_colum='';
exit;
I end up with "snapshot too old" rollback segment RB_07.
Why won't it use the giant rollback segment I created
I think the big rollback segment needs to be private.
[EMAIL PROTECTED] 03/29/01 12:50PM
RDBMS 7.3.2.3
I am running this under SQLPLUS
set transaction use rollback segment BIG_ROLLBACK
select c1, c2
from giant_poorly_indexed_table
where unindexed_colum='';
exit;
I end up with
Specifying a transaction rollback segment only controls to which RBS
rollback information will be written. The "snapshot too old" arises when
the DBMS tries to construct a read-consistent block of a table; it goes to
the RBS that received rollback for some transaction that changed it, only to
29, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Set transaction does not work
I think the big rollback segment needs to be private.
[EMAIL PROTECTED] 03/29/01 12:50PM
RDBMS 7.3.2.3
I am running this under SQLPLUS
set transaction use rollback segment
Under your situation of select only statement there is no use of rollback
segment whether big or small. This error is a result of some other long
running job using that rollback segment. Please advise relevant developer
to check his code doing some delete,update,insert and intoduce some commit
Where is the transaction?
Alex Hillman
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:Set transaction does not work
Be sure the set transaction use rollback segment is the first thing done
after you start/connect to sqlplus otherwise it won't use it.
-Original Message-
Sent: Thursday, March 29, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L
I think the big rollback segment needs to be
First test: try to remove any settings for the OPTIMAL parameter for all the
RBSegments
-Original Message-
Sent: Thursday, March 29, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
RDBMS 7.3.2.3
I am running this under SQLPLUS
set transaction use rollback segment BIG_ROLLBACK