ORACLE/TABLESPACE - centromezzo wikiè¡¨é ˜åŸŸã®è¨˜æ†¶é ˜åŸŸãƒ‘ラメータを表示 †SELECT tablespace_name, initial_extent "INITIAL", next_extent "NEXT", min_extents, max_extents, pct_increase, status FROM dba_tablespaces; ↑ 改良版 †select d.tablespace_name, ç¾ã‚µã‚¤ã‚º "ç¾ã‚µã‚¤ã‚º[MB]", round(ç¾ã‚µã‚¤ã‚º-空ã容é‡) "使用é‡[MB]", round((1 - (空ã容é‡/ç¾ã‚µã‚¤ã‚º))*100) "使用率(%)", 空ãå®¹é‡ "空ã容é‡[MB]" from (SELECT tablespace_name, round(SUM(bytes)/(1024*1024)) "ç¾ã‚µã‚¤ã‚º" FROM dba_data_files GROUP BY tablespace_n
DBConsole for Oracle Enterprise Manager - 猫目的日々
{{#tags}}- {{label}}
{{/tags}}