You will need access to V$ views, V$SESSION, V$PROCESSS, V$SQLAREA. Also, V$OPEN_CURSOR will have all currently opened cursors.
From V$SESSION you can get the SID and SERIAL#.
As a DBA, you can kill the session using the following command. Note: SID and SERIAL# values are separated by a comma and are within single quotes.
ALTER SYSTEM KILL SESSION 'SID, SERIAL#'
Dig deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.