RE: ** can two processes use the same rollback extent

2003-12-28 Thread Freeman Robert - IL
on Amazon.com! -Original Message-From: A Joshi [mailto:[EMAIL PROTECTED]Sent: Sunday, December 28, 2003 12:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ** can two processes use the same rollback extent Hi, A simple rollback segment question. If I do not set a optimal

RE: ** can two processes use the same rollback extent

2003-12-28 Thread Bobak, Mark
/2003 1:39 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: ** can two processes use the same rollback extent Hi, A simple rollback segment question. If I do not set a optimal then can I assume following 1) rollback segment will not shrink. 2) It will keep growing

Re: ** can two processes use the same rollback extent

2003-12-27 Thread A Joshi
Hi, A simple rollback segment question. If I do not set a optimal thencan I assume following 1)rollback segment will not shrink. 2)It will keep growing till tablespace fills up. 3)And there will be no 'snapshot too old' errors? ThanksA Joshi [EMAIL PROTECTED] wrote: Hi, One rollback

Re: ** can two processes use the same rollback extent

2003-12-03 Thread Jonathan Lewis
A single block can only be 'owned' by one transaction at a time, but when a transaction commits, it may put its last undo block into that segment's 'free pool' list if there is a lot of free space left in the block so that it can be made available for new transactions . (Gaja Vaidyanatha quoted

Re: ** can two processes use the same rollback extent

2003-12-03 Thread K Gopalakrishnan
Yes Jonathan: I think that 400 byte concept came from one of the TPC benchmarks during Oracle 7 (or ORacle 6) days where the average undo size for a transcation was around 380+ bytes. So they had rounded that to 400 bytes and a maximum of 5 blocks will be linked to the freelist in the undo

Re: ** can two processes use the same rollback extent

2003-12-03 Thread Daniel Fink
IIRC, a segment will not wrap into an extent that has an active transaction in it, but rather allocate a new extent. So the answer is...it depends. Daniel Fink A Joshi wrote: Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to

Re: ** can two processes use the same rollback extent

2003-12-03 Thread Rajesh . Rao
: ** can two processes use the same rollback extent [EMAIL PROTECTED] ity.com

Re: ** can two processes use the same rollback extent

2003-12-02 Thread rahul sharma
i can answer the first part of your question.. YES, two transactions can write on the same extent of an RBS, i think the restriction is at the block level, this was true until 8i, might have changed in 9 + - Original Message - From: A Joshi To: Multiple recipients of