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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bradd Piontek Sent: Monday, May 12, 2008 4:25 PM To: gus.spier@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx 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@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