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的概要文件:
SQL> select profile,resource_name,limit from dba_profiles order by profile;
PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- -----------------------------------------------------------------
DEFAULT COMPOSITE_LIMIT UNLIMITED
DEFAULT SESSIONS_PER_USER UNLIMITED
DEFAULT CPU_PER_SESSION UNLIMITED
DEFAULT CPU_PER_CALL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL UNLIMITED
DEFAULT IDLE_TIME UNLIMITED
DEFAULT CONNECT_TIME UNLIMITED
DEFAULT PRIVATE_SGA UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS 10
DEFAULT PASSWORD_LIFE_TIME UNLIMITED
DEFAULT PASSWORD_REUSE_TIME UNLIMITED
DEFAULT PASSWORD_REUSE_MAX UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION NULL
DEFAULT PASSWORD_LOCK_TIME UNLIMITED
DEFAULT PASSWORD_GRACE_TIME UNLIMITED
MONITORING_PROFILE COMPOSITE_LIMIT DEFAULT
MONITORING_PROFILE SESSIONS_PER_USER DEFAULT
MONITORING_PROFILE CPU_PER_SESSION DEFAULT
MONITORING_PROFILE CPU_PER_CALL DEFAULT
MONITORING_PROFILE LOGICAL_READS_PER_SESSION DEFAULT
MONITORING_PROFILE LOGICAL_READS_PER_CALL DEFAULT
MONITORING_PROFILE IDLE_TIME DEFAULT
MONITORING_PROFILE CONNECT_TIME DEFAULT
MONITORING_PROFILE PRIVATE_SGA DEFAULT
MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS UNLIMITED
MONITORING_PROFILE PASSWORD_LIFE_TIME DEFAULT
MONITORING_PROFILE PASSWORD_REUSE_TIME DEFAULT
MONITORING_PROFILE PASSWORD_REUSE_MAX DEFAULT
MONITORING_PROFILE PASSWORD_VERIFY_FUNCTION DEFAULT
MONITORING_PROFILE PASSWORD_LOCK_TIME DEFAULT
MONITORING_PROFILE PASSWORD_GRACE_TIME DEFAULT
32 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28612416/viewspace-1078017/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28612416/viewspace-1078017/