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

You could also query dba_profiles for the values assigned to "DEFAULT"  

PROFILE              RESOURCE_NAME                    RESOURCE LIMIT
-------------------- -------------------------------- --------
------------
DEFAULT              COMPOSITE_LIMIT                  KERNEL   UNLIMITED
DEFAULT              FAILED_LOGIN_ATTEMPTS            PASSWORD UNLIMITED
DEFAULT              SESSIONS_PER_USER                KERNEL   UNLIMITED
DEFAULT              PASSWORD_LIFE_TIME               PASSWORD UNLIMITED
DEFAULT              CPU_PER_SESSION                  KERNEL   UNLIMITED
DEFAULT              PASSWORD_REUSE_TIME              PASSWORD UNLIMITED
DEFAULT              CPU_PER_CALL                     KERNEL   UNLIMITED
DEFAULT              PASSWORD_REUSE_MAX               PASSWORD UNLIMITED
DEFAULT              LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED
DEFAULT              PASSWORD_VERIFY_FUNCTION         PASSWORD NULL
DEFAULT              LOGICAL_READS_PER_CALL           KERNEL   UNLIMITED
DEFAULT              PASSWORD_LOCK_TIME               PASSWORD UNLIMITED
DEFAULT              IDLE_TIME                        KERNEL   UNLIMITED
DEFAULT              PASSWORD_GRACE_TIME              PASSWORD UNLIMITED
DEFAULT              CONNECT_TIME                     KERNEL   UNLIMITED
DEFAULT              PRIVATE_SGA                      KERNEL   UNLIMITED
 

16 rows selected.  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gus Spier

	Sent: Monday, May 12, 2008 4:17 PM
	To: oracle-l_at_freelists.org
	Subject: Re: What are the default values cited in "DBA_PROFILES"
	
	
	Answering my own question:
	 
	select * from user_resource_limits
	/
	 
	This table will actually tell the user what limit is placed on

        Sorry for the noise.          

        r,          

        Gus                  

        On Mon, May 12, 2008 at 4:12 PM, 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