Re: Creating snapshots to avoid ORA-01555?

From: Neil Chandler <oracle_at_tchp2.tcamuk.stratus.com>
Date: 12 May 1998 09:35:47 GMT
Message-ID: <slrn6lg5sp.lvq.oracle@tchp2.tcamuk.stratus.com>

In article <6j7jkf$9dq$1_at_nnrp1.dejanews.com>, larionov_at_yahoo.com wrote:

Misha,

This actually has nothing to do with snapshots. The error text is confusing but I would recommend that you increase the size and potentially the number of rollback segments that you are using.

Alternativley, ensure that you commit the inserts more regularly.

regards

Neil Chandler

>Dear members of the NG,
>
>In the system I maintain there are a lot of small inserts
>into a table and at the same time every hour there is running
>"select" query on the same table. Of course, I am getting
>a lot of ORA-01555 errors.
>
>I am thinking of using the updatable snapshots to avoid ORA-01555.
>Somebody done this? Does it really help? Does it hurt the performance?
>
>Any help would be much appreciated!
>
>I am using Oracle 8.03 Server.
>
>Thank you.
>
>Misha.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue May 12 1998 - 04:35:47 CDT