> Home > Scripts > Oracle >

Size of DBA extents

NOTICE: must have DBA read authority to run this script.

This script should be run from SQL*plus prompt. This can also be placed in a file and ran from the SQL*plus prompt

 

SELECT owner, 

       tablespace_name, 

       sum(bytes)/(1024*1000) MEGbytes
FROM dba_extents
GROUP BY owner, tablespace_name

/