REGISTROS TABLA FILTRADO X TABLESPACE

SQL> exec dbms_stats.gather_schema_stats('HR');

SQL> select owner,table_name,TABLESPACE_NAME,last_analyzed,num_rows from dba_tables

where owner='HR' 

and TABLESPACE_NAME='EXAMPLE'

order by num_rows desc