Re: What are the default values cited in "DBA_PROFILES"

Answering my own question:

select * from user_resource_limits
/

This table will actually tell the user what limit is placed on the user's consumption of resources.

Sorry for the noise.

r,

Gus

On Mon, May 12, 2008 at 4:12 PM, Gus Spier <gus.spier_at_gmail.com> wrote:

> Mea culpa, mea maxima culpa, but I'm pressed for time and still cannot
> find the correct document that exposes the actual values in DBA_PROFILES.
>
> SELECT * FROM DBA_PROFILES WHERE PROFILE = 'SERVICE_ACCOUNT'
> /
>
> PROFILE RESOURCE_NAME RESOURCE LIMIT
> ------------------- --------------------------- -------- ------
> SERVICE_ACCOUNT COMPOSITE_LIMIT KERNEL DEFAULT
> SERVICE_ACCOUNT LOGICAL_READS_PER_SESSION KERNEL DEFAULT
> SERVICE_ACCOUNT SESSIONS_PER_USER KERNEL DEFAULT
> SERVICE_ACCOUNT CPU_PER_SESSION KERNEL DEFAULT
> SERVICE_ACCOUNT CPU_PER_CALL KERNEL DEFAULT
> ...
>
> "Default" doesn't help me. What is the value? Where, in which document,
> do I find it written down?
>
> Thanks in advance for any help you can send.
>
> r,
>
> Gus
>

--
http://www.freelists.org/webpage/oracle-l