- 论坛徽章:
- 0
|
Oracle 如何能自动及时 Kill 掉已经断线的 SESSION?
不要使用缺省的PROFILE，给你的用户定义个受限制的PROFILE就可以了。
具体的参数含义如下：
Profile: General Page
Name
Name of the new profile.
Details
These fields determine the amount of time allocated to the CPU per Session, CPU per
Call, Connect Time, and Idle Time for this profile. The fields are:
CPU/Session: Total amount of CPU time allowed in a session. The limit is expressed in
seconds.
CPU/Call : Maximum amount of CPU time allowed for a call (a parse, execute, or fetch).
The limit is expressed in seconds.
Connect Time: Maximum elapsed time allowed for a session. The limit is expressed in
minutes.
Idle Time: Maximum idle time allowed in a session. Idle time is a continuous period of
inactive time during a session. Long-running queries and other operations are not
subject to this limit. The limit is expressed in minutes.
Database Services
These fields determine the database services allocated to this profile. The fields are:
Concurrent Sessions: Maximum number of concurrent sessions allowed for a user.
Reads/Session: Total number of data block reads allowed in a session. The limit includes
blocks read from memory and disk.
Reads/Call: Maximum number of data block reads allowed for a call (a parse, execute, or
fetch) to process a SQL statement.
Private SGA: Maximum amount of private space a session can allocate in the shared pool
of the System Global Area (SGA). The Private SGA limit applies only if you are using the
multi-threaded server architecture. The limit is expressed in kilobytes (Kbytes).
Composite Limit: Total resource cost for a session. The resource cost for a session is the
weighted sum of the CPU time used in the session, the connect time, the number of
reads made in the session, and the amount of private SGA space allocated.
Entering Values
You can enter a value in a field or choose from the drop-down list adjacent to the field.
Click on the down-arrow to display the list. The drop-down list provides the following
choices:
Default: Use the limit specified for this resource in the DEFAULT profile.
Unlimited: The user's access to this resource is unlimited.
Values: Select one of the existing values. The default values vary by field and are common
values for the field. If you have entered a value in the field, that value appears in the drop
-down list.
Attention: In the SQL Worksheet, you can use the SQL command ALTER RESOURCE
COST to specify the weights for the resources in the Composite Limit. For information
about the ALTER RESOURCE COST command, see the Oracle Server SQL Reference for
your release. |
|
免费注册
发表于 2003-01-14 14:46
