cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle

Re: [cx-oracle-users] binding datetime in query

[Rizzuto, R. <Ray...@si...>]

I did that test, and the to_date() on a string was no faster than passing the native datetime object.   I'm quite glad that the information I was given was incorrect, and cx_Oracle is working as expected.

-----Original Message-----
From: Mark Harrison [mailto:mh...@pi...]
Sent: Monday, February 14, 2011 3:41 PM
To: cx-...@li...
Subject: Re: [cx-oracle-users] binding datetime in query

On 2/14/11 12:32 PM, Rizzuto, Raymond wrote:
> I suspect the issue may be that Oracle is converting the Date column to a datetime, and comparing each row with the datetime I passed in the bound variable.
>
> I tried to use datetime().date(), but cxOracle seems to still convert that to a datetime.

what happens if you use to_date() in your query string, and pass in the parameter as
a string?

This will confirm that the execution plan is indeed using a date type,
and you can see if the optimizer is still skipping over the index on
the date column.

if so, then there's some db or query tuning that needs to be done; if not,
the problem is verified to be one of date conversion on the client side.

hth!





IMPORTANT: The information contained in this email and/or its attachments is confidential. If you are not the intended recipient, please notify the sender immediately by reply and immediately delete this message and all its attachments. Any review, use, reproduction, disclosure or dissemination of this message or any attachment by an unintended recipient is strictly prohibited. Neither this message nor any attachment is intended as or should be construed as an offer, solicitation or recommendation to buy or sell any security or other financial instrument. Neither the sender, his or her employer nor any of their respective affiliates makes any warranties as to the completeness or accuracy of any of the information contained herein or that this message or any of its attachments is free of viruses.

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Marco De P. <dep...@gm...>]

>
> On Wed, Feb 16, 2011 at 7:57 PM, Mark Harrison <mh...@pi...> wrote:
>
>> On 2/16/11 8:54 AM, Marco De Paoli wrote:
>> > everything works if I force the rebuild of a file named tests.pyc in a
>> django folder
>> > (via rm tests.pyc or via touch tests.pyc)
>> >
>> > if the file is already there I obtain "Unable to acquire Oracle
>> environment handle"
>> >
>> > Maybe it's an issue on the django side, but I can't undestand what could
>> be wrong...
>> >
>> > django is a pure python package and the question is: how can django
>> influence the OCIEnvNlsCreate call in Environment.c that, as far as I know,
>> doesn't get any login but just initialize a client data structure?!?
>>
>>
>> that one is weird.  maybe you can do something like this:
>>
>> edit one or more of the django files, and put in
>>
>> conn=cx_Oracle.connect(...)
>>
>> calls.
>>
>> hopefully, the one at the very top of the first django file will be
>> successful.
>> eventually you will hit one that fails.  then you can move the connect
>> lines
>> around to narrow down where the bad thing is happening.
>>
>
I injected conn=cx_Oracle.connect(...) all around django sources

sometimes it works, other times it doesn't: I save a django file and
everything works fine, I try to lunch again and it doesn't work anymore
then I remove a pyc file and it works again, I lunch again and it works, the
third time it doesn't work anymore

I'm sorry I cant' give you more precise infos... but I feel like I'm chasing
ghosts :(

Marco

Re: [cx-oracle-users] Type-o in BUILD.txt of the source package (cx_Oracle-5.0)

[Joe R. <go...@gm...>]

OK, thanks.

On Thu, Feb 17, 2011 at 10:48 AM, Anthony Tuininga
<ant...@gm...> wrote:
> Thanks. That was already fixed in 5.0.1, though. :-)
>
> Anthony
>
> On Thu, Feb 17, 2011 at 8:41 AM, Joe Riopel <go...@gm...> wrote:
>> I was just building cx_Oracle on a Linux system and noticed a type-o
>> in the cx_Oracle-5.0 directory. One of the steps says:
>>
>>   Steps:
>>   ------
>>   cd $ORACLE_HOME
>>   ln -s libclntsh.so.x.x linbclntsh.so
>>
>>
>> The "linbclntsh.so" should be "libclntsh.so".
>>
>>
>> Thanks,
>> Joe
>>
>> ------------------------------------------------------------------------------
>> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
>> Pinpoint memory and threading errors before they happen.
>> Find and fix more than 250 security defects in the development cycle.
>> Locate bottlenecks in serial and parallel code that limit performance.
>> http://p.sf.net/sfu/intel-dev2devfeb
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Type-o in BUILD.txt of the source package (cx_Oracle-5.0)

[Anthony T. <ant...@gm...>]

Thanks. That was already fixed in 5.0.1, though. :-)

Anthony

On Thu, Feb 17, 2011 at 8:41 AM, Joe Riopel <go...@gm...> wrote:
> I was just building cx_Oracle on a Linux system and noticed a type-o
> in the cx_Oracle-5.0 directory. One of the steps says:
>
>   Steps:
>   ------
>   cd $ORACLE_HOME
>   ln -s libclntsh.so.x.x linbclntsh.so
>
>
> The "linbclntsh.so" should be "libclntsh.so".
>
>
> Thanks,
> Joe
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Type-o in BUILD.txt of the source package (cx_Oracle-5.0)

[Joe R. <go...@gm...>]

I was just building cx_Oracle on a Linux system and noticed a type-o
in the cx_Oracle-5.0 directory. One of the steps says:

   Steps:
   ------
   cd $ORACLE_HOME
   ln -s libclntsh.so.x.x linbclntsh.so


The "linbclntsh.so" should be "libclntsh.so".


Thanks,
Joe

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Marco De P. <dep...@gm...>]

Thanks, I will try to follow your advice

I'll let you know

Marco

On Wed, Feb 16, 2011 at 7:57 PM, Mark Harrison <mh...@pi...> wrote:

> On 2/16/11 8:54 AM, Marco De Paoli wrote:
> > everything works if I force the rebuild of a file named tests.pyc in a
> django folder
> > (via rm tests.pyc or via touch tests.pyc)
> >
> > if the file is already there I obtain "Unable to acquire Oracle
> environment handle"
> >
> > Maybe it's an issue on the django side, but I can't undestand what could
> be wrong...
> >
> > django is a pure python package and the question is: how can django
> influence the OCIEnvNlsCreate call in Environment.c that, as far as I know,
> doesn't get any login but just initialize a client data structure?!?
>
>
> that one is weird.  maybe you can do something like this:
>
> edit one or more of the django files, and put in
>
> conn=cx_Oracle.connect(...)
>
> calls.
>
> hopefully, the one at the very top of the first django file will be
> successful.
> eventually you will hit one that fails.  then you can move the connect
> lines
> around to narrow down where the bad thing is happening.
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Logging-in without password

[Damien T. <dt...@ba...>]

Hello,

I am trying to login to a local Oracle instance without a password. Our 
DBA has setup our Linux environment (ORACLE_HOME, ORACLE_SID, etc.) such 
that all I have to do is type the following on the command line:

sqlplus /

And I am automatically logged-in to the instance I want.

When I try to do the same thing from within python, I connect using the 
following:

con = cx_Oracle.connect()

I don't get any errors, but the dsn (from printing the contents of 
con.dsn) is None.

If I try to specifiy a dsn:

con = cx_Oracle.connect(dsn = 'XYZ')

I get the following error:

x_Oracle.DatabaseError: ORA-01017: invalid username/password; logon denied

So, something is not right, but it is not clear to me what that is. Can 
anyone offer any insight? Is it possible to login to an Oracle instance 
with cx_Oracle without supplying a username/password?

Thanks for your help.

-- 
Damien Tougas
Programmer/Analyst
Internet Software Services
Bates College

Re: [cx-oracle-users] cx_Oracle execute() Performance

[Baublitz, B. <Bri...@ph...>]

-----Original Message-----
From: Mark Harrison
Sent: Wednesday, February 16, 2011 2:04 PM

>do you get the delay if you turn off autocommit?
>I think by default sqldeveloper doesn't autocommit.

Yes, I encounter the same issue when turning off autocommit.

Re: [cx-oracle-users] cx_Oracle execute() Performance

[Andreas M. <and...@we...>]

Hi Brian,

I don't know the details, but my guess is:

As soon as you use python some internal type conversion goes wrong
causing the optimizer using the wrong plan while updating the
row. The same can be true using bind variables vs. literals in
sql statements. 

Try to get the query plan for the statement.

Best regards
Andreas Mock


> -----Original Message-----
> From: Baublitz, Brian [mailto:Bri...@ph...]
> Sent: Wednesday, February 16, 2011 7:44 PM
> To: cx-...@li...
> Subject: [cx-oracle-users] cx_Oracle execute() Performance
> 
> I am having an odd performance issue when executing an update statement
> through cursor.execute() and could really use some insight.  The update
> statement is very basic and the WHERE clause matches the one index on
> the table so the execution time should be sub-second.  In fact, when I
> run the update statement through Oracle SQL Developer on the same server
> it completes in 0.001 seconds.  However, when I run the same statement
> through cursor.execute() it consistently takes over 2 seconds.
> 
> I moved the update statement to a procedure and executed it using
> cursor.callproc() and still experience the 2 second delay.  As before,
> executing the procedure through Oracle SQL Developer is sub-second.
> 
> I also tried batching a set of 249 updates and using
> cursor.executemany() yet still encounter the same delay.  The batch
> update takes about 10 minutes using cursor.executemany(), but only two
> seconds through Oracle SQL Developer.
> 
> One interesting thing is that inserting a record into the same table
> using cursor.execute() and cursor.callproc() does not experience the 2
> second delay.
> 
> Oracle Version:  11.2.0.1.0
> Python Version: 2.6
> Cx_Oracle Version: 5.0.4
> OS: Windows Server Enterprise 2003 SP2
> 
> ------------- Sample Code ------------------
> import cx_Oracle
> import time
> 
> con = cx_Oracle.connect("XXX", "XXX", "XXX")
> con.autocommit = 1
> print time.asctime( time.localtime(time.time()) ), "Oracle Version: ",
> con.version
> print time.asctime( time.localtime(time.time()) ), "Autocommit: " +
> str(con.autocommit)
> 
> curRoute = con.cursor()
> 
> print time.asctime( time.localtime(time.time()) ), "Update Started."
> curRoute.callproc("updateNeighbor", ('20913', 'US', 1, '89898', 'US',
> 12, 8))
> print time.asctime( time.localtime(time.time()) ), "Update Complete"
> 
> print time.asctime( time.localtime(time.time()) ), "Insert Started."
> curRoute.callproc("insertNeighbor", ('20913', 'US', 301, '78787', 'US',
> 12, 8))
> print time.asctime( time.localtime(time.time()) ), "Insert Complete"
> 
> curRoute.close()
> con.close()
> 
> print time.asctime( time.localtime(time.time()) ), "Processing Complete"
> 
> ------------- Output From Sample Code ------------------
> Wed Feb 16 13:38:23 2011 Oracle Version:  11.2.0.1.0
> Wed Feb 16 13:38:23 2011 Autocommit: 1
> Wed Feb 16 13:38:23 2011 Update Started.
> Wed Feb 16 13:38:26 2011 Update Complete
> Wed Feb 16 13:38:26 2011 Insert Started.
> Wed Feb 16 13:38:26 2011 Insert Complete
> Wed Feb 16 13:38:26 2011 Processing Complete
> 
> 
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] cx_Oracle execute() Performance

[Mark H. <mh...@pi...>]

On 2/16/11 10:44 AM, Baublitz, Brian wrote:

> I also tried batching a set of 249 updates and using
> cursor.executemany() yet still encounter the same delay.  The batch
> update takes about 10 minutes using cursor.executemany(), but only two
> seconds through Oracle SQL Developer.

do you get the delay if you turn off autocommit?
I think by default sqldeveloper doesn't autocommit.

[cx-oracle-users] cx_Oracle execute() Performance

[Baublitz, B. <Bri...@ph...>]

I am having an odd performance issue when executing an update statement
through cursor.execute() and could really use some insight.  The update
statement is very basic and the WHERE clause matches the one index on
the table so the execution time should be sub-second.  In fact, when I
run the update statement through Oracle SQL Developer on the same server
it completes in 0.001 seconds.  However, when I run the same statement
through cursor.execute() it consistently takes over 2 seconds.

I moved the update statement to a procedure and executed it using
cursor.callproc() and still experience the 2 second delay.  As before,
executing the procedure through Oracle SQL Developer is sub-second.

I also tried batching a set of 249 updates and using
cursor.executemany() yet still encounter the same delay.  The batch
update takes about 10 minutes using cursor.executemany(), but only two
seconds through Oracle SQL Developer.

One interesting thing is that inserting a record into the same table
using cursor.execute() and cursor.callproc() does not experience the 2
second delay.

Oracle Version:  11.2.0.1.0
Python Version: 2.6
Cx_Oracle Version: 5.0.4
OS: Windows Server Enterprise 2003 SP2

------------- Sample Code ------------------
import cx_Oracle
import time

con = cx_Oracle.connect("XXX", "XXX", "XXX")
con.autocommit = 1
print time.asctime( time.localtime(time.time()) ), "Oracle Version: ",
con.version
print time.asctime( time.localtime(time.time()) ), "Autocommit: " +
str(con.autocommit)

curRoute = con.cursor()

print time.asctime( time.localtime(time.time()) ), "Update Started."
curRoute.callproc("updateNeighbor", ('20913', 'US', 1, '89898', 'US',
12, 8))
print time.asctime( time.localtime(time.time()) ), "Update Complete"

print time.asctime( time.localtime(time.time()) ), "Insert Started."
curRoute.callproc("insertNeighbor", ('20913', 'US', 301, '78787', 'US',
12, 8))
print time.asctime( time.localtime(time.time()) ), "Insert Complete"

curRoute.close()
con.close()

print time.asctime( time.localtime(time.time()) ), "Processing Complete"

------------- Output From Sample Code ------------------
Wed Feb 16 13:38:23 2011 Oracle Version:  11.2.0.1.0
Wed Feb 16 13:38:23 2011 Autocommit: 1
Wed Feb 16 13:38:23 2011 Update Started.
Wed Feb 16 13:38:26 2011 Update Complete
Wed Feb 16 13:38:26 2011 Insert Started.
Wed Feb 16 13:38:26 2011 Insert Complete
Wed Feb 16 13:38:26 2011 Processing Complete

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Mark H. <mh...@pi...>]

On 2/16/11 8:54 AM, Marco De Paoli wrote:
> everything works if I force the rebuild of a file named tests.pyc in a django folder
> (via rm tests.pyc or via touch tests.pyc)
>
> if the file is already there I obtain "Unable to acquire Oracle environment handle"
>
> Maybe it's an issue on the django side, but I can't undestand what could be wrong...
>
> django is a pure python package and the question is: how can django influence the OCIEnvNlsCreate call in Environment.c that, as far as I know, doesn't get any login but just initialize a client data structure?!?


that one is weird.  maybe you can do something like this:

edit one or more of the django files, and put in

conn=cx_Oracle.connect(...)

calls.

hopefully, the one at the very top of the first django file will be successful.
eventually you will hit one that fails.  then you can move the connect lines
around to narrow down where the bad thing is happening.

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Marco De P. <dep...@gm...>]

On Wed, Feb 16, 2011 at 5:45 PM, Mark Harrison <mh...@pi...> wrote:

> > Eventually I've tried tu use cx_Oracle from svn trunk: check-out and
> build are ok but I can't execute the install, this is the message
>
> maybe there's some versionitis with the latest svn trunk and py 2.4?
>
> Here's a couple of things to try:
>
>
> - try installing from a released tar file
>

cx_Oracle 5.0.4 source package build and install are ok
maybe something introduced recently?


> - try installing from one of the older released tar files
>   (in case there's some 2.4 breakage)
> - install or build a newer python, and one of the tar files above
>

> >
> > [root@bagvapp trunk]# python setup.py install
> > running install
> > running bdist_egg
> > running egg_info
> > writing cx_Oracle.egg-info/PKG-INFO
> > writing top-level names to cx_Oracle.egg-info/top_level.txt
> > writing dependency_links to cx_Oracle.egg-info/dependency_links.txt
> > Traceback (most recent call last):
> >    File "setup.py", line 368, in ?
> >      classifiers = classifiers)
> >    File "/usr/lib/python2.4/distutils/core.py", line 149, in setup
> >      dist.run_commands()
> >    File "/usr/lib/python2.4/distutils/dist.py", line 946, in run_commands
> >      self.run_command(cmd)
> >    File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
> >      cmd_obj.run()
> >    File "/usr/lib/python2.4/site-packages/setuptools/command/install.py",
> line 76, in run
> >      self.do_egg_install()
> >    File "/usr/lib/python2.4/site-packages/setuptools/command/install.py",
> line 92, in do_egg_install
> >      self.run_command('bdist_egg')
> >    File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
> >      self.distribution.run_command(command)
> >    File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
> >      cmd_obj.run()
> >    File
> "/usr/lib/python2.4/site-packages/setuptools/command/bdist_egg.py", line
> 167, in run
> >      self.run_command("egg_info")
> >    File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
> >      self.distribution.run_command(command)
> >    File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
> >      cmd_obj.run()
> >    File
> "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 171,
> in run
> >      self.find_sources()
> >    File
> "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 252,
> in find_sources
> >      mm.run()
> >    File
> "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 306,
> in run
> >      self.add_defaults()
> >    File
> "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 333,
> in add_defaults
> >      rcfiles = list(walk_revctrl())
> >    File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py",
> line 45, in walk_revctrl
> >      for item in ep.load()(dirname):
> >    File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py",
> line 52, in _default_revctrl
> >      for path in finder(dirname,path):
> >    File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py",
> line 98, in entries_finder
> >      log.warn("unrecognized .svn/entries format in %s", dirname)
> > NameError: global name 'log' is not defined
> >
>

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Marco De P. <dep...@gm...>]

everything works if I force the rebuild of a file named tests.pyc in a
django folder
(via rm tests.pyc or via touch tests.pyc)

if the file is already there I obtain "Unable to acquire Oracle environment
handle"

Maybe it's an issue on the django side, but I can't undestand what could be
wrong...

django is a pure python package and the question is: how can django
influence the OCIEnvNlsCreate call in Environment.c that, as far as I know,
doesn't get any login but just initialize a client data structure?!?

Marco

On Wed, Feb 16, 2011 at 9:18 AM, Marco De Paoli <dep...@gm...> wrote:

> First of all, thanks very much for your hints
>
> Sorry, maybe I have not been clear: the problem is not systematic
>
> same xterm, same user, same shell, same environment...
> sometimes it works, sometimes it doesn't
>
> Then I have rebuilt and installed from 5.0.4 sources but the problem is the
> same
>
> Eventually I've tried tu use cx_Oracle from svn trunk: check-out and build
> are ok but I can't execute the install, this is the message
>
> [root@bagvapp trunk]# python setup.py install
> running install
> running bdist_egg
> running egg_info
> writing cx_Oracle.egg-info/PKG-INFO
> writing top-level names to cx_Oracle.egg-info/top_level.txt
> writing dependency_links to cx_Oracle.egg-info/dependency_links.txt
> Traceback (most recent call last):
>   File "setup.py", line 368, in ?
>     classifiers = classifiers)
>   File "/usr/lib/python2.4/distutils/core.py", line 149, in setup
>     dist.run_commands()
>   File "/usr/lib/python2.4/distutils/dist.py", line 946, in run_commands
>     self.run_command(cmd)
>   File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
>     cmd_obj.run()
>   File "/usr/lib/python2.4/site-packages/setuptools/command/install.py",
> line 76, in run
>     self.do_egg_install()
>   File "/usr/lib/python2.4/site-packages/setuptools/command/install.py",
> line 92, in do_egg_install
>     self.run_command('bdist_egg')
>   File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
>     self.distribution.run_command(command)
>   File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
>     cmd_obj.run()
>   File "/usr/lib/python2.4/site-packages/setuptools/command/bdist_egg.py",
> line 167, in run
>     self.run_command("egg_info")
>   File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
>     self.distribution.run_command(command)
>   File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
>     cmd_obj.run()
>   File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
> line 171, in run
>     self.find_sources()
>   File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
> line 252, in find_sources
>     mm.run()
>   File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
> line 306, in run
>     self.add_defaults()
>   File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
> line 333, in add_defaults
>     rcfiles = list(walk_revctrl())
>   File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line
> 45, in walk_revctrl
>     for item in ep.load()(dirname):
>   File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line
> 52, in _default_revctrl
>     for path in finder(dirname,path):
>   File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line
> 98, in entries_finder
>     log.warn("unrecognized .svn/entries format in %s", dirname)
> NameError: global name 'log' is not defined
>
> Marco
>
>
> On Tue, Feb 15, 2011 at 10:47 PM, Anthony Tuininga <
> ant...@gm...> wrote:
>
>> On Tue, Feb 15, 2011 at 12:02 PM, Mark Harrison <mh...@pi...> wrote:
>> > On 2/15/11 9:33 AM, Anthony Tuininga wrote:
>> >> Hi,
>> >>
>> >> This has always been some problem with a missing value for ORACLE_HOME
>> >> and/or LD_LIBRARY_PATH. Check your environment variables. Since this
>> >  idea?
>> >
>> >>> I wolud be gratefull for any hint
>> >
>> > Ugh, environment variables, what a pain.
>> > Here's how I installed so that no environment variables are required:
>> >
>> >
>> http://stackoverflow.com/questions/764871/installing-oracle-instantclient-on-linux-without-setting-environment-variables
>>
>> Thanks for that. Using the default values across the board and not
>> having to set custom values for environment variables can be highly
>> convenient, especially for the web server case where its more work to
>> set its environment. :-)
>>
>> Anthony
>>
>>
>> ------------------------------------------------------------------------------
>> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
>> Pinpoint memory and threading errors before they happen.
>> Find and fix more than 250 security defects in the development cycle.
>> Locate bottlenecks in serial and parallel code that limit performance.
>> http://p.sf.net/sfu/intel-dev2devfeb
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>
>

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Mark H. <mh...@pi...>]

On 2/16/11 12:18 AM, Marco De Paoli wrote:
> First of all, thanks very much for your hints
>
> Sorry, maybe I have not been clear: the problem is not systematic
>
> same xterm, same user, same shell, same environment...
> sometimes it works, sometimes it doesn't
>
> Then I have rebuilt and installed from 5.0.4 sources but the problem is the same
>
> Eventually I've tried tu use cx_Oracle from svn trunk: check-out and build are ok but I can't execute the install, this is the message

maybe there's some versionitis with the latest svn trunk and py 2.4?

Here's a couple of things to try:


- try installing from a released tar file
- try installing from one of the older released tar files
   (in case there's some 2.4 breakage)
- install or build a newer python, and one of the tar files above

>
> [root@bagvapp trunk]# python setup.py install
> running install
> running bdist_egg
> running egg_info
> writing cx_Oracle.egg-info/PKG-INFO
> writing top-level names to cx_Oracle.egg-info/top_level.txt
> writing dependency_links to cx_Oracle.egg-info/dependency_links.txt
> Traceback (most recent call last):
>    File "setup.py", line 368, in ?
>      classifiers = classifiers)
>    File "/usr/lib/python2.4/distutils/core.py", line 149, in setup
>      dist.run_commands()
>    File "/usr/lib/python2.4/distutils/dist.py", line 946, in run_commands
>      self.run_command(cmd)
>    File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
>      cmd_obj.run()
>    File "/usr/lib/python2.4/site-packages/setuptools/command/install.py", line 76, in run
>      self.do_egg_install()
>    File "/usr/lib/python2.4/site-packages/setuptools/command/install.py", line 92, in do_egg_install
>      self.run_command('bdist_egg')
>    File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
>      self.distribution.run_command(command)
>    File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
>      cmd_obj.run()
>    File "/usr/lib/python2.4/site-packages/setuptools/command/bdist_egg.py", line 167, in run
>      self.run_command("egg_info")
>    File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
>      self.distribution.run_command(command)
>    File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
>      cmd_obj.run()
>    File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 171, in run
>      self.find_sources()
>    File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 252, in find_sources
>      mm.run()
>    File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 306, in run
>      self.add_defaults()
>    File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py", line 333, in add_defaults
>      rcfiles = list(walk_revctrl())
>    File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line 45, in walk_revctrl
>      for item in ep.load()(dirname):
>    File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line 52, in _default_revctrl
>      for path in finder(dirname,path):
>    File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line 98, in entries_finder
>      log.warn("unrecognized .svn/entries format in %s", dirname)
> NameError: global name 'log' is not defined
>
> Marco
>
> On Tue, Feb 15, 2011 at 10:47 PM, Anthony Tuininga <ant...@gm... <mailto:ant...@gm...>> wrote:
>
>     On Tue, Feb 15, 2011 at 12:02 PM, Mark Harrison <mh...@pi... <mailto:mh...@pi...>> wrote:
>      > On 2/15/11 9:33 AM, Anthony Tuininga wrote:
>      >> Hi,
>      >>
>      >> This has always been some problem with a missing value for ORACLE_HOME
>      >> and/or LD_LIBRARY_PATH. Check your environment variables. Since this
>      >  idea?
>      >
>      >>> I wolud be gratefull for any hint
>      >
>      > Ugh, environment variables, what a pain.
>      > Here's how I installed so that no environment variables are required:
>      >
>      > http://stackoverflow.com/questions/764871/installing-oracle-instantclient-on-linux-without-setting-environment-variables
>
>     Thanks for that. Using the default values across the board and not
>     having to set custom values for environment variables can be highly
>     convenient, especially for the web server case where its more work to
>     set its environment. :-)
>
>     Anthony
>
>     ------------------------------------------------------------------------------
>     The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
>     Pinpoint memory and threading errors before they happen.
>     Find and fix more than 250 security defects in the development cycle.
>     Locate bottlenecks in serial and parallel code that limit performance.
>     http://p.sf.net/sfu/intel-dev2devfeb
>     _______________________________________________
>     cx-oracle-users mailing list
>     cx-...@li... <mailto:cx-...@li...>
>     https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
>
>
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Marco De P. <dep...@gm...>]

First of all, thanks very much for your hints

Sorry, maybe I have not been clear: the problem is not systematic

same xterm, same user, same shell, same environment...
sometimes it works, sometimes it doesn't

Then I have rebuilt and installed from 5.0.4 sources but the problem is the
same

Eventually I've tried tu use cx_Oracle from svn trunk: check-out and build
are ok but I can't execute the install, this is the message

[root@bagvapp trunk]# python setup.py install
running install
running bdist_egg
running egg_info
writing cx_Oracle.egg-info/PKG-INFO
writing top-level names to cx_Oracle.egg-info/top_level.txt
writing dependency_links to cx_Oracle.egg-info/dependency_links.txt
Traceback (most recent call last):
  File "setup.py", line 368, in ?
    classifiers = classifiers)
  File "/usr/lib/python2.4/distutils/core.py", line 149, in setup
    dist.run_commands()
  File "/usr/lib/python2.4/distutils/dist.py", line 946, in run_commands
    self.run_command(cmd)
  File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
    cmd_obj.run()
  File "/usr/lib/python2.4/site-packages/setuptools/command/install.py",
line 76, in run
    self.do_egg_install()
  File "/usr/lib/python2.4/site-packages/setuptools/command/install.py",
line 92, in do_egg_install
    self.run_command('bdist_egg')
  File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
    self.distribution.run_command(command)
  File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
    cmd_obj.run()
  File "/usr/lib/python2.4/site-packages/setuptools/command/bdist_egg.py",
line 167, in run
    self.run_command("egg_info")
  File "/usr/lib/python2.4/distutils/cmd.py", line 333, in run_command
    self.distribution.run_command(command)
  File "/usr/lib/python2.4/distutils/dist.py", line 966, in run_command
    cmd_obj.run()
  File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
line 171, in run
    self.find_sources()
  File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
line 252, in find_sources
    mm.run()
  File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
line 306, in run
    self.add_defaults()
  File "/usr/lib/python2.4/site-packages/setuptools/command/egg_info.py",
line 333, in add_defaults
    rcfiles = list(walk_revctrl())
  File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line
45, in walk_revctrl
    for item in ep.load()(dirname):
  File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line
52, in _default_revctrl
    for path in finder(dirname,path):
  File "/usr/lib/python2.4/site-packages/setuptools/command/sdist.py", line
98, in entries_finder
    log.warn("unrecognized .svn/entries format in %s", dirname)
NameError: global name 'log' is not defined

Marco

On Tue, Feb 15, 2011 at 10:47 PM, Anthony Tuininga <
ant...@gm...> wrote:

> On Tue, Feb 15, 2011 at 12:02 PM, Mark Harrison <mh...@pi...> wrote:
> > On 2/15/11 9:33 AM, Anthony Tuininga wrote:
> >> Hi,
> >>
> >> This has always been some problem with a missing value for ORACLE_HOME
> >> and/or LD_LIBRARY_PATH. Check your environment variables. Since this
> >  idea?
> >
> >>> I wolud be gratefull for any hint
> >
> > Ugh, environment variables, what a pain.
> > Here's how I installed so that no environment variables are required:
> >
> >
> http://stackoverflow.com/questions/764871/installing-oracle-instantclient-on-linux-without-setting-environment-variables
>
> Thanks for that. Using the default values across the board and not
> having to set custom values for environment variables can be highly
> convenient, especially for the web server case where its more work to
> set its environment. :-)
>
> Anthony
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Anthony T. <ant...@gm...>]

On Tue, Feb 15, 2011 at 12:02 PM, Mark Harrison <mh...@pi...> wrote:
> On 2/15/11 9:33 AM, Anthony Tuininga wrote:
>> Hi,
>>
>> This has always been some problem with a missing value for ORACLE_HOME
>> and/or LD_LIBRARY_PATH. Check your environment variables. Since this
>  idea?
>
>>> I wolud be gratefull for any hint
>
> Ugh, environment variables, what a pain.
> Here's how I installed so that no environment variables are required:
>
> http://stackoverflow.com/questions/764871/installing-oracle-instantclient-on-linux-without-setting-environment-variables

Thanks for that. Using the default values across the board and not
having to set custom values for environment variables can be highly
convenient, especially for the web server case where its more work to
set its environment. :-)

Anthony

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Mark H. <mh...@pi...>]

On 2/15/11 9:33 AM, Anthony Tuininga wrote:
> Hi,
>
> This has always been some problem with a missing value for ORACLE_HOME
> and/or LD_LIBRARY_PATH. Check your environment variables. Since this
  idea?

>> I wolud be gratefull for any hint

Ugh, environment variables, what a pain.
Here's how I installed so that no environment variables are required:

http://stackoverflow.com/questions/764871/installing-oracle-instantclient-on-linux-without-setting-environment-variables

Re: [cx-oracle-users] Unable to acquire Oracle environment handle

[Anthony T. <ant...@gm...>]

Hi,

This has always been some problem with a missing value for ORACLE_HOME
and/or LD_LIBRARY_PATH. Check your environment variables. Since this
is running in Django, a web server, sometimes these environment
variables are not set globally. You can always "force" this issue by
issuing calls like this prior to creating a connection with cx_Oracle.

os.environ["ORACLE_HOME"] = /the/path/to/your/oracle/home

LD_LIBRARY_PATH (or equivalent method of setting the shared library
search path) __must__ be set prior to starting a process so you'll
need to make sure that is done globally or in your web server
configuration files somewhere.

Hope that helps.

Anthony

On Tue, Feb 15, 2011 at 9:20 AM, Marco De Paoli <dep...@gm...> wrote:
> Hi,
> the problem is not systematic and I wasn't able to infere a "pattern" for it
>
> CentoOS 5.4
> oracle-instantclient-basic-10.2.0.4-1.i386.zip
> oracle-instantclient-devel-10.2.0.4-1.i386.zip
> cx_Oracle 5.4
> Django 1.2.5
>
> any idea?
> I wolud be gratefull for any hint
>
> Marco
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

[cx-oracle-users] Unable to acquire Oracle environment handle

[Marco De P. <dep...@gm...>]

Hi,
the problem is not systematic and I wasn't able to infere a "pattern" for it

CentoOS 5.4
oracle-instantclient-basic-10.2.0.4-1.i386.zip
oracle-instantclient-devel-10.2.0.4-1.i386.zip
cx_Oracle 5.4
Django 1.2.5

any idea?
I wolud be gratefull for any hint

Marco

Re: [cx-oracle-users] binding datetime in query

[Mark H. <mh...@pi...>]

On 2/14/11 12:32 PM, Rizzuto, Raymond wrote:
> I suspect the issue may be that Oracle is converting the Date column to a datetime, and comparing each row with the datetime I passed in the bound variable.
>
> I tried to use datetime().date(), but cxOracle seems to still convert that to a datetime.

what happens if you use to_date() in your query string, and pass in the parameter as
a string?

This will confirm that the execution plan is indeed using a date type,
and you can see if the optimizer is still skipping over the index on
the date column.

if so, then there's some db or query tuning that needs to be done; if not,
the problem is verified to be one of date conversion on the client side.

hth!

Re: [cx-oracle-users] binding datetime in query

[Chris A. <chr...@ub...>]

Issued by UBS AG or affiliates to professional investors only.
Product of a sales/trading desk and not the Research Department. 
For the full published research report, including important 
disclosures, go to the ResearchWeb at www.ubs.com.  Opinions 
expressed may differ from those of other divisions of UBS, including 
Research. 
UBS may trade as principal in instruments identified herein and may 
accumulate/have accumulated a long/short position in instruments or 
derivatives thereof. UBS has policies designed to manage conflicts of 
interest. This e-mail is not an official confirmation of terms and 
unless stated, is not a personal recommendation, offer or 
solicitation to buy or sell. Any prices or quotations contained 
herein are indicative only and not for valuation purposes. 
Communications may be monitored.

Statement of Risk
Options, structured derivative products and futures are not suitable
for all investors, and trading in these instruments is considered 
risky and may be appropriate only for sophisticated investors. Past 
performance is not necessarily indicative of future results. Various 
theoretical explanations of the risks associated with these 
instruments have been published. Prior to buying or selling an 
option, and for the complete risks relating to options, you must 
receive a copy of "The Characteristics and Risks of Standardized 
Options." You may read the document at 
http://www.theocc.com/publications/risks/riskchap1.jsp
or ask your salesperson for a copy.

UBS 2011.  All rights reserved.
Intended for recipient only and not for further distribution without
the consent of UBS.

UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.

Re: [cx-oracle-users] binding datetime in query

[Rizzuto, R. <Ray...@si...>]

I suspect the issue may be that Oracle is converting the Date column to a datetime, and comparing each row with the datetime I passed in the bound variable.

I tried to use datetime().date(), but cxOracle seems to still convert that to a datetime.

From: Rizzuto, Raymond
Sent: Monday, February 14, 2011 2:13 PM
To: 'cx-...@li...'
Subject: binding datetime in query

I am issuing a query to our database, with a where clause that is comparing a Date column to a parameter.  The parameter is bound to a datetime object.  I am using version 5.02.  Will the datetime object be sent as a native Oracle date type, or will it be sent as a string?  If the latter, what format would it be in?

The reason I ask is that the DBA's think the query is not performing well, and there is concern that the optimizer is not using the index on the date column due to the way I am passing in the date.

The date parameter is being passed via a dictionary, like so:

params["p_order_date"] = orderDate.datetime()  # returns a datetime type from a custom class
.
.
cursor.execute(query, params)

The query string passed to execute is built dynamically, and executed once.

Ray

________________________________
Ray Rizzuto
ray...@si...<mailto:ray...@si...>
Susquehanna International Group
(610)747-2336 (W)
(215)776-3780 (C)


________________________________
IMPORTANT: The information contained in this email and/or its attachments is confidential. If you are not the intended recipient, please notify the sender immediately by reply and immediately delete this message and all its attachments. Any review, use, reproduction, disclosure or dissemination of this message or any attachment by an unintended recipient is strictly prohibited. Neither this message nor any attachment is intended as or should be construed as an offer, solicitation or recommendation to buy or sell any security or other financial instrument. Neither the sender, his or her employer nor any of their respective affiliates makes any warranties as to the completeness or accuracy of any of the information contained herein or that this message or any of its attachments is free of viruses.

[cx-oracle-users] binding datetime in query

[Rizzuto, R. <Ray...@si...>]

I am issuing a query to our database, with a where clause that is comparing a Date column to a parameter.  The parameter is bound to a datetime object.  I am using version 5.02.  Will the datetime object be sent as a native Oracle date type, or will it be sent as a string?  If the latter, what format would it be in?

The reason I ask is that the DBA's think the query is not performing well, and there is concern that the optimizer is not using the index on the date column due to the way I am passing in the date.

The date parameter is being passed via a dictionary, like so:

params["p_order_date"] = orderDate.datetime()  # returns a datetime type from a custom class
.
.
cursor.execute(query, params)

The query string passed to execute is built dynamically, and executed once.

Ray

________________________________
Ray Rizzuto
ray...@si...<mailto:ray...@si...>
Susquehanna International Group
(610)747-2336 (W)
(215)776-3780 (C)


________________________________
IMPORTANT: The information contained in this email and/or its attachments is confidential. If you are not the intended recipient, please notify the sender immediately by reply and immediately delete this message and all its attachments. Any review, use, reproduction, disclosure or dissemination of this message or any attachment by an unintended recipient is strictly prohibited. Neither this message nor any attachment is intended as or should be construed as an offer, solicitation or recommendation to buy or sell any security or other financial instrument. Neither the sender, his or her employer nor any of their respective affiliates makes any warranties as to the completeness or accuracy of any of the information contained herein or that this message or any of its attachments is free of viruses.

Re: [cx-oracle-users] ORA-01000: maximum open cursors exceeded error

[Vikrant A. <vik...@gm...>]

I dont have code in Python to check it but I use the following SQL query to
check the open cursors at each step.
The value of total_cur shows the number of open cursors when you run it.

select sum(a.value) total_cur, avg(a.value) avg_cur, max(a.value) max_cur,
s.username, s.machine
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic#  and s.sid=a.sid
and b.name = 'opened cursors current'
group by s.username, s.machine
order by 1 desc;

I think the problem is specific to AIX because I do the same thing on Ubuntu
and it works just fine (decrements the open cursors at cursor.close())
On Ubuntu the software versions I have are the following :

> uname -a
Linux lgfdevbox 2.6.32-24-generic #42-Ubuntu SMP Fri Aug 20 14:24:04 UTC
2010 i686 GNU/Linux

> python
Python 2.6.5 (r265:79063, Apr 16 2010, 13:09:56)
[GCC 4.4.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> cx_Oracle.version
'5.0.3'
>>>

I am running Oracle 10g XE database on my box
> sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 8 19:28:43 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

I dont know if the build output of cx_Oracle would help, but here it is ....
(It throws a couple of duplicate symbol warnings, but cx_Oracle.so is built
successfully)

$ python setup.py build
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.aix-6.1-2.7-11g
gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall
-Wstrict-prototypes -I/software/oracle/product/11.1.0/client_1/rdbms/demo
-I/software/oracle/product/11.1.0/client_1/rdbms/public
-I/app/wms/wm/lgf/install_again/Python-2.7.1/Include
-I/app/wms/wm/lgf/install_again/Python-2.7.1 -c cx_Oracle.c -o
build/temp.aix-6.1-2.7-11g/cx_Oracle.o -DBUILD_VERSION=5.0.4 -qcpluscmt
gcc: unrecognized option '-qcpluscmt'
In file included from
/software/oracle/product/11.1.0/client_1/rdbms/public/oci.h:2962,
                 from cx_Oracle.c:10:
/software/oracle/product/11.1.0/client_1/rdbms/public/ociap.h:10700:
warning: function declaration isn't a prototype
/software/oracle/product/11.1.0/client_1/rdbms/public/ociap.h:10706:
warning: function declaration isn't a prototype
creating build/lib.aix-6.1-2.7-11g
./Modules/ld_so_aix gcc -pthread -bI:Modules/python.exp -L. -L . -L
/app/wms/wm/lgf/install_again/usr/lib build/temp.aix-6.1-2.7-11g/cx_Oracle.o
-L/software/oracle/product/11.1.0/client_1/lib32
-L/software/oracle/product/11.1.0/client_1 -lclntsh -o
build/lib.aix-6.1-2.7-11g/cx_Oracle.so
ld: 0711-224 WARNING: Duplicate symbol: .bcopy
ld: 0711-224 WARNING: Duplicate symbol: .fres
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
information.


At this time, I am trying to compile the Oracle Instant Client on AIX (just
to get everything compiled using the same gcc compiler).

Thanks much for your help,
Vikrant Angia

On Tue, Feb 8, 2011 at 11:34 AM, Anthony Tuininga <
ant...@gm...> wrote:

> Hi,
>
> I don't have access to an AIX box to see if this problem is specific
> to that platform....but I do use Django on Windows and Linux and do
> not run into any problems. Can you show me why you believe that the
> open cursor count is unchanged when calling cursor.close()? If you put
> such checking code in your script I can run it on the platforms I have
> access to and see if we get different results. Thanks.
>
> Anthony
>
> On Tue, Feb 8, 2011 at 9:22 AM, Vikrant Angia <vik...@gm...>
> wrote:
> > Hi,
> > I am currently using Python 2.7.1 on AIX 6.1 with cx_Oracle 5.0.4 and
> notice
> > that cursor.close() is NOT decrementing the open cursor count in Oracle.
> > The open cursor count is only decremented when the connection itself if
> > closed.
> > The connection object is created internally by the django framework and
> > hence I do not have control over closing it.
> > There are other applications running on the same AIX box against the same
> > Oracle version and they seem to be working fine - no open cursor leaks.
> > Can somebody point me in the right direction?
> > The versions of the software used is shown below :
> > AIX VERSION
> > $ oslevel -r
> > 6100-01
> > $ uname -a
> > AIX camanht1 1 6 00C70D354C00
> >
> > ORACLE VERSION
> > SQL*Plus: Release 11.1.0.6.0 - Production on Tue Feb 8 06:43:25 2011
> > Copyright (c) 1982, 2007, Oracle.  All rights reserved.
> >
> > Connected to:
> > Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
> Production
> > With the Partitioning, OLAP, Data Mining and Real Application Testing
> > options
> > PYTHON AND CX_ORACLE VERSION
> > $ ./python
> > Python 2.7.1 (r271:86832, Feb  7 2011, 06:50:53)
> > [GCC 4.2.4] on aix6
> > Type "help", "copyright", "credits" or "license" for more information.
> >>>> import cx_Oracle
> >>>> cx_Oracle.version
> > '5.0.4'
> > COMMANDS TO REPRODUCE
> >>>> connection=cx_Oracle.connect("VANGIA/logfire%5678@CADEVMNH")
> >>>> cur=connection.cursor()
> >>>> cur.execute("select sysdate from dual")    #### Number of open cursors
> >>>> is incremented
> > <__builtin__.OracleCursor on <cx_Oracle.Connection to VANGIA@CADEVMNH>>
> >>>> res=cur.fetchone()
> >>>> res[0]
> > datetime.datetime(2011, 2, 8, 6, 55, 38)
> >>>> cur.close()   #### Number of open cursors is NOT decremented
> >>>> del cur       #### Number of open cursors is NOT decremented
> >>>> del connection   #### Opened cursors are released at this point
> >
> >
> > Thanks,
> > Vikrant Angia
> >
> ------------------------------------------------------------------------------
> > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> > Pinpoint memory and threading errors before they happen.
> > Find and fix more than 250 security defects in the development cycle.
> > Locate bottlenecks in serial and parallel code that limit performance.
> > http://p.sf.net/sfu/intel-dev2devfeb
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>