RE: What are the default values cited in "DBA_PROFILES"
From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 13 May 2008 14:20:51 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902557E5D@usahm208.amer.corp.eds.com>
Date: Tue, 13 May 2008 14:20:51 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A902557E5D@usahm208.amer.corp.eds.com>
Whoops. I had miscounted how many responses there were or how many I
had read. Bradd had already provided my info. Bummer.
- Mark D Powell --
Phone (313) 592-5148
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bradd Piontek
Sent: Monday, May 12, 2008 4:25 PM To: gus.spier_at_gmail.com Cc: oracle-l_at_freelists.org Subject: Re: What are the default values cited in "DBA_PROFILES" 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 timeand 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-lReceived on Tue May 13 2008 - 13:20:51 CDT