User Profile & Quota

▣ User Profile Script

CREATE PROFILE "MYPROFILE" LIMIT CPU_PER_SESSION 1000

CPU_PER_CALL 1000

CONNECT_TIME 30

IDLE_TIME 15

SESSIONS_PER_USER 2

LOGICAL_READS_PER_SESSION 10000

LOGICAL_READS_PER_CALL 5000

PRIVATE_SGA 4K

COMPOSITE_LIMIT 10000000

PASSWORD_LIFE_TIME 30

PASSWORD_GRACE_TIME 7

PASSWORD_REUSE_MAX UNLIMITED

PASSWORD_REUSE_TIME 120

PASSWORD_LOCK_TIME 5

FAILED_LOGIN_ATTEMPTS 2

PASSWORD_VERIFY_FUNCTION DEFAULT

 

▣ Profile 적용

ALTER USER "XDB" PROFILE "MYPROFILE"

   

▣ Profile 검색

   

▣ Password Profile 적용

   

▣ Assigning Quota to Users