How do I get the session id of particular package

I face some problem regarding oracle package execution. One of the currently running package has locked some table. So I want to kill the session. How do I get the session id of particular currently running package.

The DBA option in TOAD can help you on this. Here you can view each and every details of a particular session. For further details let me know.

where shall we find those details in TOAD?

[QUOTE=ssusmitaa;10606]I face some problem regarding oracle package execution. One of the currently running package has locked some table. So I want to kill the session. How do I get the session id of particular currently running package.[/QUOTE]

Hello ssusmita,

U have to use the dynamic views to resolve this problem.

U can find the information abt the query package by v$sql or v$sqltext view. There it shows which session is executing that package. Based on which query ur v$session to identify the username , serial# and the sid with which u can kil that session.

Hope this helps..
Balasubramanian.J

You can get the session id of particular currently running package.
But that session id is not of the package ,but of the user who is executing it.

You can find the session sid and other info from this query.

select sid , serial#, username , osuser, machine , status, program, module
from v$SESSION