Re: DBD::Oracle dbd_st_execute slow speed

a 10046 trace that I recommended would show both the optimizer path and 
the wait information.

Mike Towery
On 12/16/2010 6:06 AM, Ludwig, Michael wrote:
>> -----Original Message-----
>> From: John Scoles
>> More likely SQLplus is spawning a thread while DBD::Oracle does not.
> You mean performing the actual work in the background while making
> the prompt available for the user to enter the next command?
>
> Oracle's sqlplus doesn't appear to have a -verbose switch, but maybe
> there is an option you can set on the connection to find out what's
> going on inside.
>
>>>           This still doesn't explain the difference between
>> DBD::Oracle and
>>> sqlplus. They must have had different execution plans
>> internally somehow.
> Michael