1、 2、select*from3SELECT 2、select*from3SELECT mm-ddhh24:mi:ss)LAST_UPDATE_TIME,TIME_REMAINING,ELAPSED_SECONDS,USE ORDERBY_LONGOPSB WHERE5、SELECTSUM(bytes1024*1024ASfree_spacetablespace_name FROM dba_free_space6、a.bytestotal,b.bytesused,c.bytesfree,(b.bytes*100) /a.bytes%USED ,(c.bytes*100) /a.by tes %

2、FREE FROM sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free cWHEREa.tablespace_name=b.tablespace_name AND a.tablespace_name = c.tablespace_name;7、select*fromuser_tableswheretable_name8、select*from9、selecttablespace_namefile_id,file_name, round(bytes/(1024*1024),0) total_spacefrom order by -表空間大小與使

3、用select a.a1 表空間名稱(chēng),c.c2 類(lèi)型,c.c3 區(qū)管理,b.b2/1024/1024 表空間大小 M,(b.b2-a.a2)/1024/1024已使用M,substr(b.b2-a.a2)/b.b2*100,1,5利用率 from(selecttablespace_namea1sum(nvl(bytes,0a2fromdba_free_space group by tablespace_name) a,(selecttablespace_nameb1,sum(bytes)b2fromdba_data_filesgroupby tablespace_name) b,(select

4、tablespace_namec1,contentsc2,extent_managementc3from) cwherea.a1=b.b1andSELECTSUM(bytes)/(1024*1024)ASfree_space,tablespace_namedba_free_spaceGROUPBY ablespace_name,a.bytestotal,b.bytesused,c.bytes(b.bytes*100)/a.bytes%USED,(c.bytes*100)/a.(b.bytes*100)/a.bytes%USED,(c.bytes*100)/a.bytes%FREE FROMsy

5、s.sm$ts_availa,sys.sm$ts_usedb,sys.sm$ts_freecWHEREa.tablespace_name = b.tablespace_name AND a.tablespace_name = select*fromselect*fromselect*fromselect*fromselect*from -由于事務(wù)沒(méi)提交等等，會(huì)引起鎖表，如下為Oracle中查詢(xún)表被鎖的select,sess.serial#,lo.oracle_username,sesswhereao.object_id=lo.object_idand_id SELECTSID,SERIAL#,USFROMWHERE+select*from-通過(guò)以下命，(其中784,48163分別是上面查詢(xún)出的altersystemkill 67,11226;-查看Or