Who am I in v$session view??? 
Author Message
 Who am I in v$session view???
Does anyone know how to determine, using the v$session view, which
session is "me"???

Thanks in advance!

Rick



Sun, 31 Aug 2003 02:44:02 GMT
 Who am I in v$session view???

Hi!
"Me" have the sessionid from the query below, if it is run in "me"'s session

 select userenv('SESSIONID')
 from dual;

Join this number with AUDSID in v$session.

Frank



Sun, 31 Aug 2003 02:58:17 GMT
 Who am I in v$session view???

Try this (include different columns depending on what you want):

SQL> select sid,serial#,username from v$session;

       SID    SERIAL# USERNAME
---------- ---------- ------------------------------
         1          1
         2          1
         3          1
         4          1
         5          1
         6          1
         7       7037
         8       7037
         9       7037
        10       7037
        11        322 STEVE

11 rows selected.

Hope this helps,
Steve

Quote:

> Does anyone know how to determine, using the v$session view, which
> session is "me"???

> Thanks in advance!

> Rick



Sun, 31 Aug 2003 03:12:16 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. I am not able to see my database class members in class view - Please help

2. HELP: I am desperate(view problems)

3. Creaste a view based on v_$session

4. v$session view

5. OraUser in v$session view

6. View V$SESSION

7. V$SESSION View

8. V$SESSION who can access to this view

9. v$session VIEW Question

10. Problem with the v$session view.

11. I am getting this message when i am tring to export or import anything using


 
Powered by phpBB® Forum Software