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
/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
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
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
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
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
: ** can two processes use the
same rollback extent
[EMAIL PROTECTED]
ity.com
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