RE: ORA-1554: Out of transaction slots

2002-10-08 Thread K Gopalakrishnan
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

Re: ORA-1554: Out of transaction slots

2002-10-08 Thread Jared . Still
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

Re: ORA-1554: Out of transaction slots

2002-10-08 Thread Rajesh . Rao
] cc: Rajesh Rao/CHASE@CHASE October 08, Subject: Re: ORA-1554: Out of transaction slots 2002 02:44 PM

RE: ORA-1554: Out of transaction slots

2002-10-08 Thread Rajesh . Rao
of list ORACLE-L [EMAIL PROTECTED] n cc: kaygopal@yahSubject: RE: ORA-1554: Out of transaction slots

Re: ORA-1554: Out of transaction slots

2002-10-08 Thread Anjo Kolk
] 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

Re: ORA-1554: Out of transaction slots

2002-10-08 Thread Rajesh . Rao
] .comcc: Sent by: Subject: Re: ORA-1554: Out of transaction slots root@fatcity

RE: ORA-1554: Out of transaction slots

2002-10-08 Thread Fink, Dan
-L [EMAIL PROTECTED] .comcc: Sent by: Subject: Re: ORA-1554: Out of transaction slots root@fatcity. com October 08