Re: Oracle Session

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 30 Sep 1999 19:06:14 GMT
Message-ID: <37f3b3da.6270421@news.demon.nl>

On Thu, 30 Sep 1999 18:39:13 GMT, 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.

select sid, serial#, program from v$session (amongst others, describe the v$session view for more info)
This will list the client info.
To get info about your current session
use
select *
from v$session where audsid = userenv('sessionid')

There is also a v$process view, which list the associated background processes on the server.
There is no session time out, unless you created a profile with an idle-time and associated that with a particular user. This info is stored in dba_users.

Hth,
Sybrand Bakker, Oracle DBA Received on Thu Sep 30 1999 - 14:06:14 CDT