OraFAQ Forum: SQL & PL/SQL » dba

Home » SQL & PL/SQL » SQL & PL/SQL » dba_profile (oracle 9i, aix5.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: dba_profile [message #464435 is a reply to message #464425]

Thu, 08 July 2010 01:54

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

THe defaults are as in the DEFAULT prifile,

Code: [Select all] [Show/ hide]

select RESOURCE_NAME,LIMIT from dba_profiles where profile='DEFAULT';

Report message to a moderator

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.

Report message to a moderator

Re: dba_profile [message #464454 is a reply to message #464425]

Thu, 08 July 2010 02:24

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

I am sorry if still isn't clear. I have already given the answer: THe DEFAULT profile has the current default values. I don't know what you have set them to.

[Updated on: Thu, 08 July 2010 02:28]

Report message to a moderator

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.

Report message to a moderator

Re: dba_profile [message #464465 is a reply to message #464463]

Thu, 08 July 2010 02:40

Michel Cadot
Messages: 68756
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

Previous Topic:	find out date difference in day-month-yyyy
Next Topic:	Calculate the Outage time for each day

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 14:42:55 CDT 2025