Oracle View data Files-control files-log files-tablespace information

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