Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: DBI/Oracle Nested SELECT query

by rdfield (Priest)
on Sep 04, 2015 at 15:28 UTC ( #1141022=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1141022]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2021-03-02 08:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favorite kind of desktop background is:











    Results (41 votes). Check out past polls.

    Notices?