| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1554: Out of transaction slots
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 <ORACLE-L_at_fatcity.com>
n" cc:
<kaygopal_at_yah Subject: RE: ORA-1554: Out of transaction slots
oo.com>
Sent by:
root_at_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-----
Rajesh.Rao_at_jpmchase.com
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: Rajesh.Rao_at_jpmchase.com
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: ListGuru_at_fatcity.com (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). Received on Tue Oct 08 2002 - 15:49:05 CDT
 |
 |