1、查看表空间的名称及大小
selectttablespace_
amerou
dsumbytes102410240ts_sizefromdba_tablespacestdba_data_filesdwherettablespace_
amedtablespace_
amegroupbyttablespace_
ame
2、查看表空间物理文件的名称及大小
selecttablespace_
amefile_idfile_
amerou
dbytes102410240total_spacefromdba_data_filesorderbytablespace_
ame
3、查看回滚段名称及大小
selectsegme
t_
ametablespace_
amerstatusi
itial_exte
t1024I
itialExte
t
ext_exte
t1024NextExte
tmax_exte
tsvcurextCurExte
tFromdba_rollback_segsrvrollstatvWherersegme
t_idvus
orderbysegme
t_
ame
4、查看控制文件
select
amefromvco
trolfile获取创建表空间的sql
selectdbms_lobsubstrdbms_metadataget_ddlTABLESPACEatablespace_
amefromdba_tablespacesa
SQLselectsidserialfromvsessio
whereuser
ameTESTaltersystemkillsessio
1509019查看被锁的表
fselectobject_
amemachi
essidsserialseve
tfromgvlocked_objectldba_objectsogvsessio
swherelobject_idoobject_ida
dlsessio
_idssidaltersystemkillsessio
‘sidserial’
5、查看日志文件
selectmemberfromvlogfile
6、查看表空间的使用情况
selectsumbytes10241024asfree_spacetablespace_
amefromdba_free_spacegroupbytablespace_
ame
SELECTATABLESPACE_NAMEABYTESTOTALBBYTESUSEDCBYTESFREEBBYTES100ABYTES