Oracle 如何能自動及時 Kill 掉已經斷線的 SESSION?

mys3721

對于遠程撥號連接到Oracle數據庫的用戶，由于斷線或其它原因，實際上客戶端與數據庫的連接已經斷開，Oracle如何能及時發(fā)現，并刪除其會話？

lnx3000

PMON進程就是干這個的吧？

gototop

沒錯，oracle會自動處理：）

chaoping

用一下dead connection detection.

chwchw

chaoping,能否解釋一下如何使用？
謝謝!

swz_19981018

pMON進程會自動地處理：首先假設該進程的標志有效，然后刪除掉所有的該用戶的所有占用資源，然后段掉該用戶與數據庫的連接。

sql2000

不要使用缺省的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.