Oracle-L: Re: Oracle Timeouts

From: Kaing, Leng M <LKaing_at_VENTNDS1.TELECOM.COM.AU>
Date: Mon, 15 Jan 1996 22:11:17 -0500
Message-Id: <9601160327.AA21945@alice.jcc.com>

Darrly,

I think you'll have to look at user profiles. You can place various limits such as sessions_per_user, cpu_per_session, cpu_per_call idle_time etc. Perhaps a combination of these would help time out a transaction. But I doubt it.

Regards,
Leng.

From: Darryl Sladden
To: leng
Subject: Oracle Timeouts
Date: Monday, January 15, 1996 4:40PM

Is there a way to set a timeout in Oracle 7.0?

If user 1 issue's a update against table A and does not commit then user 2 has to wait for user 1 to commit or rollback before she can perform an update against table A.

Is there a way to time user 1's transaction out?

Thanks for your help. Received on Mon Jan 15 1996 - 22:27:48 CST