Oracle存储过程死锁

确认存储过程是否死锁SELECT * FROM V$DB_OBJECT_CACHE WHERE name='PKG_TEST' AND LOCKS!='0';查出sid的值select SID from V$ACCESS WHERE object='PKG_TEST';查sid,serial#SEL


Oracle表空间使用情况

select b.file_id  文件ID,  b.tablespace_name  表空间,  b.file_name     物理文件名,  b.bytes       总字节数,  (b.bytes-sum(nvl(a.bytes,0)))   已使用,  sum(nvl(a.bytes,0