cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle SQL - long query times w/ a ton of Cursor Executions - what can I interpret from this?

sean_collins
Inactive
 
1 REPLY 1

Joe_Hoffman
Dynatrace Leader
Dynatrace Leader

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?