Management password & resource

1.profile
1>.failed_login_attempts
2>.password_lock_time
3>.password_lift_time
4>.password_grace_time
5>.password_reuse_time
6>.password_reuse_max
7>.password_verify_function
8>.cpu_per_session
9>.session_per_user
10>.connect_time
11>.idle_time
12>.logical_reads_pre_session
13>.private_sga
14>.cpu_per_call
15>.logical_reads_per_calls

Hints：oracle默认的密码验证函数veryfy_function

2.常用操作
1>.删除profile

drop profile profilename cascade

2>.启动资源生效功能

alter system set resoure_limit = true scop=spfile

3>.主要的包
dbms_resoure_manager
3.重要的视图
dba_users,dba_profiles