方法1

select name from v$db_object_cache;
select /*+rule*/* from v$access;
select sid,serial# from v$session;
alter system kill session 'aid,serial#';

方法2

-- 1、先从 dba_objects / user_objects中查询到该表的object_id:

select object_id from dba_objects where object_name=upper('KOL_XX_FIN050_TEMP');

-- 2、根据查到的object_id知道使用该表的session：

select * from v$lock where id1=&object_id;

-- 3、在从v$session视图中查到该session的SID和SERIAL#：

select * from v$session where sid=331;

-- 4、杀掉这些进程:

alter system kill session ‘SID,SERIAL#’;

删除表空间和用户

drop tablespace ts_xxx including contents and datafiles;
drop user xxx cascade;