ORACLE-cek SID & User

 [root@centralyotodo ~]# su - oracle 

$ bash
[oracle@centralyotodo ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 22 10:58:02 2021

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect /as sysdba;
Connected.
SQL> select name from v$database;

NAME
---------
DATAMART

SQL>

List all users that are visible to the current user:

SELECT * FROM all_users;

List all users in the Oracle Database:

SELECT * FROM dba_users;

Show the information of the current user:

SELECT * FROM user_users;