LICENSE_MAX_SESSIONS

Property	Description
Parameter type	Integer
Default value	0
Modifiable	ALTER SYSTEM
Range of values	0 to number of session licenses
Basic	No
Real Application Clusters	Multiple instances can have different values, but the total for all instances mounting a database should be less than or equal to the total number of sessions licensed for that database.

LICENSE_MAX_SESSIONS specifies the maximum number of concurrent user sessions allowed. When this limit is reached, only users with the RESTRICTED SESSION privilege can connect to the database. Users who are not able to connect receive a warning message indicating that the system has reached maximum capacity.

A zero value indicates that concurrent usage (session) licensing is not enforced. If you set this parameter to a nonzero number, you might also want to set LICENSE_SESSIONS_WARNING (see "LICENSE_SESSIONS_WARNING").

Do not enable both concurrent usage licensing and user licensing. Set either LICENSE_MAX_SESSIONS or LICENSE_MAX_USERS to zero.

Note:

1. Related: V$LICENSE, parameter LICENSE_SESSIONS_WARNING and LICENSE_MAX_USERS.      

  Users received ORA-19 if they are not allowed to connect.

  Eg:  ORA-19 "maximum number of session licenses exceeded"

  Messages are written to the alert log for each connect attempt made once LICENSE_MAX_SESSIONS is reached.

  Eg: If the user has RESTRICTED SESSION privilege:

             "License maximum (10) exceeded, DBA logon allowed"

      If the user was refused from connecting:

             "Non-DBA logon denied; current logons equal maximum (10)"

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LICENSE_MAX_SESSIONS’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
license_max_sessions	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	maximum number of non-system user sessions allowed

Oracle initializatoin parameters

LDAP_DIRECTORY_SYSAUTH

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

I have stopped updating the blog.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

===================================================================

Property	Description
Parameter type	String
Syntax	LDAP_DIRECTORY_SYSAUTH = { yes | no }
Default value	no
Modifiable	No
Basic	Yes

LDAP_DIRECTORY_SYSAUTH enables or disables directory-based authorization for SYSDBA and SYSOPER.
Note:

1. This parameter was introduced in 11g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LDAP_DIRECTORY_SYSAUTH’;

Oracle initializatoin parameters

LDAP_DIRECTORY_ACCESS

Property	Description
Parameter type	String
Syntax	LDAP_DIRECTORY_ACCESS = { NONE | PASSWORD | SSL }
Default value	NONE
Modifiable	ALTER SYSTEM
Basic	No

LDAP_DIRECTORY_ACCESS specifies whether Oracle refers to Oracle Internet Directory for user authentication information. If directory access is turned on, then this parameter also specifies how users are authenticated.

Values:

· NONE

Oracle does not refer to Oracle Internet Directory for Enterprise User Security information.

· PASSWORD

Oracle tries to connect to the enterprise directory service using the database password stored in the database wallet. If that fails, then the Oracle Internet Directory connection fails and the database will not be able to retrieve enterprise roles and schema mappings upon enterprise user login.

· SSL

Oracle tries to connect to Oracle Internet Directory using SSL.

Note:

1. This parameter was introduced in 10g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LDAP_DIRECTORY_ACCESS’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
ldap_directory_access	NONE	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	RDBMS's LDAP access option

Oracle initializatoin parameters

LARGE_POOL_SIZE

Property	Description
Parameter type	Big integer
Syntax	LARGE_POOL_SIZE = integer [K | M | G]
Default value	If SGA_TARGET is set, but a value is not specified for LARGE_POOL_SIZE, then the default is 0 (internally determined by the Oracle database). If LARGE_POOL_SIZE is specified, then the user-specified value indicates a minimum value for the memory pool. If SGA_TARGET is not set, 0 if both of the following are true: · The pool is not required by parallel execution · DBWR_IO_SLAVES is not set Otherwise, derived from the values of PARALLEL_MAX_SERVERS, PARALLEL_THREADS_PER_CPU, CLUSTER_DATABASE_INSTANCES, DISPATCHERS, and DBWR_IO_SLAVES. Note that a value derived in this way does not take into account the requirements used for Automatic Storage Management files. As a general guideline, you should add 600K to the size of the SGA on a database instance using ASM.
Modifiable	ALTER SYSTEM
Range of values	300 KB to at least 2 GB (actual maximum is operating system-specific)
Basic	No

LARGE_POOL_SIZE specifies (in bytes) the size of the large pool allocation heap. The large pool allocation heap is used in shared server systems for session memory, by parallel execution for message buffers, and by backup processes for disk I/O buffers. Parallel execution allocates buffers out of the large pool only when SGA_TARGET is set.

Caution:

When Oracle derives a default value, it adds 250K for each session for the shared server if DISPATCHERS is configured. The final derived value also includes a port-specific amount of memory for backup I/O buffers. The total derived default value can either be too large to allocate or can cause performance problems. In that case, set LARGE_POOL_SIZE to a number sufficiently small so that the database can start.

You can specify the value of this parameter using a number, optionally followed by K or M to specify kilobytes or megabytes, respectively. If you do not specify K or M, then the number is taken as bytes.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LARGE_POOL_SIZE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
large_pool_size	167772160	FALSE	FALSE	IMMEDIATE	TRUE	FALSE	size in bytes of large pool

Oracle initializatoin parameters

JOB_QUEUE_PROCESSES

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

========================================================================

Property	Description
Parameter type	Integer
Default value	1000
Modifiable	ALTER SYSTEM
Range of values	0 to 1000
Basic	Yes
Real Application Clusters	Multiple instances can have different values.

JOB_QUEUE_PROCESSES specifies the maximum number of processes that can be created for the execution of jobs. It specifies the number of job queue processes per instance (J000, ... J999). Replication uses job queues for data refreshes. Advanced queuing uses job queues for message propagation. You can create user job requests through the DBMS_JOB package.
Some job queue requests are created automatically. An example is refresh support for materialized views. If you wish to have your materialized views updated automatically, you must set JOB_QUEUE_PROCESSES to a value of one or higher.
Note:
1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘JOB_QUEUE_PROCESSES’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
job_queue_processes	10	FALSE	FALSE	IMMEDIATE	TRUE	FALSE	number of job queue slave processes

Oracle initializatoin parameters

V$WAITSTAT

V$WAITSTAT displays block contention statistics. This table is only updated when timed statistics are enabled.

Column	Datatype	Description
CLASS	VARCHAR2(18)	Class of the block
COUNT	NUMBER	Number of waits by this OPERATION for this CLASS of block
TIME	NUMBER	Sum of all wait times for all the waits by this OPERATION for this CLASS of block

Note:

1.

select * from V$WAITSTAT;

CLASS	COUNT	TIME
data block	847238	382988
sort block	0	0
save undo block	0	0
segment header	1635	245
save undo header	0	0
free list	0	0
extent map	0	0
1st level bmb	31	23
2nd level bmb	24	14
3rd level bmb	0	0
bitmap block	0	0
bitmap index block	0	0
file header block	1116	17
unused	0	0
system undo header	0	0
system undo block	0	0
undo header	4604	133
undo block	701312	21200

Oracle data dictionary views

Oracle dynamic performance views