搜出该用户的session的SID,SERIAL码,然后kill掉
select sid,serial# from v$session where username='user_name';
alter system kill session 'sid,serial';
alter system kill session '527,2832';
删除用户
drop user user_name cascade;
删除表空间
drop tablespace tab_name including contents and datafiles
当前表空间大小
select * from dba_data_files where tablespace_name=$TABLESPACE
已使用的表空间大小
select * from dba_segments where tablespace_name=$TABLESPACE_NAME;
未使用空间大小
select * from dba_free_space where tablespace_name=$TABLESPACE_NAME;