Re: Q: ORA-01555

Jeroen van Sluisdam wrote in message <35F3E99A.B986FC49_at_vrijuit.nl>...
>Hi,
>
>This is quite normal because multiple statements can be executed
concurrently.
>Probably somebody else is bothering you with very large update or the
rollback
>segment is

Hi Jeroen

Thank you for your reply.

Unfortunately, this is not the solution - I am the one and only user of the DB, and I am not wired. Once again, when one and only user session (SQL+) executes completely the same SQL SELECT statement directly and via DBMS_SQL, the latter gives error -1555. For _certain_ tables, of course. I am not updating the database, so (as I understand), rollback segments should not be invoked... I start testing immediately after workstation startup.

There is no in-doubt transactions - then what else could impact rollback segments?

SY
Anton

>small. So try to find out through v$sqlarea or v$sql_text who is bothering
you
>at the same time
>or did you forget a commit in the stored proc and did it in sqlplus maybe
by
>exiting
>(implicit commit)
>Hope this helps,
>
>Jeroen
Received on Mon Sep 07 1998 - 11:08:53 CDT