Home » RDBMS Server » Server Administration » Default Limit of Resources (Oracle Databse)
Default Limit of Resources [message #618868] Wed, 16 July 2014 04:21 Go to next message
mehulmehta
Messages: 2
Registered: July 2010
Junior Member
Hello,

Where can i find the default limit for the resources in profile.


[SESSIONS_PER_USER n|UNLIMITED|DEFAULT]
[CPU_PER_SESSION n|UNLIMITED|DEFAULT]
[CPU_PER_CALL n|UNLIMITED|DEFAULT]
[CONNECT_TIME n|UNLIMITED|DEFAULT]
[IDLE_TIME n|UNLIMITED|DEFAULT]
[LOGICAL_READS_PER_SESSION n|UNLIMITED|DEFAULT]
[LOGICAL_READS_PER_CALL n|UNLIMITED|DEFAULT]
[COMPOSITE_LIMIT n|UNLIMITED|DEFAULT]
[PRIVATE_SGA n [K|M]|UNLIMITED|DEFAULT]

[FAILED_LOGIN_ATTEMPTS expr|UNLIMITED|DEFAULT]
[PASSWORD_LIFE_TIME expr|UNLIMITED|DEFAULT]
[PASSWORD_REUSE_TIME expr|UNLIMITED|DEFAULT]
[PASSWORD_REUSE_MAX expr|UNLIMITED|DEFAULT]
[PASSWORD_LOCK_TIME expr|UNLIMITED|DEFAULT]
[PASSWORD_GRACE_TIME expr|UNLIMITED|DEFAULT]
[PASSWORD_VERIFY_FUNCTION function_name|NULL|DEFAULT]


Regards,
Mehul
Re: Default Limit of Resources [message #618887 is a reply to message #618868] Wed, 16 July 2014 05:16 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

It's all in the docs, http://docs.oracle.com/cd/E16655_01/network.121/e17607/authentication.htm#DBSEG30323

[Updated on: Wed, 16 July 2014 06:57]

Report message to a moderator

Re: Default Limit of Resources [message #618891 is a reply to message #618868] Wed, 16 July 2014 05:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Limits of a profile can be seen in DBA_PROFILES view.
If the value is 'DEFAULT' then this means the value for this profile and resource is the one if the DEFAULT profile.

Re: Default Limit of Resources [message #618963 is a reply to message #618887] Thu, 17 July 2014 00:42 Go to previous message
mehulmehta
Messages: 2
Registered: July 2010
Junior Member
Thank you very much.

Regards,
Mehul
Previous Topic: Free space of database
Next Topic: SQL Error: ORA-00379
Goto Forum:
  


Current Time: Tue Mar 19 06:08:31 CDT 2024