Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora-1555,please ...

RE: ora-1555,please ...

From: Rahul <rahul_at_ratelindo.co.id>
Date: Thu, 3 Aug 2000 14:41:21 +0700
Message-Id: <10578.113692@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US