select SEGMENT_NAME,TABLESPACE_NAME,sum(BYTES/1024/1024)||'M' db_size from USER_extents where SEGMENT_TYPE='TABLE' group by SEGMENT_NAME,TABLESPACE_NAME order by db_size;
Copyright © 2024 zkx4213 Powered by .NET 8.0 on Kubernetes