Show extents that need to be resized
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 segment_name, segment_type, tablespace_name, sum(bytes)/1024 kbytes, count(segment_name) FROM
user_extents |