How to find your Oracle SID

To find what your Oracle System ID is :

SQL> show parameter db_name;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_name                  string     host91906
SQL>


on Oracle XE db usually by default SID is XE , as below

SQL> show parameter db_name;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_name                  string     XE
SQL>