RE: :Oracle question
From: Michael Nhan (mnhan_at_watson.wustl.edu)
Date: 11/17/04
- Next message: Tim Bunce: "Re: DBD::Oracle question"
- Previous message: Ron Reidy: "RE: :Oracle question"
- In reply to: Ron Reidy: "RE: :Oracle question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 17 Nov 2004 16:41:23 -0600 (CST) To: "Reidy, Ron" <Ron.Reidy@arraybiopharma.com>
Are you closing your cursor once they are no longer needed? What do you
have set in terms of cursor sharing?
Michael
> Date: Wed, 17 Nov 2004 15:38:59 -0700
> From: "Reidy, Ron" <Ron.Reidy@arraybiopharma.com>
> To: Giovanni Borri <gborri@libero.it>, dbi-users@perl.org
> Subject: RE: :Oracle question
>
> 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.
>
---//---
"He who learns must suffer. And even in our sleep,
pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
comes wisdom to us by the awful grace of God."
--- Aeschylus
- Next message: Tim Bunce: "Re: DBD::Oracle question"
- Previous message: Ron Reidy: "RE: :Oracle question"
- In reply to: Ron Reidy: "RE: :Oracle question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
