Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. col segment_name format a20
  2. select segment_name
  3. , bytes "SIZE_BYTES"
  4. , ceil(bytes / 1024 / 1024) "SIZE_MB"
  5. from dba_segments
  6. where segment_name like '&obj_name'
  7. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement