Re: What are the default values cited in "DBA_PROFILES"
- From: "Gus Spier" <gus.spier@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 May 2008 16:16:58 -0400
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@xxxxxxxxx> 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
>
Other related posts:
