How to find current SID of oracle from sqlplus

Posted on August 22, 2010 by admin

Well, if you following my posts, you already know that now a days I am playing with Oracle. Started “DBA in 25 days” series also. Today I am going to share quick tip. How to see SID of  Oracle DB.Issue following command from sqlplus.

select instance from v$thread

If you got question – what is SID then welcome to our boat. Refer my new series “DBA in 25days”. You can use this course as free OCA tutorial.

Other Posts related to current topic


MyFreeCopyright.com Registered & Protected
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License
Copy right related
Blog author MR.Rav

Enter your email address:

GET UPDATES TO YOUR E-MAIL

Post to Twitter

This entry was posted in oracle and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">