ora-20000 oru-10027 buffer overflow limit of 2000 bytes

DBMS_OUTPUT.ENABLE(1000000);

set serveroutput on size 1000000;

sql query to kill session in oracle

ALTER SYSTEM KILL SESSION 'SID,SERIAL#,@INST_ID';
ALTER SYSTEM KILL SESSION '2328,33131,@1';

Query to find lock objects in pl sql

SELECT
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine,
inst_id
FROM
v$locked_object a,
v$session b,
gv$session gv,
dba_objects c
WHERE
b.sid = a.session_id
AND b.sid = gv.sid
AND b.serial# = gv.serial#
AND a.object_id = c.object_id;