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;