v$session request

[sportsMarkr]

I am connecting to Oracle 9i using JDBC in my JSP/Servlets web pages. I am closing all my connections in all the JDBC calls.
Sometimes I run v$session and see several lines of JDBC Thin Client inactive status. Any way to find exactly what sql statement is causing the JDBC Thin Client to show up?

 

[kutz13]

Try using the dictionary view 'v$sqltext' by searching on the SID from 'v$session'.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:13948258923206

will give you a bit more of an insight into tidying the output up.

The difference between eggs and bacon: The chickens involved but the pigs committed