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>


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 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 Tue May 13 2008 - 13:20:51 CDT

Original text of this message