Resource Limits for the Default Profile : dba_profiles « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. 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>

 

Related examples in the same category