From: Nigel Thomas <>
Date: Tue, 26 May 2009 11:33:39 +0100
Message-ID: <>


" 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<>

Regards Nigel

2009/5/26 Mohammed Mehraj hussain <>

> hi ,iam creating a profile like

> in the above statement if i dint specify CPU_PER_SESSION , what the
> value will be assigned for this profile .
> --

Received on Tue May 26 2009 - 05:33:39 CDT

Original text of this message