V$PWFILE_USERS

This view lists users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.

Column	Datatype	Description
USERNAME	VARCHAR2(30)	The name of the user that is contained in the password file
SYSDBA	VARCHAR2(5)	If TRUE, the user can connect with SYSDBA privileges
SYSOPER	VARCHAR2(5)	If TRUE, the user can connect with SYSOPER privileges