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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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).
