Oracle Queries/Commands to Kill Session

select * from v$access 

where object = 'XX_PACKAGE_NAME';

/* Pick the sids from above query and pass to the below query */

select * from v$session

where sid in (322,368);

Syntax: ALTER SYSTEM KILL SESSION 'SID,SERIAL#';

ALTER SYSTEM KILL SESSION '322,48848';