On Mar 27, 12:43 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Mar 27, 11:44 am, "Tarby777" <tarbs..._at_yahoo.com> wrote:
>
> > Hi all,
>
> > I hesitate to post this because it sounds silly even to me, but here
> > goes...
>
> > A colleague is adamant that with open_cursors set to the same value in
> > a 9i database and an XE database, he can complete a certain operation
> > (in our app) successfully on 9i, but runs out of cursors when he does
> > the same thing on XE. Can this be true? No-one else is using the
> > databases...
>
> > TIA
> > Tarby
>
> Without further specifics
> </rant> Why is it so difficult to post more than 'It doesn't work'?
> Why does everyone assume, there is a bunch of mindreaders here,
> whereas Oracle Technical Support requires you to provide a shitload of
> information? Even specifying the value of open_cursors is already
> evidently asked to much! Why does everyone just DUMP their issue,
> without doing ANY research of their OWN? Assuming we will do the work
> they are just a tad too lazy for? </end rant>
> one can only assume, because of an empty datadictionary, recursive SQL
> has to be performed. Obviously each recursive SQL statement requires a
> cursor.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Correction: empty dictionary *cache*
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Mar 27 2007 - 06:50:50 CDT
