--查看 oracle 所有数据库实例
select * from v$instance;
--查看 oracle 所有表空间
SELECT tablespace_name,file_name FROM dba_data_files;
--查看 oracle 所有用户
select * from all_users;
select * from dba_users;
--oracle 查看某表空间下所有表
select table_name from all_tables where TABLESPACE_NAME='YPGL'
--oracle 查看某表空间下所有表占用实际空间
select t.segment_name, t.segment_type, sum(t.bytes / 1024 / 1024) "占用空间(M)"
from dba_segments t
where t.segment_type='TABLE'
and t.segment_name in (select table_name from all_tables where TABLESPACE_NAME='YPGL' )
--and t.segment_name='TZYFYMX'
group by OWNER, t.segment_name, t.segment_type;