Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-1554: Out of transaction slots

RE: ORA-1554: Out of transaction slots

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 08 Oct 2002 11:59:24 -0800
Message-ID: <F001.004E38F2.20021008115924@fatcity.com>


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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.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 - 14:59:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US