--
--  Name: show_table_stats.sql
--
--  Description: Tables - Displays stats of table
--
--  Compatability: tested on 9i
--
--  Usage: @show_table_stats.sql owner table
--
set lines 133
set verify off
--
SELECT t.table_name AS "Table Name", 
       t.num_rows AS "Rows", 
       t.avg_row_len AS "Avg Row Len", 
       blocks,
       num_rows,
       TO_CHAR(LAST_ANALYZED, 'YYYY-MM-DD HH24:MI:SS') as "Last Analysed"
FROM   dba_tables t
WHERE  owner like upper('&1')
and    table_name like upper('&2')
;