Re: XE cursor handling

On Mar 27, 3:44 am, "Tarby777" <tarbs...@xxxxxxxxx> 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

What version of 9i are you using?
XE and 9i are are different versions therefore they will behave
differently.
If he's running out of cursors, tell him to increase the number in the
XE database.
Can he use SQL_TRACE to trace each session on the different databases
and compare the results?
As to the negative posters (trolls) just ignore them. DBA's are an
interesting breed and seem to have a "god complex".

.

Relevant Pages

  • Re: Decouple SQL queries from class in OOP design
    ... > when mixing SQL queries directly with the client classes. ... > Some of my database tables are not stable during the development ... That is done for a reason. ... or leaks cursors this is the way to catch it. ...
    (comp.object)
  • Re: Data Comparison
    ... the missing and the different records have to be ... The database being used is Oracle 9i. ... Cursors - For each of the tables, cursors can be opened and then the ... Is there a primary key? ...
    (comp.databases.oracle.misc)
  • Re: XE cursor handling
    ... a 9i database and an XE database, he can complete a certain operation ... but runs out of cursors when he does ... Sybrand Bakker ... Senior Oracle DBA ...
    (comp.databases.oracle.misc)
  • Re: Multiple problems with a running job
    ... SQL Server MVP ... > database that I know is unchanging), making it impossible for me to run ... I'm declaring the cursors as LOCAL STATIC. ... > to prevent locks. ...
    (microsoft.public.sqlserver.programming)
  • Data Comparison
    ... the missing and the different records have to be ... The database being used is Oracle 9i. ... Cursors - For each of the tables, cursors can be opened and then the ... the BULK COLLECT LIMIT option), since different records can be fetched ...
    (comp.databases.oracle.misc)