| dba_profile [message #464425] |
Thu, 08 July 2010 01:42  |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
Hi All,
I have just created a profile as below.
create profile test_idle limit idle_time 360;
When i queried the dba_profiles view, I observed that the LIMIT
value mentioned as DEFAULT. Can anyone guide what is the
Default values for every resource name.
TEST_IDLE COMPOSITE_LIMIT KERNEL DEFAULT
TEST_IDLE SESSIONS_PER_USER KERNEL DEFAULT
TEST_IDLE CPU_PER_SESSION KERNEL DEFAULT
TEST_IDLE CPU_PER_CALL KERNEL DEFAULT
TEST_IDLE LOGICAL_READS_PER_SESSION KERNEL DEFAULT
TEST_IDLE LOGICAL_READS_PER_CALL KERNEL DEFAULT
TEST_IDLE IDLE_TIME KERNEL 360
TEST_IDLE CONNECT_TIME KERNEL DEFAULT
TEST_IDLE PRIVATE_SGA KERNEL DEFAULT
TEST_IDLE FAILED_LOGIN_ATTEMPTS PASSWORD DEFAULT
TEST_IDLE PASSWORD_LIFE_TIME PASSWORD DEFAULT
TEST_IDLE PASSWORD_REUSE_TIME PASSWORD DEFAULT
TEST_IDLE PASSWORD_REUSE_MAX PASSWORD DEFAULT
TEST_IDLE PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
TEST_IDLE PASSWORD_LOCK_TIME PASSWORD DEFAULT
TEST_IDLE PASSWORD_GRACE_TIME PASSWORD DEFAULT
For the another profile LIMIT value is mentioned as UNLIMITED.
Thanks in advance.
Regards,
Chandu
|
|
|
|
| Re: dba_profile [message #464435 is a reply to message #464425] |
Thu, 08 July 2010 01:54  |
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
THe defaults are as in the DEFAULT prifile,
select RESOURCE_NAME,LIMIT from dba_profiles where profile='DEFAULT'; |
|
|
|
| Re: dba_profile [message #464449 is a reply to message #464435] |
Thu, 08 July 2010 02:16 |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
Hi,
That is fine. But my question is:
For example: I have the below query result.
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------- ------------- ---------- -------
TEST_IDLE CPU_PER_SESSION KERNEL DEFAULT
Now what the default (marked in red) indicates. How can i
know the value of CPU_PER_SESSION. For the Default profile
I have the values as UNLIMITED for CPU_PER_SESSION.
Please find the below for DEFAULT profile.
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------- ------------- ---------- -------
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
Thanks for early reply.
Regards,
Chandu.
|
|
|
|
|
|
| Re: dba_profile [message #464463 is a reply to message #464454] |
Thu, 08 July 2010 02:37 |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
Hi,
For example: I have the below query result.
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------- ------------- ---------- -------
TEST_IDLE CPU_PER_SESSION KERNEL DEFAULT
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
Means I have 2 profiles one named as TEST_IDLE and another as DEFAULT. For TEST_IDLE profile, CPU_PER_SESSION LIMIT is DEFAULT but for DEFAULT profile, CPU_PER_SESSION LIMIT is UNLIMITED.
Unlimited in the sense, we can have the unlimited access for CPU_PER_SESSION.
in the same way
DEFAULT means how much will be the CPU_PER_SESSION.
Regards,
Chandu.
|
|
|
|
| Re: dba_profile [message #464465 is a reply to message #464463] |
Thu, 08 July 2010 02:40 |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You still don't understand.
DEFAULT in your result means: "refer to the DEFAULT profile to know what is the limit".
In your case, the DEFAULT profile as an UNLIMITED limit, so your profile as an UNLIMITED limit.
Now if you modify the DEFAULT profile then your profile inherits a new limit from this DEFAULT profile.
Is this clear?
Regards
Michel
[Updated on: Thu, 08 July 2010 02:40] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
