oracle表空间查询和表数据量查询

1.表,索引......空间查询

SELECT * FROM (  SELECT SEGMENT_NAME, SUM(BYTES)/1024/1024/1024 G  FROM DBA_SEGMENTS  WHERE OWNER = user GROUP BY SEGMENT_NAME  ORDER BY 2 DESC );

2.表数据量查询

select 'analyze table '||table_name||' compute statistics;' from user_tables;

select table_name,num_rows from user_tables;