oralce惯用操作、查询语句(查看表空间)

oralce常用操作、查询语句(查看表空间)
最近整理一下oralce的常用语句，借此记录一下，在网上都应该能搜到，这里主要是整理分享。

一、操作语句
建立表空间 MYDATE

建立用户highill,密码highill 并授权
SELECT DBF.TABLESPACE_NAME AS "表空间",       DBF.TOTALSPACE AS "总量(M)",       (DBF.TOTALSPACE - DFS.FREESPACE) AS "使用总量(M)",       DFS.FREESPACE AS "空闲总量(M)",       DBF.TOTALBLOCKS AS "总块数",       (DBF.TOTALBLOCKS - DFS.FREEBLOCKS) AS "使用块数",       DFS.FREEBLOCKS AS "空闲块数",       (1 - (DFS.FREESPACE / DBF.TOTALSPACE)) * 100 AS "使用比例",       (DFS.FREESPACE / DBF.TOTALSPACE) * 100 AS "空闲比例"  FROM (SELECT T.TABLESPACE_NAME,               SUM(T.BYTES) / 1024 / 1024 TOTALSPACE,               SUM(T.BLOCKS) TOTALBLOCKS          FROM DBA_DATA_FILES T         GROUP BY T.TABLESPACE_NAME) DBF,       (SELECT TT.TABLESPACE_NAME,               SUM(TT.BYTES) / 1024 / 1024 FREESPACE,               SUM(TT.BLOCKS) FREEBLOCKS          FROM DBA_FREE_SPACE TT         GROUP BY TT.TABLESPACE_NAME) DFS WHERE TRIM(DBF.TABLESPACE_NAME) = TRIM(DFS.TABLESPACE_NAME);