to KittyWang(Kitty) : 可以在profile中限制连接时间,空闲时间等等.........
因为服务器并不知道你的session死了 不过可以设定sqlnet.ora文件 names.initial_retry_timeout = 30 # #Syntax: 1-600 seconds #Default: 15 (OSD) # # Determines how long a client will wait for a response from a Names Server # before reiterating the request to the next server in the preferred_servers # list.
不好意思,说错了,上面的没有看就考给你了 这个是正确的 sqlnet.expire_time = 10(分钟) ######################## # #Possible values: 0-any valid positive integer! (in minutes) #Default: 0 minutes #Recommended value: 10 minutes # #Purpose: Indicates the time interval to send a probe to verify the # client session is alive (this is used to reclaim watseful # resources on a dead client) # #Supported since: v2.1 ------------------------ 以上参数设置后,服务器会检测连接是否正常,否则,10分钟后就自动kill该session
可以在profile中限制连接时间,空闲时间等等.........
不过可以设定sqlnet.ora文件
names.initial_retry_timeout = 30
#
#Syntax: 1-600 seconds
#Default: 15 (OSD)
#
# Determines how long a client will wait for a response from a Names Server
# before reiterating the request to the next server in the preferred_servers
# list.
这个是正确的
sqlnet.expire_time = 10(分钟)
########################
#
#Possible values: 0-any valid positive integer! (in minutes)
#Default: 0 minutes
#Recommended value: 10 minutes
#
#Purpose: Indicates the time interval to send a probe to verify the
# client session is alive (this is used to reclaim watseful
# resources on a dead client)
#
#Supported since: v2.1
------------------------
以上参数设置后,服务器会检测连接是否正常,否则,10分钟后就自动kill该session