The CREATE PROFILE statement creates a database user profile.
CREATE PROFILE app_user LIMIT
SESSIONS_PER_USER 2 --
CPU_PER_SESSION 10000 -- tenths
CPU_PER_CALL 1 -- tenths
CONNECT_TIME UNLIMITED -- minutes
IDLE_TIME 30 -- minutes
LOGICAL_READS_PER_SESSION DEFAULT -- DB BLOCKS
LOGICAL_READS_PER_CALL DEFAULT -- DB BLOCKS
-- COMPOSITE_LIMIT DEFAULT --
PRIVATE_SGA 20M --
FAILED_LOGIN_ATTEMPTS 3 --
PASSWORD_LIFE_TIME 30 -- days
PASSWORD_REUSE_TIME 12 --
PASSWORD_REUSE_MAX UNLIMITED --
PASSWORD_LOCK_TIME DEFAULT -- days
PASSWORD_GRACE_TIME 2 -- days
PASSWORD_VERIFY_FUNCTION NULL;
Example 1:
CREATE PROFILE myprofile LIMIT
SESSIONS_PER_USER 2
IDLE_TIME 5
CONNECT_TIME 10;
Example 2:
ALTER PROFILE default LIMIT IDLE_TIME 20;