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

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 13 May 2008 14:20:51 -0400

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


Other related posts: