<div>
SID: &nbsp; &nbsp;select sys_context('USERENV','SID<wbr />') from dual;
</div>


SID:    select sys_context('USERENV','SID') from dual;

<div>
You may also have a v$mystat and v$sesstat view, depending on which catalog views / synonyms exist in your db.<br />
<br />
<a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2098.htm" rel="ugc">http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2098.htm</a>
</div>


You may also have a v$mystat and v$sesstat view, depending on which catalog views / synonyms exist in your db.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2098.htm [http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2098.htm]

<div>
<div class="content wysiwyg-content">
is there a simple way for me to know what <br />
sid / serial # i am when i connect to oracle.<br />
<br />
Currently The same user id will connect a few times and will connect using the same program<br />
<br />
I am really trying to find out if I can get the information from sys.v_$session, but i want it for the session I am currently connected to. <br />
<br />
I was going to record this information in a log, so that if I have an issue with a process that was developed, I would be able to quickly look for the SID and Serial# to use the ALTER SYSTEM KILL SESSION '$SID,&amp;SERIAL' command.<br />
<br />
Any help would be apprecieated ...<br />
<br />

</div>
</div>


is there a simple way for me to know what 
sid / serial # i am when i connect to oracle.

Currently The same user id will connect a few times and will connect using the same program

I am really trying to find out if I can get the information from sys.v_$session, but i want it for the session I am currently connected to. 

I was going to record this information in a log, so that if I have an issue with a process that was developed, I would be able to quickly look for the SID and Serial# to use the ALTER SYSTEM KILL SESSION '$SID,&SERIAL' command.

Any help would be apprecieated ...



find out what SID and SERIAL#  i am 10g when i connect

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.