Mar 182013
create profile highly_restricted limit 
  cpu_per_session 1
  sessions_per_user 1
  logical_reads_per_session 10
  logical_reads_per_call 10;

alter user cowboy_developer 
profile highly_restricted;

Profiles have been superceded by the DB Resource Manager for limiting resource usage, 
however profiles are still very useful for setting password timeouts, locks, etc.

To try this out yourself, use this script.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>