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

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Mon, 12 May 2008 15:24:52 -0500
Message-ID: <e9569ef30805121324s5e8a2c55h2dac3a895042f312@mail.gmail.com>


SELECT * FROM dba_profiles where profile = 'DEFAULT';

On 5/12/08, 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
Received on Mon May 12 2008 - 15:24:52 CDT

Original text of this message