seesql3.sql

/*This event is used to monitor a user's cursor statement. 10/10/95--xyz*/
select substr(user_name, 1, 5)	    "User Name",
       substr(sql_text, 1, 200)     "Cursor Statement"
from   v$open_cursor
where  user_name = upper('&Oracle_User')
;