.com>cc:
Sent by: Subject: Re: ORA-1554: Out of
transaction slots
root@fatcity.
com
October 08,
cc:
Sent by: Subject: Re: ORA-1554: Out of transaction
slots
Jared.Still@r
> adisys.com To: [EMAIL PROTECTED]
> cc: Rajesh Rao/CHASE@CHASE
> October 08, Subject: 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
To: [EMAIL PROTECTED]
cc: Rajesh Rao/CHASE@CHASE
October 08, Subject: Re: ORA-1554: Out of transaction
slots
It's dependant on block size, or at least it was the last time I checked,
which was a few years ago.
You can see the number of slots by doing a block dump the rollback
segment.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/08/2002 11:34 AM
Please respond to ORACLE-L
T
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