概要文件的设置:
CREATE PROFILE "TEMPPROFILE"
/*【一般信息】选项卡对应的配置参数*/
LIMIT CPU_PER_SESSION 1000
CPU_PER_CALL 1000
CONNECT_TIME 30 --连接时间
IDLE_TIME DEFAULT --空闲时间
SESSIONS_PER_USER 10
LOGICAL_READS_PER_SESSION 1000
LOGICAL_READS_PER_CALL 1000
PRIVATE_SGA 16K
COMPOSITE_LIMIT 1000000
/*【口令】选项卡对应的配置参数*/
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 5
PASSWORD_GRACE_TIME 60
PASSWORD_LIFE_TIME 30
PASSWORD_REUSE_MAX
DEFAULT PASSWORD_REUSE_TIME 30
PASSWORD_VERIFY_FUNCTION DEFAULT
CREATE PROFILE "TEMPPROFILE"
/*【一般信息】选项卡对应的配置参数*/
LIMIT CPU_PER_SESSION 1000
CPU_PER_CALL 1000
CONNECT_TIME 30 --连接时间
IDLE_TIME DEFAULT --空闲时间
SESSIONS_PER_USER 10
LOGICAL_READS_PER_SESSION 1000
LOGICAL_READS_PER_CALL 1000
PRIVATE_SGA 16K
COMPOSITE_LIMIT 1000000
/*【口令】选项卡对应的配置参数*/
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 5
PASSWORD_GRACE_TIME 60
PASSWORD_LIFE_TIME 30
PASSWORD_REUSE_MAX
DEFAULT PASSWORD_REUSE_TIME 30
PASSWORD_VERIFY_FUNCTION DEFAULT
例子:alter profile default limit connect_time 1000;杀掉某个session:
alter system kill session 'sid,serial#'