v$session and v$process
Hi,
OS : Red hat 4.2/5 and Aix 5
Db : 10
1,What is the difference between terminal and machine in V$SESSION.
SQL> select terminal,machine from v$session where username='SCOTT';
TERMINAL MACHINE
----------------------------------------------------------------
pts/34 tctm-x001.it1.com
pts/0 tctm-x001.it1.com
SQL>
2,Seesionid
I executed select sys_context('userenv','sessionid') from dual;
SYS_CONTEXT('USERENV','SESSIONID')
--------------------------------------------------------------------------------
4810
what is mean seesionid in sys_context?
which is not matched in sid in v$session? Is it differ from SID?
3,what is the difference between pid and spid in v$process?
spid relates to OS process , PID relates to oracle process id. But At situation we use PID ?
Thanks & Regards,
VN