CREATE/ALTER/DROP PROFILE 
						
						
						CREATE PROFILE profile_name LIMIT 
  [SESSIONS_PER_USER  integer | UNLIMITED | DEFAULT]
  [CPU_PER_SESSION  integer | UNLIMITED | DEFAULT]
  [CPU_PER_CALL  integer | UNLIMITED | DEFAULT]
  [CONNECT_TIME  integer | UNLIMITED | DEFAULT]
  [IDLE_TIME  integer | UNLIMITED | DEFAULT]
  [LOGICAL_READS_PER_SESSION  integer | UNLIMITED | DEFAULT]
  [LOGICAL_READS_PER_CALL  integer | UNLIMITED | DEFAULT]
  [PRIVATE_SGA  {integer [K | M] | UNLIMITED | DEFAULT]}]
  [COMPOSITE_LIMIT  {integer | UNLIMITED | DEFAULT}]
  [FAILED_LOGIN_ATTEMPTS expression | UNLIMITED | DEFAULT]
  [PASSWORD_LIFE_TIME expression | UNLIMITED | DEFAULT]
  [PASSWORD_REUSE_TIME expression | UNLIMITED | DEFAULT]
  [PASSWORD_LOCK_TIME expression | UNLIMITED | DEFAULT]
  [PASSWORD_GRACE_TIME expression | UNLIMITED | DEFAULT]
  [PASSWORD_VERIFY_FUNCTION function | NULL | DEFAULT]

Creates a profile to set limits on database resources.

ALTER PROFILE profile_name LIMIT 
  [SESSIONS_PER_USER  integer | UNLIMITED | DEFAULT]
  [CPU_PER_SESSION  integer | UNLIMITED | DEFAULT]
  [CPU_PER_CALL  integer | UNLIMITED | DEFAULT]
  [CONNECT_TIME  integer | UNLIMITED | DEFAULT]
  [IDLE_TIME  integer | UNLIMITED | DEFAULT]
  [LOGICAL_READS_PER_SESSION  integer | UNLIMITED | DEFAULT]
  [LOGICAL_READS_PER_CALL  integer | UNLIMITED | DEFAULT]
  [PRIVATE_SGA  integer [K | M] |   UNLIMITED | DEFAULT]
  [COMPOSITE_LIMIT  integer | UNLIMITED | DEFAULT]
  [FAILED_LOGIN_ATTEMPTS expression | UNLIMITED | DEFAULT]
  [PASSWORD_LIFE_TIME expression | UNLIMITED | DEFAULT] [PASSWORD_REUSE_TIME  ...

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial