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
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
]
cc: Rajesh Rao/CHASE@CHASE
October 08, Subject: Re: ORA-1554: Out of transaction
slots
2002 02:44 PM
of list ORACLE-L
[EMAIL PROTECTED]
n cc:
kaygopal@yahSubject: RE: ORA-1554: Out of transaction
slots
]
cc: Rajesh Rao/CHASE@CHASE
October 08, Subject: Re: ORA-1554: Out of
transaction slots
2002 02:44 PM
It's dependant on block size, or at least it was the last time I checked,
which
]
.comcc:
Sent by: Subject: Re: ORA-1554: Out of transaction
slots
root@fatcity
-L [EMAIL PROTECTED]
.comcc:
Sent by: Subject: Re: ORA-1554: Out of
transaction slots
root@fatcity.
com
October 08