Re: Python 2: unicode vs str param causing slowness

Dayton,
what is the value of NLS_LANG on client machine?
What is returned by 'SELECT USERENV ('language') FROM DUAL' when calling
from django?

2015-01-21 21:37 GMT+03:00 Dayton Gomez <Dayton_Gomez-okLH5SSHHyRWk0Htik3J/[email protected]>:

> I grabbed the ful query, plus the bound variables. I get this for bound
> vars:
>
> DATATYPE_STRING   VALUE_STRING
> ---------------------------    ----------------------
> NVARCHAR2(32)        ios
>
> It seems right. The only thing I notice is that the table definition is
> for NVARCHAR2(20).
>
> From: Vladimir Ryabtsev <[email protected]>
> Reply-To: "cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" <
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
> Date: Tuesday, January 20, 2015 2:42 PM
> To: "cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" <
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
> Subject: Re: [cx-oracle-users] Python 2: unicode vs str param causing
> slowness
>
> Hi,
> Did you try to look the text of actual query that being executed when you
> come across the slowness?
> Something like this:
> http://stackoverflow.com/questions/55899/how-to-see-the-actual-oracle-sql-statement-that-is-being-executed
> You can also find out the datatype of your bound variable :platform as
> mentioned here:
> http://stackoverflow.com/questions/1707291/how-to-get-the-last-executed-sql-statement-and-bind-variable-values-in-oracle
> This will you give a clue about implicit datatype conversion.
> I don't think it's a django thing.
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users