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 >