SELECT Count (SQL_Text) does not close the number of cursors, SQL_text SQL statement from V $ open_cursor where user_name = 'user name' group by SQL_Text Order By Unstick of the number DESC