oracle sql_trace session级为什么会无文件产生？

xyz3000

是dead connection.l

在服务器上sqlnet.ora中设置
sqlnet.expire_time=10可以清除.

arab_archon

好，我试试。多谢啦

Fenng

呵呵，莫非是MTS ?

用吻封笺

关注

arab_archon

对不起，年后才把问题给接上。
数据库不是mts

Oracle Net Manager Field/Option sqlnet.ora File Parameter Description
TNS Time Out Value
SQLNET.EXPIRE_TIME
Use to specify a specify the time interval, in seconds, to send a probe to verify that client/server connections are active. Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination. If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server process to exit. This setting is intended for the database server, which typically handles multiple connections at any one time.

Limitations on using this terminated connection detection feature are:

It is not allowed on bequeathed connections.
Though very small, a probe packet generates additional traffic that may downgrade network performance.
Depending on which operating system is in use, the server may need to perform additional processing to distinguish the connection probing event from other events that occur. This can also result in downgrading network performance.


在服务器上sqlnet.ora中设置 sqlnet.expire_time=10后，
PID USERNAME THR PR NCE SIZE RES STATE TIME FLTS CPU COMMAND
22799 oracle 1 0 0 1.9G 1.9G cpu03 100.2H 0 24.94% oracle
23140 oracle 1 0 0 1.9G 1.9G cpu02 100.0H 0 24.94% oracle
两个进程依然消耗大量cpu资源，并没有被自动kill掉。

arab_archon

另外通过top 显示看到STAT 下面，两个进程都在使用cpu，正在运行的啊。我的服务器有4个cpu，所以他们在轮换的使用cpu ,就是不释放，而且累计占用了很长的cpu时间了。