ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN BC014EEB397CBEA0E0530100007F78C4 select dt.contents, dtum.tablespace_name, vp.value*dtum.used_space/1000000 data_size, ddf.bytes/1000000 file_size, (ddf.bytes-vp.value*dtum.used_space)/1000000 unused_file_size, vp.value*dtum.used_space/ddf.bytes*100 file_used_percent, vp.value*dtum.tablespace_size/1000000 max_extensible_size, dtum.used_percent max_used_percent, nvl(due.active,(select vp.value*vss.used_blocks/1000000 from v$sort_segment vss where dt.tablespace_name=vss.tablespace_name)) active, due.unexpired_undo, due.expired_undo from dba_tablespaces dt, (select vp.value from v$parameter vp where vp.name like 'db_block_size') vp, dba_tablespace_usage_metrics dtum, ( select distinct ddf.tablespace_name, sum(ddf.bytes) over (partition by ddf.tablespace_name) bytes from dba_data_files ddf union all select distinct dtf.tablespace_name, sum(dtf.bytes) over (partition by dtf.tablespace_name) bytes from dba_temp_files dtf ) ddf, ( select * from (select distinct due.tablespace_name, due.status, sum(due.blocks) over (partition by due.tablespace_name,due.status)*8192/1000000 space from dba_undo_extents due) due pivot ( sum(due.space) for status in ( 'ACTIVE' active, 'UNEXPIRED' unexpired_undo, 'EXPIRED' expired_undo ) ) ) due where dt.tablespace_name=dtum.tablespace_name and dt.tablespace_name=ddf.tablespace_name(+) and dt.tablespace_name=due.tablespace_name(+) order by dt.contents, dtum.used_space desc Y #,##0;[Red]-#,##0 AR DBA Tablespace Usage استخدام Tablespace بما في ذلك التراجع النشط حاليًا واستخدام مساحة الجدول المؤقت D DBA Tablespace Usage Tablespace-Nutzung einschließlich der derzeit aktiven Undo- und Temp-Tablepace-Nutzung E DBA Tablespace Usage Uso del espacio de tabla, incluyendo el uso del espacio de tabla temporal y de deshacer actualmente activo F DBA Tablespace Usage Utilisation de l'espace de table, y compris l'annulation en cours et l'utilisation temporaire de l'espace de table I DBA Tablespace Usage Utilizzo dello spazio di tabelle, compresi gli annullamenti attualmente attivi e l'utilizzo dello spazio di tabelle temporaneo JA DBA Tablespace Usage 現在アクティブなアンドゥと一時的なテーブルスペースの使用状況を含むテーブルスペースの使用状況 KO DBA Tablespace Usage 현재 활성 실행 취소 및 임시 테이블 스페이스 사용량을 포함한 테이블 스페이스 사용량 PTB DBA Tablespace Usage Uso de espaço de tabela, incluindo uso de espaço de tabela atualmente ativo desfazer e uso de espaço de tabela temporário RU DBA Tablespace Usage Использование табличного пространства, включая текущую активную отмену и временное использование табличного пространства. S DBA Tablespace Usage Tabellutnyttjande inklusive för närvarande aktiv ångra och temp-tabellanvändning TR DBA Tablespace Usage Mevcut aktif geri alma ve geçici tablo alanı kullanımı dahil olmak üzere tablo alanı kullanımı US DBA Tablespace Usage Tablespace usage including currently active undo and temp tablepace usage in Megabytes ZHS DBA Tablespace Usage 表空间使用情况，包括当前活动的撤销和临时表空间使用情况。 Enginatics