Re: Oracle Session

From: Sanjeev Jain <sanjeev.jain_at_mail.tju.edu>
Date: Thu, 30 Sep 1999 15:08:36 -0400
Message-ID: <37F3B534.D48598A6@mail.tju.edu>

Roopa,

Yes ofcourse, Oracle keeps good information on sessions. Each connected session is assigned a unique session id. (Though this is not true in case of Multi threaded server ,MTS). You can query v$session view for information.

By default there is no session time out. But you can configure this by defining profiles and resource limit. If you want I can tell you how to implement that.

bye,
sanjeev

rtallak_at_my-deja.com wrote:

> Hello,
>
> can anyone tell me - how Oracle keeps track of user sessions?
>
> E.g if I log into Oracle Server from my PC - does Oracle use session
> Ids etc to identify my session? Is there a session time-out? Is there
> any way I can get hold of this session information?
>
> Thanx,
> roopa
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Thu Sep 30 1999 - 14:08:36 CDT