|
|
|
| Problems? Is your data what you think it is? | |
| PerlMonks |
Re: DBI/Oracle Nested SELECT queryby rdfield (Priest) |
| on Sep 04, 2015 at 15:28 UTC ( [id://1141022]=note: print w/replies, xml ) | Need Help?? |
|
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
|
|
||||||||||||||||||||||||||||||