best way to simulate a lost connection?

From: <>
Date: Tue, 23 Dec 2008 01:04:07 GMT
Message-ID: <bOW3l.7251$>

This for RAC 10gR2.

I would like to test my client-side application code that deals with catching and reporting a lost or broken connection to the database.

  What's the best way to simulate a connection failure?   ALTER SYSTEM KILL SESSION '$SID,$SERIAL#' via another process?   Is there an equivalent command that doesn't need to know   the RAC node?

Any pointers to other testing considerations appreciated.

Many TIA!

Mark Harrison
Pixar Animation Studios
Received on Mon Dec 22 2008 - 19:04:07 CST

Original text of this message