<<Back to DB Administration Main Page
Find out your own Session Information in oracle
select sys_context ('USERENV','SID')FROM dual;
select sys_context('USERENV','SESSIONID') FROM dual;
select sys_context('USERENV','SESSION_USER') FROM dual;
select sys_context('USERENV','SESSIONID') FROM dual;
select sys_context('USERENV','SESSION_USER') FROM dual;
OR
select sid, serial#, username from v$session where sid = ( select sid from v$mystat where rownum = 1);
Example:
SQL> select sid, serial#, username from v$session where sid = ( select sid from v$mystat where rownum = 1);
SID SERIAL# USERNAME
-------- ---------- ---------------
10 62786 SYS
-------- ---------- ---------------
10 62786 SYS
1 row selected.
Ho To Find Your Own Sid Username And Serial In Oracle >>>>> Download Now
ReplyDelete>>>>> Download Full
Ho To Find Your Own Sid Username And Serial In Oracle >>>>> Download LINK
>>>>> Download Now
Ho To Find Your Own Sid Username And Serial In Oracle >>>>> Download Full
>>>>> Download LINK 48