SET VERIFY OFF
COL OBJETO FORMAT A8
--COL OWNER  FORMAT A15
SELECT 'TABELA' OBJETO, LAST_ANALYZED, TABLE_NAME OBJET_NAME, NUM_ROWS, NULL BLEVEL, NULL DISTINCT_KEYS, CHAIN_CNT, INI_TRANS
FROM DBA_TABLES WHERE OWNER= UPPER( '&&1.' ) AND TABLE_NAME LIKE UPPER( '&&2.')
UNION ALL
SELECT 'INDICE', LAST_ANALYZED, INDEX_NAME, NUM_ROWS, BLEVEL, DISTINCT_KEYS, NULL, INI_tRANS
FROM DBA_INDEXES
WHERE TABLE_OWNER= UPPER( '&1.' ) AND TABLE_NAME LIKE UPPER( '&2.')
AND INDEX_NAME NOT LIKE 'SYS_IL%'
ORDER BY 1 DESC, 2 DESC
/
SET VERIFY ON
COL OBJETO CLEAR
--COL OWNER CLEAR
UNDEFINE 1 2