Re: ORACLE PROFILE

  • From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
  • To: mhdmehraj@xxxxxxxxx
  • Date: Tue, 26 May 2009 11:33:39 +0100

Mohammed

" if the profile that is explicitly assigned to a user omits limits for some
resources or specifies DEFAULT for some limits, then the user is subject to
the limits on those resources defined by the DEFAULT profile."

"The DEFAULT profile initially defines unlimited resources. You can change
those limits with the ALTER PROFILE statement."

So - the value will (by default) be UNLIMITED... See CREATE
PROFILE<http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_6010.htm>

Regards Nigel

2009/5/26 Mohammed Mehraj hussain <mhdmehraj@xxxxxxxxx>

> hi ,iam creating a profile like
> CREATE PROFILE

...

>
> in the above statement if i dint specify CPU_PER_SESSION   , what the
> value will be assigned for this  profile .
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts:

  • » ORACLE PROFILE- Mohammed Mehraj hussain
  • » Re: ORACLE PROFILE - Nigel Thomas