oracle 11g之概要檔案資訊：

SQL> select profile,resource_name,limit from dba_profiles order by profile;

PROFILE RESOURCE_NAME LIMIT

-------------------- ------------------------------ -----------------------------------------------------------------------

DEFAULT COMPOSITE_LIMIT UNLIMITED

DEFAULT PASSWORD_LOCK_TIME 1

DEFAULT PASSWORD_VERIFY_FUNCTION NULL

DEFAULT PASSWORD_REUSE_MAX UNLIMITED

DEFAULT PASSWORD_REUSE_TIME UNLIMITED

DEFAULT PASSWORD_LIFE_TIME 180

DEFAULT FAILED_LOGIN_ATTEMPTS 10

DEFAULT PRIVATE_SGA UNLIMITED

DEFAULT CONNECT_TIME UNLIMITED

DEFAULT IDLE_TIME UNLIMITED

DEFAULT LOGICAL_READS_PER_CALL UNLIMITED

DEFAULT LOGICAL_READS_PER_SESSION UNLIMITED

DEFAULT CPU_PER_CALL UNLIMITED

DEFAULT CPU_PER_SESSION UNLIMITED

DEFAULT SESSIONS_PER_USER UNLIMITED

DEFAULT PASSWORD_GRACE_TIME 7

MONITORING_PROFILE PASSWORD_GRACE_TIME DEFAULT

MONITORING_PROFILE COMPOSITE_LIMIT DEFAULT

MONITORING_PROFILE PASSWORD_REUSE_TIME DEFAULT

MONITORING_PROFILE IDLE_TIME DEFAULT

MONITORING_PROFILE PASSWORD_VERIFY_FUNCTION DEFAULT

MONITORING_PROFILE LOGICAL_READS_PER_CALL DEFAULT

MONITORING_PROFILE PASSWORD_LIFE_TIME DEFAULT

MONITORING_PROFILE LOGICAL_READS_PER_SESSION DEFAULT

MONITORING_PROFILE PASSWORD_LOCK_TIME DEFAULT

MONITORING_PROFILE CPU_PER_CALL DEFAULT

MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS UNLIMITED

MONITORING_PROFILE CPU_PER_SESSION DEFAULT

MONITORING_PROFILE PASSWORD_REUSE_MAX DEFAULT

MONITORING_PROFILE SESSIONS_PER_USER DEFAULT

MONITORING_PROFILE PRIVATE_SGA DEFAULT

MONITORING_PROFILE CONNECT_TIME DEFAULT

已選取 32 個資料列.

SQL> spool off;

oracle 10g的概要檔案：