Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: OO40 user never shows up in v$session ?

Re: OO40 user never shows up in v$session ?

From: Matt Griffiths <nospam_itsystems_at_dial.pipex.com>
Date: 1998/04/07
Message-ID: <352a6a8d.38191786@192.168.0.1>#1/1

Hi Bill

The connection shows in v$session whiles the oradatabase object exists in your program , and it only exists whilst the object is still in focus or is still referenced. Pause your application whilst the object is in focus are query v$session - you should see it there.

regards

Matt

On Fri, 03 Apr 1998 18:21:08 -0800, Bill Dietrich <bill_dietrich_at_wayfarer.com> wrote:

>I have written a program which uses Oracle Objects For OLE (OO4O) to
>access an Oracle 7.3.3 database. It works. But the user it connects
>as never shows up in the v$session table, in the USERNAME column.
>
>How can I see when my program's user is connected to the database,
>and how many simultaneous connections it may be using ?
>
>Thanks,
>
>Bill Dietrich
>bill_dietrich_at_wayfarer.com
>
>
Received on Tue Apr 07 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US