an Unable to
use system rollback segment for a non system error.
When does Oracle report an ORA-1554: Out of transaction slots for a
rollback segment?
Thanks
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
, and then running updates against the database thru
different sessions without commiting any of them? As expected, it accepted
the first 21 transactions, and on the 22nd transaction, threw an Unable to
use system rollback segment for a non system error.
When does Oracle report an ORA-1554: Out
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:ORA-1554: Out of transaction slots
Hello Folks,
I carried out a test, whereby I had just one rollback segment online with
a
block size of 2K, and then running updates against the database thru
]
cc: Rajesh Rao/CHASE@CHASE
October 08, Subject: Re: ORA-1554: Out of transaction
slots
2002 02:44 PM
of list ORACLE-L
[EMAIL PROTECTED]
n cc:
kaygopal@yahSubject: RE: ORA-1554: Out of transaction
slots
]
cc: Rajesh Rao/CHASE@CHASE
October 08, Subject: Re: ORA-1554: Out of
transaction slots
2002 02:44 PM
It's dependant on block size, or at least it was the last time I checked,
which
: error freeing extent (3) of rollback segment (2). Yes,
optsize is set.
ORA-1554: Out of transaction slots in transaction tables.
I am trying to investigate why? Metalink could not give me a definite
answer, and soft closed the tar.
Thanks
Raj
is set.
ORA-1554: Out of transaction slots in transaction tables.
I am trying to investigate why? Metalink could not give me a definite
answer, and soft closed the tar.
Thanks
Raj
Anjo Kolk
anjo@oraperfTo: Multiple recipients of list
ORACLE