11g Default Profile Changes 4r74k

Document

1 of 2

https://.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-sta...

11G DEFAULT Profile Changes [ID 454635.1] Modified: Nov 18, 2011

Type: BULLETIN

Status: PUBLISHED

Priority: 3

In this Document Purpose Scope and Application 11G DEFAULT Profile Changes

Applies to: Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.3 - Release: 11.1 to 11.2 Information in this document applies to any platform. ***Checked for relevance on 18-Nov-2011***

Purpose This bulletin explains the changes made to the DEFAULT Profile in Oracle Database 11g.

Scope and Application The intention is to give an overview of the DEFAULT profile in Oracle Database 11g and compare it with Oracle Database 10g

11G DEFAULT Profile Changes Following is the result from a 10G database. In 10g, most of the resource limits are set to UNLIMITED. In 10g:

SQL> select resource_name,limit from dba_profiles where profile='DEFAULT'; RESOURCE_NAME -----------------------------COMPOSITE_LIMIT SESSIONS_PER_ U_PER_SESSION U_PER_CALL LOGICAL_READS_PER_SESSION LOGICAL_READS_PER_CALL IDLE_TIME CONNECT_TIME PRIVATE_SGA FAILED__ATTEMPTS _LIFE_TIME _REUSE_TIME _REUSE_MAX __FUNCTION _LOCK_TIME _GRACE_TIME

LIMIT ---------------------------------------UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED 10 UNLIMITED UNLIMITED UNLIMITED NULL UNLIMITED UNLIMITED

16 rows selected.

Changes are made in 11G for specific parameters. Default value of UNLIMITED is replaced for some parameters. Here are the parameter values for default profile in 11g database

In 11g

SQL> select resource_name,limit from dba_profiles where profile='DEFAULT';

1/15/2013 12:28 PM

Document

2 of 2

https://.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-sta...

RESOURCE_NAME -----------------------------FAILED__ATTEMPTS __FUNCTION _REUSE_MAX _REUSE_TIME PRIVATE_SGA CONNECT_TIME IDLE_TIME LOGICAL_READS_PER_CALL LOGICAL_READS_PER_SESSION U_PER_CALL U_PER_SESSION SESSIONS_PER_ COMPOSITE_LIMIT _GRACE_TIME _LIFE_TIME _LOCK_TIME

LIMIT ---------------------------------------10 NULL UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED 7 180 1

16 rows selected.

We can see that the values for parameters _GRACE_TIME,_LIFE_TIME and _LOCK_TIME are changed in 11g Here is the description of these parameters: Parameter

Default Setting

Description

FAILED__ATTEMPTS 10

Sets the maximum times a try to and to fail before locking the .

_GRACE_TIME

7

Sets the number of days that a has to change his or her before it expires.

_LIFE_TIME

180

Sets the number of days the can use his or her current .

_LOCK_TIME

1

Sets the number of days an will be locked after the specified number of consecutive failed attempts.

If you choose to change these values for DEFAULT Profile, you can do so using the following sql: SQL> ALTER PROFILE DEFAULT limit ; Example:

SQL> ALTER PROFILE DEFAULT limit _GRACE_TIME 8; Profile altered. SQL> select resource_name,limit from dba_profiles where profile='DEFAULT'; RESOURCE_NAME LIMIT ---------------------------- ------------------------------------_GRACE_TIME 8

1/15/2013 12:28 PM