SELECT sid FROM v$lock
WHERE id1 = (SELECT object_id FROM user_objects
ALTER system kill session '16,2077';
WHERE id1 = (SELECT object_id FROM user_objects
WHERE object_name = upper('XXTB'));
WHERE sid in ('70', '16', '67', '130');
ALTER system kill session '16,2077';
ALTER system kill session '67,18474';
select * from dba_db_links;
--drop public database link DBL_xxx ;
create database link DBL_ XXX connect to XXXidentified by XXX
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))';
select * from v_xxx@ XXX;
create public database link DBL_ XXX connect to XXXidentified by XXX
using 'xxxx';