Re: Oracle Session

I am using Oracle, MTS, VB.

I want to set data in V$Session Data at the beginning of a Transaction and Reset it at the end if the Transaction. This will be used by packages and triggers.

Is there any way that I be guaranteed that all ADO connections used within a transaction will use the same connection?

If this is not possible, is there a way that I can hook in to do pre / post processing with all connections that are dispensed?

Thanks

Sanjeev Jain wrote:

> 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 Oct 07 1999 - 01:34:21 CDT