3 Replies Latest reply: Apr 21, 2014 4:13 AM by Jr.raj RSS

    v$session info

    941949

      dear all,

                    how are you? i need your valuable help ,i m getting the output of the query

      sql>select program from v$session;

       

      the output is as shown below

      program:

      -----------

      JDBC Thin Client

      OSPMS.exe

      toad.exe 

      FNDSM@orclapps.org.in

      dis51ws@orcldisc.org.in

      plsqldev.exe

      emagent@orcldb.org.in

      RCVOLTM@orclapps.org.in

      INVMGR@orclapps.org.in

      STANDARD@orclapps.org.in

      FNDSCH@orclapps.org.in

      CRM@orclapps.org.in

                                     the above is the output of the query "select program from v$session",my question is how can i come to know,how many number of users using dicoverer,toad,sqlplus etc. your help appreciated,thanks in advance.

       

      Best regards.