需求:需要查一个模式下所有表的大小,以MB为单位:
sql:
SELECT * FROM (
SELECT
OWNER,TABLE_NAME,TABLE_USED_SPACE(OWNER,TABLE_NAME)*PAGE()/1024/1024.0 AS "MB"
FROM
SYS.ALL_TABLES
WHERE
OWNER = 'BJLGJ_MRBF'
) ORDER BY "MB" DESC;
需求:需要查一个模式下所有表的大小,以MB为单位:
sql:
SELECT * FROM (
SELECT
OWNER,TABLE_NAME,TABLE_USED_SPACE(OWNER,TABLE_NAME)*PAGE()/1024/1024.0 AS "MB"
FROM
SYS.ALL_TABLES
WHERE
OWNER = 'BJLGJ_MRBF'
) ORDER BY "MB" DESC;