OraFAQ Forum: Networking and Gateways » sqlnet.recv

Home » RDBMS Server » Networking and Gateways » sqlnet.recv_timeout parameter (oracle 10.2.0.3 on hp-ux pa-risc 64 bit)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

sqlnet.recv_timeout parameter [message #384132]

Mon, 02 February 2009 04:43

seema.taunk
Messages: 96
Registered: October 2006

Member

Dear all,

We have set sqlnet.rev_timeout=1800 in our database . But still we are getting inactive sessions which are 3 days old.
Please guide.

Thanks,
Seema

Report message to a moderator

Re: sqlnet.recv_timeout parameter [message #387467 is a reply to message #384132]

Thu, 19 February 2009 05:54

babuknb
Messages: 1702
Registered: December 2005
Location: NJ

Senior Member

Quote:

#sqlnet.connect_timeout = 5
########################
#
#Possible values: 0-any valid positive integer (in seconds)
#Default: 0
#Recommended value: 5 seconds (note: this is highly application dependent)
#
#Purpose: Indicates the time interval within which the database session
# establishment between a client and a server must be completed.
# If the client fails to establish a DB session within the given
# time period, then the server will shut down the connection.
# This can be used to counter Denial of Service attacks in
# which malicious clients may cause numberous servers to be spawn
# without DB sessions being fully established.
#
# A value of 0 turns off the timeout feature. If a spurious
# timeout error occurs (e.g. due to a slow network/system),
# reconfigure this parameter to a larger value.
#

Report message to a moderator