Re: Rollback Segment

Bruce

> > Some of my colleagues told me that several transactions can allocate the
 same
> > rollback segment
> > simultaneously rather than waiting for one to complete before starting
> another.
>
> Yes, this is true.
>
> Each grabs its own extent of the rbs. I don't think they can share
> extents but they can share rbs.

Actually they can share the same extent if they ae starting their txn and not extending into it.

ta
tony

--

 _____       ________ / ___|Tony Jambu, Database Consultant
  /_  _        /_ __ /     |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                 |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905