在Oracle中查找数据库的大小

SELECT
    SUM(bytes) AS "Total Size (Bytes)",
    SUM(bytes) / 1024 AS "Total Size (KB)",
    SUM(bytes) / (1024 * 1024) AS "Total Size (MB)",
    SUM(bytes) / (1024 * 1024 * 1024) AS "Total Size (GB)"
FROM
    dba_data_files;

SELECT
    owner,
    segment_name AS "Table Name",
    segment_type AS "Table Type",
    bytes AS "Size (Bytes)",
    bytes / 1024 AS "Size (KB)",
    bytes / (1024 * 1024) AS "Size (MB)",
    bytes / (1024 * 1024 * 1024) AS "Size (GB)"
FROM
    dba_segments
WHERE
    segment_type IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION')
ORDER BY
    bytes DESC;