close

select owner, table_name, tablespace_name, num_rows, blocks, blocks*8096 as blockusebyte, avg_row_len, avg_row_len*num_rows as rowusebyte

from all_tables

where owner <> 'SYS' and owner <> 'SYSTEM' and blocks is not null and tablespace_name = 'SYSTEM'

order by num_rows desc;

arrow
arrow
    全站熱搜

    johnchen6927 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄