in reply to DBI/Oracle Nested SELECT query
Check the running queries in the v$sql and v$sqlarea tables (or v$session_longops) to make sure it is actually doing something. Also try explain_plan or look at the output of tkprof (statistics need to be enabled). There must be something different about the sql in the client and the sql in your perl script.
rdfield
|
---|
In Section
Seekers of Perl Wisdom