DB Connection Timeout simulation

Question

Is there an way to simulate a db connection timeout?

I'm encountering problems with a timeouted db connection on a productive system and need to simulate a similar situation.

Can't you just reduce the timeout to something smaller and more managable? — Antony Scott, Aug 04 '11 at 08:58

score 0 · Answer 1 · answered Oct 31 '18 at 01:44

0

Try to connect to a non-existing host or port, and you will get the connection timeout.

answered Oct 31 '18 at 01:44

Terry

score 0 · Answer 2 · answered Nov 30 '11 at 13:36

0

One way that this could be simulated is by killing the connection directly in the database:

Oracle:

select * from v$session
where machine like '%machinename%'
order by sid desc

-- SID, SERIAL
alter system kill session '1080,16345'

answered Nov 30 '11 at 13:36

paweloque

2 Answers2