Oracle 查Table 大小,筆數

SELECT OWNER,TABLE_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
ORDER  BY NUM_ROWS DESC

 


oracleD2K 發表在 痞客邦 留言(1) 人氣()