17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT a.tablespace_name "表空间名称", total / (1024 * 1024) "表空间大小(M)", free / (1024 * 1024) "表空间剩余大小(M)", (total - free) / (1024 * 1024 ) "表空间使用大小(M)", total / (1024 * 1024 * 1024) "表空间大小(G)", free / (1024 * 1024 * 1024) "表空间剩余大小(G)", (total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)", round((total - free) / total, 4) * 100 "使用率 %" FROM (SELECT tablespace_name, SUM(bytes) free FROM dba_free_space GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes) total FROM dba_data_files GROUP BY tablespace_name) b WHERE a.tablespace_name = b.tablespace_name
SQL> select segment_name,segment_type,extents,bytes from dba_segments where tablespace_name='ANNEX';
SEGMENT_NAME SEGMENT_TYPE EXTENTS BYTES
------------------------------------- -------------- --------- ----------
SYS_IL0000445585C00006$$ LOBINDEX 17 2097152
SYS_LOB0000445585C00006$$ LOBSEGMENT 210 1751121920
BIN$qRP3thbzAC7gU6wQAQIALg==$0 TABLE 83 100663296
BIN$qRP3thbyAC7gU6wQAQIALg==$0 INDEX 22 7340032
BIN$qRP3thbxAC7gU6wQAQIALg==$0 INDEX 24 9437184
SQL> select segment_name,extent_id,file_id,bytes from dba_extents where tablespace_name='ANNEX';
SEGMENT_NAME EXTENT_ID FILE_ID BYTES
-------------------------------------------------------------------------------- ---------- ---------- ----------
SQL> select segment_name,segment_type,extents,initial_extent/1024/1024 MB_of_initial_extent,next_extent/1024/1024 MB_of_next_extent,max_extents/1024/1024 MB_of_max_extents,bytes/1024/1024/1024 GB from dba_segments where tablespace_name='ANNEX';
SEGMENT_NAME SEGMENT_TYPE EXTENTS MB_OF_INITIAL_EXTENT MB_OF_NEXT_EXTENT MB_OF_MAX_EXTENTS GB
-------------------------------------------------------------------------------- ------------------ ---------- -------------------- ----------------- ----------------- ----------
SYS_IL0000445585C00006$$ LOBINDEX 17 0.0625 2047.99999713898 0.00195312
SYS_LOB0000445585C00006$$ LOBSEGMENT 210 0.0625 2047.99999713898 1.63085937
BIN$qRP3thbzAC7gU6wQAQIALg==$0 TABLE 83 0.0625 2047.99999713898 0.09375
BIN$qRP3thbyAC7gU6wQAQIALg==$0 INDEX 22 0.0625 2047.99999713898 0.00683593
BIN$qRP3thbxAC7gU6wQAQIALg==$0 INDEX 24 0.0625 2047.99999713898 0.00878906
但是从这个结果看不出最后一个extents的位置,有其他方法吗?