ORACLE dba常用命令

1 查看指定用户

SQL> show user;
USER is "CICI"

2 查看表空间使用情况

select distinct (default_tablespace) ,temporary_tablespace from dba_users;

3 字典表系列

select * from v$option;

select * from v$version;