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