If I have system access to oracle DB, and want to find out the service name

> sqlplus system password: XXXX SQL> select sys_context('userenv','instance_name') from dual;

output

SYS_CONTEXT('USERENV','INSTANCE_NAME') -------------------------------------------------- MY_INSTANCE_NAME

Now, to find out SID

SQL> select sys_context('userenv','sid') from dual;