SQL > select * from dba_profiles where profile='DEFAULT';
PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP
-------------------- -------------------------------- -------- ------------------------------ --- --- ---
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NO
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NO
DEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NO
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO
DEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NO
DEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NO
DEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NO
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD ORA12C_VERIFY_FUNCTION NO NO NO
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO
DEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO
DEFAULT PASSWORD_ROLLOVER_TIME PASSWORD -1 NO NO NO
18 rows selected.
SQL > select limit from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
LIMIT
------------------------------
90
SQL > select limit from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION';
LIMIT
------------------------------
ORA12C_VERIFY_FUNCTION
SQL > select limit from dba_profiles where profile='DEFAULT' and resource_name='FAILED_LOGIN_ATTEMPTS';
LIMIT
------------------------------
5
SQL > select limit from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LOCK_TIME';
LIMIT
------------------------------
.0208
SQL > select limit from dba_profiles where profile='DEFAULT' and resource_name='IDLE_TIME';
LIMIT
------------------------------
30