Re: Time out session

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: tomday2@xxxxxxxxx
  • Date: Thu, 28 Oct 2004 16:56:00 +0100

Did u try Setting Idle_time setting in Sqlnet.ora ... That should Kick
the Session Out ...

The Last_Call_Et is the Time Elapsed since the Last Call was Made ..
So U can say How Long a Session has Been Executing a SQL by looking at
the Last_Call_Et Column.

Not sure why IDEL_TIME should not work for you .. 


On Thu, 28 Oct 2004 11:35:12 -0400, Thomas Day <tomday2@xxxxxxxxx> wrote:
> Is there a way to time out an idle terminal connected to Oracle?
> I have IDLE_TIME set to 20 in the profile and resource_limit is true.
> This does not time out an idle terminal.
> What is the meaning of the values in V_$SESSION.LAST_CALL_ET?   Oracle
> documentation is less than illuminating.  All it says is "LAST_CALL_ET
> NUMBER The last call".  This is from  Oracle9i Database
> Reference,Release 2 (9.2),Part Number A96536-02.
> Any help, examples, or stories of "how we did it" would be greatly 
> appreciated.
> --

Other related posts: