oracle数据库重要的查询语句

查看所有数据文件（dbf文件）的存放位置

SQL> select name from v$datafile;

标红色的为默认表空间文件

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/home/oracle/app/oracle/oradata/helowin/system01.dbf

/home/oracle/app/oracle/oradata/helowin/sysaux01.dbf

/home/oracle/app/oracle/oradata/helowin/undotbs01.dbf

/home/oracle/app/oracle/oradata/helowin/users01.dbf

/home/oracle/app/oracle/oradata/helowin/example01.dbf

/oracle-tablespace/brdb_1031_tablespace.dbf

6 rows selected.

SQL>

查看数据库的字符集

SQL> select userenv('language') from dual;

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

查看系统中所有的路径信息

SQL> select * from dba_directories;

oracle数据库重要的查询语句-LMLPHP

查询数据库用户信息

SQL> select * from dba_users;

end