Thanks Gopal for the info provided. I would want to know how I can simulate
this error? I did some tests but I got an "Unable to use system rollback
segment for non system ... ".
We had one of our applications report this in the application log. I am
trying to find out why?
Thanks
Raj
"K
Gopalakrishna To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
n" cc:
<kaygopal@yah Subject: RE: ORA-1554: Out of transaction
slots
oo.com>
Sent by:
root@fatcity.
com
October 08,
2002 03:59 PM
Please
respond to
ORACLE-L
Rajesh:
The header block of the rollback segment contains the transaction
table and this is roughly equal to the ITL in the data block headers.
And number of transaction slots depends on the block size and for a
2k Block size you get 21 slots.
The transaction slots in the rollback segments are exposed in X$KTUXE
and the slots are visible as ktuxeslt. You can use the following
SQL to get the number of transaction slots for the rollback segments.
select count(*) ktuxeslt from X$ktuxe group by ktuxeusn;
When you don;t have a slot for the new transaction, you get the
ORA-01554.
Best Regards,
K Gopalakrishnan
http://www.oradebug.com
-----Original Message-----
[EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
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
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 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 Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
