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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Active users

Re: Active users

From: <fgreene_at_hayes.com>
Date: 25 Nov 92 07:54:40 EDT
Message-ID: <6395.2b133140@hayes.com>

In article <30630_at_nntp_server.ems.cdc.com>, mgrimley_at_ems.cdc.com (Mary Grimley) writes:
> I am looking for a way for a Pro*C program to retrieve a list of all
> the users who are currently using the database. I have been reading
> through the data dictionary views but I do not see any views that
> identify the active users.
>
> Does anyone know how to get this information?
>
> My operating environment is as follows:
> - ORACLE RDBMS V7.0.9.3.2 on an IBM RS/6000 AIX system.
> - I am not planning on using Oracle's auditing feature.
> - My database is a stand-alone database, not a distributed database.
>
> Thanks in advance for any help,
> Mary
>
> _____________________________________________________________________________
>
> Mary Grimley email: mgrimley_at_ems.cdc.com
> Empros Systems International phone: (612) 553-4763
> 2300 Berkshire Lane North Facility Code: PLY008
> Plymouth, MN 55441 USA
> _____________________________________________________________________________

  Check out the Dynamic Performance tables listed at the very end of   attachment E of the DBA manual. These views provide instant snapshots   of system activity. In particular, V$PROCESS should have the data you   require.


  |      Frank Greene                  |          //////  //////             |
  |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
  |      Telephone [615] 458-6032      |          ////    ////  //////       |
  |      324 Ootsima Way               |         ////    ////    ////        |
  |      Loudon, TN 37774              |        //////  //////  //////       |
 ----------------------------------------------------------------------------
  |         Of course, any opinions or suggestions are strictly my own       |
  ----------------------------------------------------------------------------
Received on Wed Nov 25 1992 - 05:54:40 CST

Original text of this message

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