Oracle PL/SQL/System Tables Views/dba profiles

Resource Limits for the Default Profile

 
SQL>
SQL> SELECT DISTINCT resource_name, limit
  2  FROM dba_profiles
  3  WHERE profile="DEFAULT";
RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
IDLE_TIME                        UNLIMITED
CONNECT_TIME                     UNLIMITED
PASSWORD_LIFE_TIME               UNLIMITED
PASSWORD_LOCK_TIME               UNLIMITED
LOGICAL_READS_PER_SESSION        UNLIMITED
PRIVATE_SGA                      UNLIMITED
LOGICAL_READS_PER_CALL           UNLIMITED
SESSIONS_PER_USER                UNLIMITED
CPU_PER_SESSION                  UNLIMITED
FAILED_LOGIN_ATTEMPTS            10
PASSWORD_VERIFY_FUNCTION         NULL
RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
PASSWORD_GRACE_TIME              UNLIMITED
PASSWORD_REUSE_TIME              UNLIMITED
PASSWORD_REUSE_MAX               UNLIMITED
COMPOSITE_LIMIT                  UNLIMITED
CPU_PER_CALL                     UNLIMITED
16 rows selected.
SQL>