Shulou(Shulou.com)06/01 Report--

Profile

Use the parameter RESOURCE_LIMIT

RESOURCE_LIMIT determines whether resource limits are enforced in database profiles

RESOURCE_LIMIT decides whether to enforce resource restrictions in the database profile

Resource limits for passwords work even with resource_limit = false

Resource restrictions for password will take effect even if resource_limit = false

If this parameter is false, it is found that FAILED_LOGIN_ATTEMPTS is in effect normally, that is, the user is locked out after entering the password 10 times.

Resource parameters has 16 parameters, as shown in the resource_name of the sql query above

SELECT resource_name FROM dba_profiles where profile='DEFAULT' order by 1

SESSIONS_PER_USER:pecify the number of concurrent sessions to which you want to limit the user.

Limit the maximum number of concurrent sessions allowed per user.

CPU_PER_SESSION:Specify the CPU time limit for a session, expressed in hundredth of seconds.

Limit the CPU time that can be used per session. The parameter value is an integer in 1% seconds.

CPU_PER_CALL:Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds.

Lets you specify the maximum CPU time, in 1% seconds, that each SQL statement can take.

CONNECT_TIME:Specify the total elapsed time limit for a session, expressed in minutes.

Limit the maximum amount of time each session can connect to the database, after which the session will automatically disconnect. The parameter value is an integer in minutes.

IDLE_TIME:Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.

Limit the maximum continuous idle time allowed for each session, after which the session will be disconnected automatically. The parameter value is an integer in minutes.

LOGICAL_READS_PER_SESSION:Specify the permitted number of data blocks read in a session, including blocks read from memory and disk.

Limit the number of blocks that can be read per session.

LOGICAL_READS_PER_CALL:Specify the permitted number of data blocks read for a call to process a SQL statement (a parse, execute, or fetch).

Used to specify the maximum number of blocks that can be read per SQL statement.

PRIVATE_SGA:Specify the amount of private space a session can allocate in the shared pool of the system global area (SGA). Refer to size_clause for information on that clause.

The size of the private SGA zone allocated per session, in bytes. This parameter is valid only for shared server mode.

COMPOSITE_LIMIT:Specify the total resource cost for a session, expressed in service units. Oracle Database calculates the total service units as a weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA.

Specifies the total resource cost of the session in service units. The Oracle database calculates the total service unit as a weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA.

There are seven password-related ones left.

FAILED_LOGIN_ATTEMPTS

PASSWORD_LIFE_TIME

PASSWORD_REUSE_TIME

PASSWORD_REUSE_MAX

PASSWORD_LOCK_TIME

PASSWORD_GRACE_TIME

PASSWORD_VERIFY_FUNCTION

RESOURCE_MANAGER_PLAN, corresponding package dbms_resource_manager

You can see which consumer groups calls this plan in a plan.

You can see which users are in a consumer groups.

Use the parameter RESOURCE_MANAGER_PLAN

RESOURCE_MANAGER_PLAN specifies the top-level resource plan to use for an instance.

The resource manager will load this top-level plan along with all its descendants (subplans, directives, and consumer groups). If you do not specify this parameter, the resource manager is off by default.

RESOURCE_MANAGER_PLAN specifies the top-level resource plan to be used for an instance

The resource manager will load the top-level plan (subplans, instructions, and consumer groups) with all its descendants. If you do not specify this parameter, the explorer is turned off by default.

RESOURCE_MANAGER_PLAN = plan_name

There are mainly five parameter classes with the following red font, each of which has a specific parameter configuration

Parallelism:Specify a limit on the degree of parallelism for any operation issued by this consumer group, a limit on the total number of parallel servers that can be used by all sessions in this consumer group, and the maximum time a parallel statement can be queued.

Max Degree of Parallelism

Max Percentage of Parallel Servers Target

Parallel Queue Timeout

Parallelism: specifies a limit on the degree of parallelism of any operation issued by this consumer group, the limit on the total number of parallel servers available to all sessions in this consumer group, and the maximum amount of time parallel statements can be queued.

There are three main parameters as follows

Maximum parallelism

Maximum parallelism percentage of the target server

Parallel queue timeout

Session Pool:Specify a limit on the maximum number of concurrently active sessions for a consumer group. All other sessions will wait in an activation queue.

Max Number of Active Sessions

Activation Queue Timeout (sec)

Session pool: specifies the maximum number of sessions currently active for the consumer group. All other sessions will wait in the activation queue.

There are two main parameters as follows

Maximum number of active sessions

Activation queue timeout, in second

Undo Pool:Specify the maximum amount of undo that can be active and uncommitted for a consumer group.

Max Undo Space (KB)

Rollback pool: specifies the maximum number of rollbacks for active and uncommitted consumer groups.

The main parameters are as follows

Maximum rollback space, in KB

Thresholds:Specify the time duration or the resource limits under which a session can execute in a consumer group. If any of the limits are exceeded, the session can be switched to another consumer group, the session's SQL operation can be canceled, or the session can be killed.

Execution Time Limit (Sec)

I am O Limit (MB)

I am O Request Limit (Requests)

Threshold: specifies the session time or resource limit for a consumer group. If any limit is exceeded, the session can be switched to another consumer group, the SQL operation of the session can be cancelled, or the session can be killed.

The main parameters are as follows

Execution time limit (in second)

MB O limit (in unit)

Number of requests per unit of request limit for Icano

Idle Time:Specify the maximum time a session in the consumer group can be idle.

Max Idle Time (sec)

Max Idle Time if Blocking Another Session (sec)

Idle time: the maximum idle time for the session of the specified consumer group.

The main parameters are as follows

Maximum idle time, in second

Maximum idle time (in seconds) when blocking another session

The only thing they have in common is Idle Time. Profile is for users who use this profile, and RESOURCE_MANAGER_PLAN is for users in a Consumer Group that uses this plan.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.