Oracle SQL - long query times w/ a ton of Cursor Executions - what can I interpret from this?
Cursors point to records in the database so if you see lots of cursors being consumed, i'm guessing you're getting lots of rows back from the query execution. This might relate to the long running query, in that more work is required for broader searches. Take a look at the query string, is there lots of select statements without 'where' clauses to limit the amount of data coming back?
