Re: SQL*Net expire_time parameter

Roderick Manalac <rmanalac_at_oracle.com> wrote:
>rblizard_at_bb.cmcsys.com (Bob Blizard) writes:
>|>
>|> What I don't know, and haven't seen explained clearly, is this; If my
>|> PC crashes and I reboot and reconnect within the time of my
>|> expire_time parameter, Will SQL*Net know that my PC went away? In
>|> other words, does it check using session or process id, or simply
>|> using ip address?
>
>A TCP/IP expert might be able to provide the technical details, but
>SQL*Net (and TCP/IP) should be able to detect that your PC has rebooted
>because the TCP/IP connection is identified by more than just the IP
>address. Think about how TCP/IP would deal with the case where a client
>has two concurrent sessions open to the same server machine (fairly
>common in a Unix <-> Unix environment).

Does Oracle have any plans to change Sqlnet so that it a broken session is reastablished on reconnect?

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com