seems a litlle unlikely.
Perhaps you could post the output from select o
--
Niall Litchfield
Oracle DBA
Audit Commission UKsuser,machine,program from v$session; for us and also the
select <blah> from <blah> statement that causes the problem.
"Andreas Koch" <mail_at_kochandreas.com> wrote in message
news:3B7E2D98.75B52223_at_kochandreas.com...
>
>
> Frank schrieb:
>
> > It has to do with the fact that there is more than 50 SELECT's having
their
> > resultset in the memory. If the the errors happen on a "simple select",
> > it is because it creates the 51th open cursor. It sounds to me that the
> > error will occur, for you, rather randomly,
> > based on the use of the database that day/due to different use by the
users.
>
> Problem is, this error occurs on a LOCAL database, with only SQL*Plus
> open, no other users,no other tools, after an fresh dumpfile import,
> on the first select.
>
> --
> Andreas
> Mach's mit /-\
> |o|
> \-/ gib KIDS keine Chance! ;-)
Received on Mon Aug 20 2001 - 09:05:12 CDT
