i want to get all tables which size is over as example 5 mb. is there a sql statement which gets me all the table names of the table who have more than this value?
thnx
select segment_name, bytes from user_segments
where segment_type = 'TABLE';
Take into account that this number represent the number of bytes allocated for inserting rows. This space might be 10%, 20% or 90% free. To have a better idea of the space used by your table, you would have to use the ANALYZE command and check the info in USER_TABLES (I don't know them off the top of my head).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.