Someone beat me to it in this good post: Oracle Tip: Counting ROWS for all… Read the postHOWTO: Count all Rows in all Tables – The XMLDB Way