Creating snapshots to avoid ORA-01555?

From: <larionov_at_yahoo.com>
Date: Mon, 11 May 1998 19:30:23 GMT
Message-ID: <6j7jkf$9dq$1@nnrp1.dejanews.com>

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 Mon May 11 1998 - 14:30:23 CDT