René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Oracle SQL: Create Profile

create profile profile-name limit kernel-limit n;
create profile profile-name limit kernel-limit unlimited;
create profile profile-name limit kernel-limit default;

create profile profile-name limit password-limit expression;
create profile profile-name limit password-limit unlimited;
create profile profile-name limit password-limit default;

create profile profile-name limit password_verify_function function-name;
create profile profile-name limit password_verify_function null;
create profile profile-name limit password_verify_function default;

create profile profile-name limit kernel-limit-1 xyz,
  kernel-limit-2 abc
  kernel-limit-3 qrp
  password-limit-1 foo
  password-limit-2 bar
  password-limit-3 baz;
Note: In order to enforce kernel limits, resource_limit must be set to true.
create profile 
  appl_profile 
limit
  sessions_per_user                 2   --
  cpu_per_session               10000   -- hunderth of seconds
  cpu_per_call                      1   -- hunderth of seconds
  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;

See also profiles.