Identify the Oracle System Identifier (SID) for the current Oracle Instance

Summary

** Internal Publish Only! This article may contain information that is not intended for external circulation. **

Instructions provided describe the SQL syntax used to find the SID for the user-connected Oracle instance.

Procedure

Log into SQL Plus as the sys user and run the following query:

SQL> select instance from v$thread;

This returns the Oracle SID for that instance.