RE: snapshot too old error - strange

no , i do not . Thanks DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Tue, May 28, 2002 4:53 AM To: Multiple recipients of list ORACLE-L Hello Andrey, Do you use autonomous transaction? Monday, May 27, 2002, 7:53:19 PM, you wrote: AB

RE: snapshot too old error - strange

How about DML before (ie before your query starts)? If there are massive amount of blocks to be cleaned out, this can lead to ora-1555 hth connor --- Andrey Bronfin [EMAIL PROTECTED] wrote: I meant , no one runs a DML against those tables during the running of the program. DBAndrey

RE: snapshot too old error - strange

On Mon, 27 May 2002, Nirmal Kumar Muthu Kumaran wrote: Increase rollback segment size for this transaction and make sure that the transaction will use the huge rollback segment I don't think that solution is correct. This is a common misconception about snapshot too old. Assigning your

Re: snapshot too old error - strange

I meant , no one runs a DML against those tables during the running of the program. Right. If there is no DML while your program is running, then the snapshot error is due to DML that was run earlier. The solution is simple. In the programs that do large batch inserts or updates on these

snapshot too old error - strange

Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML agains A or B . But occasionally i get

RE: snapshot too old error - strange

Title: RE: snapshot too old error - strange Increase rollback segment size for this transaction and make sure that the transaction will use the huge rollback segment hth nirmal -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Mon, May 27, 2002 15:53

RE: snapshot too old error - strange

Aan: Multiple recipients of list ORACLE-L Onderwerp: snapshot too old error - strange Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call

RE: snapshot too old error - strange

Onderwerp: snapshot too old error - strange Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML

RE: snapshot too old error - strange

-01555 messages (followed by a ORA-22924), on tables with LOBs ... HTH, Remco -Oorspronkelijk bericht- Van: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Verzonden: maandag 27 mei 2002 14:53 Aan: Multiple recipients of list ORACLE-L Onderwerp: snapshot too old error - strange Dear list

Re: snapshot too old error - strange

2 huge tables A and B Now , NO ONE carries a DML agains A or B. If no one ever does DML against those two tables, how did they end up having so many rows? Do you run large batch update or insert operations against these tables from time to time? -- Please see the official ORACLE-L FAQ:

Re: snapshot too old error - strange

Greg Moore wrote: 2 huge tables A and B Now , NO ONE carries a DML agains A or B. If no one ever does DML against those two tables, how did they end up having so many rows? Do you run large batch update or insert operations against these tables from time to time? One additional