SHOW CONNECTION

Shows the current database connection.

The SHOW CONNECTION command shows details about the current database connection.

Format

SHOW CONNECTION;

Command Examples

Example 1:

DGMGRL> show connection;

Oracle SID is sales1.

Connected as SYSDBA to instance sales1 of North_Sales.

Example 2: Connection to an instance that is not running:

    DGMGRL> show connection;

Connected as SYSDBA to an idle instance.