1. View all users in the current database: Select username from dba_users;
2. View the user logged in for the current session: Show users or select username from user_users;
3. View all tables for a user: SELECT * from Dba_tables where owner= ' username ';--username to capitalize or select table_name from dba_tables where owner= ' Netfolder ‘;
4, check the location of control files, and other information: SELECT * from V$controlfile;
5. View users and their default tablespace information: Select Username,default_tablespace from dba_users;--view users and their default tablespace select * from Dba_users;
6. View data file information: SELECT * from V$datafile; SELECT * from Dba_data_files;
7. View Redo log File information: SELECT * from V$logfile;
8, check the current system used parameter file information: Show parameter spfile; File name: pfileoracle instance name. Ora
9. Location of password files
Storage location under Linux: $ORACLE _home/dbs/orapw$oracle_sid
namely:oracle_home/dbs/orapw<sid>
Where to store under Windows: $ORACLE _home/database/pwd%oracle_sid%.ora
Oracle View data Files-control files-log files-tablespace information