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

Last Published: April 25, 2020


** 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.


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.

    Article ID:000009921

    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic