what if the first transaction modifies a block and commits, will a second transaction
write on the extents freed by the first - those extents include the rollback for the modifyed
block...??
in that case .. the second transaction will never be able to recreate the data
modified by the first !
> ----------
> From: Surya Rao[SMTP:surya.rao_at_reuters.com]
> Sent: Thursday, August 03, 2000 10:22 PM
> To: sghosh_at_newindia.nic.in; kishore_yalla_at_indiainfo.com
> Cc: oracledba_at_quickdoc.co.uk
> Subject: Re: ora-1555,please ...
> Sensitivity: Confidential
>
> List,
>
> just curious, if the maxetents for the rbs's are VERY high and
> if they are in tablespaces with autoextend on for the underlying
> datafiles, would this problem ever occur?
>
>
>
>
> surya
> -----
>
> You can avoid this error by creating more or larger rollback segments.
> Or long-running queries can be issued when there are few concurrent
> transactions.
> Or you can obtain a shared lock on the table you are querying, thus
> prohibiting any other exclusive locks during the transaction.
>
> rgds
>
> --
> Subho
>
>
> ----- Original Message -----
> From: kishore kumar <kishore_yalla_at_indiainfo.com>
> To: <oracledba_at_quickdoc.co.uk>
> Sent: 28 July, 2000 1:06 PM
> Subject: ora-1555,please ...
>
>
> >
> >
> > hai friends...
> > when i am running long queries..getting ora error as
> > ora-1555 snapshot too error message,
> > i have tried in many ways,but still have the problem.
> > help required.
> > advance thanks to all if u sir.
> > kishore kumar
> > --------------------------------------------------------------------
> > Mind boggling features only at http://mail.indiainfo.com
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
> >
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated
> daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
> -----------------------------------------------------------------
> Visit our Internet site at http://www.reuters.com
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifically states them to be
> the views of Reuters Ltd.
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Thu Aug 03 2000 - 02:41:21 CDT
