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
