RE: :Oracle question

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 15:38:59 -0700
To: "Giovanni Borri" <gborri@libero.it>, <dbi-users@perl.org>

What is your error?

Have you (or your DBA) looked into increasing max_open_cursors?

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Giovanni Borri [mailto:gborri@libero.it]
Sent: Wednesday, November 17, 2004 10:16 AM
To: dbi-users@perl.org
Subject: DBD::Oracle question

hi Tim,

I have a question for you about the use of DBD::Oracle library.
It's almost 3/4 years that we are using your library to connect to Oracle
database. I this days we are facing a problem and i don't know if it is a
problem of the library or what.
What seems to happen is that when we open a connection to the database and run
some query, after a number of query that we have run seems that we fill the
number of possible cursor per connection. The workaround we have used to not
facing the problem is to open the connection, run a defined number of query
and then close the connection. However this workaround affect the performance
of the database.
Can you please let me know.

Thanks in advance
Giovanni

 

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Relevant Pages

  • Re: Ada DB bindings and APQ
    ... >>I didn't like the use of handles for database objects. ... > will ensure that the connection will not go away until at least one query ... > things which can be made with a connection. ... That is different to ODBC. ...
    (comp.lang.ada)
  • RE: Posible to speed up query update with Apllication.screenupdati
    ... Don't change anything on the database side; the only question is the most ... You create a connection by sending the connect string to the ODBC driver. ... (multiple queries). ... You now execute the query (there are several ways in ADO but I usually ...
    (microsoft.public.excel.programming)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... It got past looking for pub.mdb, and looks like it tried to run the query ... I also tried putting the whole thing in the connection string: ... The settings for the Merant ODBC driver for ... default connect string means a jet database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... data connection file created to the database folder and created a dummy user ... connection is much faster and seems far more stable. ... incorporate OLE DB, they probably found themselves with a lot more problems ... embed a table or query name. ...
    (microsoft.public.word.mailmerge.fields)
  • Sql Server SCOPE_IDENTITY()
    ... I'm currenly in the process of writing a Database abstraction class ... SCOPE_IDENTITY query it is on the same connection as the INSERT query (which ...
    (microsoft.public.dotnet.framework.adonet)