SELECT
a.tablespace_name "TableSpace Name",
a.file_name "File Name",
a.status "Status",
to_char(nvl(a.bytes / 1024 / 1024, 0), '99G999G999D99') "Size
(MB)",
a.autoextensible "Auto",
to_char(nvl(a.increment_by * p.value / 1024 / 1024, 0),
'99G999G999D99') "Next (MB)",
to_char(nvl(a.maxbytes / 1024 / 1024, 0), '99G999G999D99') "Max
(MB)"
FROM
dba_data_files a,
(
SELECT
value
FROM
v$parameter
WHERE
name = 'db_block_size'
) p
UNION
SELECT
a.tablespace_name "TableSpace Name",
a.file_name "File Name",
a.status "Status",
to_char(nvl(a.bytes / 1024 / 1024, 0), '99G999G999D99') "Size
(MB)",
a.autoextensible "Auto",
to_char(nvl(a.increment_by * p.value / 1024 / 1024, 0),
'99G999G999D99') "Next (MB)",
to_char(nvl(a.maxbytes / 1024 / 1024, 0), '99G999G999D99') "Max
(MB)"
FROM
dba_temp_files a,
(
SELECT
value
FROM
v$parameter
WHERE
name = 'db_block_size'
) p
order by 1;
04-25
08-25
2455
09-18
1万+
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交