Hi,
I ran a query in SQL Developer and I got results after 10 or 20 seconds.
Thereafter I left that session as is, did not run any queries or anything else in that session.
After an hour when someone notify me by checking 'Monitor Sessions' in SQL Developer--Tools, that my session is still in 'Active'!
I don't think my session has been active that long as I was done with my query an hour back?
I just want to know what would be the reason for that strange behavior ?
What would be the best way to know whether any session is consuming any resources or that session was just Active without consuming any resources?
Regards
Hesh