Oracle常用命令

查看所有用户

select * from all_users; 
select * from dba_users;
select * from user_users;

 

查看SID

select * from v$instance;

查看所有表空间

select * from v$tablespace;

查询表空间文件所在路径

select * from dba_data_files;

查看用户所拥有的角色

select * from dba_role_privs;   
select * from user_role_privs; 

用户修改密码，Oracle给用户解锁

 ALTER USER "SCOTT" IDENTIFIED BY "*******"   
 ALTER USER "SCOTT" ACCOUNT UNLOCK  

显示当前连接用户

show user;