» Unlabelled » To see size of your tables and indexes | Oracle DBA Tutorial pdf

Sunday, 20 January 2013

To see size of your tables and indexes | Oracle DBA Tutorial pdf


To see size of your tables and indexes

select SEGMENT_NAME, SEGMENT_TYPE, BYTES from USER_SEGMENTS
where segment_type IN ('TABLE','INDEX')
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)