Oracle常用命令

查看所有用户

[delphi]  view plain  copy

1. select * from all_users;   
2. select * from dba_users;  
3. select * from user_users;  

 

查看SID

[sql]  view plain  copy

1. select * from v$instance;  

查看所有表空间

[sql]  view plain  copy

1. select * from v$tablespace;  

查询表空间文件所在路径

[sql]  view plain  copy

1. select * from dba_data_files;  

查看用户所拥有的角色

[sql]  view plain  copy

1. select * from dba_role_privs;     
2. select * from user_role_privs;   

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

[sql]  view plain  copy

1. ALTER USER "SCOTT" IDENTIFIED BY "*******"     
2. ALTER USER "SCOTT" ACCOUNT UNLOCK    

显示当前连接用户

[sql]  view plain  copy

1. show user;