SQL for counting rows of all tables (tested on Oracle 10g)

COUNT_ALL_TABLES.SQL

-- SQL for counting rows of all tables (tested on Oracle 10g)
-- http://laurentschneider.com/wordpress/2007/04/how-do-i-store-the-counts-of-all-tables.html
SELECT
    TABLE_NAME,
    TO_NUMBER(
        EXTRACTVALUE(
            XMLTYPE(DBMS_XMLGEN.GETXML('SELECT COUNT(*) C FROM ' || TABLE_NAME)),
            '/ROWSET/ROW/C'
        )
    ) COUNT
FROM
    USER_TABLES;