在Oracle中，怎么快速获得用户下每个表或表分区的记录数？

可以分析该用户，然后查询USER_TABLES字典，或者采用如下脚本即可：

SET SERVEROUTPUT ON SIZE 20000

DECLARE

  MICOUNT INTEGER;

BEGIN

  FOR C_TAB IN (SELECT TABLE_NAME FROM USER_TABLES) LOOP

    EXECUTE IMMEDIATE 'select count(*) from "' || C_TAB.TABLE_NAME || '"' INTO MICOUNT;

    DBMS_OUTPUT.PUT_LINE(RPAD(C_TAB.TABLE_NAME, 30, '.') ||LPAD(MICOUNT, 10, '.'));

    SELECT COUNT(*)

      INTO MICOUNT

      FROM USER_PART_TABLES

     WHERE TABLE_NAME = C_TAB.TABLE_NAME;

    IF MICOUNT > 0 THEN

      FOR C_PART IN (SELECT PARTITION_NAME

                       FROM USER_TAB_PARTITIONS

                      WHERE TABLE_NAME = C_TAB.TABLE_NAME) LOOP

        EXECUTE IMMEDIATE 'select count(*) from ' || C_TAB.TABLE_NAME ||' partition (' || C_PART.PARTITION_NAME || ')'

        

          INTO MICOUNT;

        DBMS_OUTPUT.PUT_LINE('     ' || RPAD(C_PART.PARTITION_NAME, 30, '.') || LPAD(MICOUNT, 10, '.'));

      END LOOP;

    END IF;

  END LOOP;

END;