Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- col segment_name format a20
- select segment_name
- , bytes "SIZE_BYTES"
- , ceil(bytes / 1024 / 1024) "SIZE_MB"
- from dba_segments
- where segment_name like '&obj_name'
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement