Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 









Oracle Reading WSID
Oracle Database Tips by Donald Burleson


We're using the following string to connect to the Oracle DB Server through the OraOledb Driver:




We want to read WSID from this string in backend session for the purpose of Auditing using triggers. Is there any means of reading this information (WSID) in backend? WSID= Workstation ID

This question posed on 24 January 2006


You may want to look at the connection data inside Oracle:

column username format a12 heading 'User Name'

column program format a25 heading 'Executing|Program'

column pid format 9999

column sid format 9999

column osuser heading Operating|system|User format a10

column terminal format a10

column g_date new_value f_date noprint

select to_char(sysdate,'ddmmyyyyhh24mi') g_date from dual;

set lines 130

break on username

compute count of pid on username

set pages 58

start title132 "Oracle Processes"

spool rep_out\&db\cur_proc_&&f_date


      NVL(a.username,'Null') username,,


      decode(a.terminal,'?','Detached',a.terminal) terminal,






      v$session a,

      v$process b


      a.PADDR = b.ADDR

order by



spool off

clear breaks

clear columns


User Name     PID   SID    TERMINAL        Program          SPID       User 

------------ ----- ----- ---------- ------------------ ------- -----------

OEMMAN       14      15    MRALAPTOP2    ORACLE.EXE    2496         SYSTEM              7

                  15       14   MRALAPTOP2    ORACLE.EXE    3336         SYSTEM              8

                  16       16   MRALAPTOP2    ORACLE.EXE    3908         SYSTEM            174

                  17       11   MRALAPTOP2    ORACLE.EXE    3732         SYSTEM             14

                  18       12   MRALAPTOP2    ORACLE.EXE    132          SYSTEM             33

                  19       18   MRALAPTOP2    ORACLE.EXE    300          SYSTEM              6

                  20       19   MRALAPTOP2    ORACLE.EXE    604          SYSTEM              6

                  21       20   MRALAPTOP2    ORACLE.EXE    976          SYSTEM             12

                  22       21   MRALAPTOP2    ORACLE.EXE    4152         SYSTEM             13

************ -----
count            9

SYSTEM          23    22   MRALAPTOP2    ORACLE.EXE    2688         Mike?Ault        2851

************ -----

count            1

Null               2     1      MRALAPTOP2     ORACLE.EXE    2904         SYSTEM            1

                   3     2       MRALAPTOP2     ORACLE.EXE    2976         SYSTEM            3

                   4     3       MRALAPTOP2     ORACLE.EXE    2940         SYSTEM            1

                   5     4       MRALAPTOP2     ORACLE.EXE    2956         SYSTEM            1

                   6     5       MRALAPTOP2     ORACLE.EXE    2900         SYSTEM              1

                   7     6       MRALAPTOP2     ORACLE.EXE    2924         SYSTEM           1

                   8     7       MRALAPTOP2     ORACLE.EXE    2500         SYSTEM          1

                   9     8       MRALAPTOP2     ORACLE.EXE    2604         SYSTEM           1

                  12     9       MRALAPTOP2     ORACLE.EXE    972          SYSTEM           1

                  13    10      MRALAPTOP2      ORACLE.EXE    2608         SYSTEM           1

************ -----
count           10




Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.