oracle数据库查询表空间使用情况1、查看所有表空间使用情况（包含temp表空间）set linesize 300set pagesize 300select t.tablespace_name,x.contents tablespace_type,t."SUM_SPACE(M)",t.SUM_BLOCKS,t."USED_SPACE(M)",t."USED_RATE(%)",t."FREE_S

oracle数据库查询表空间使用情况1、查看所有表空间使用情况（包含temp表空间）set linesize 300set pagesize 300select t.tablespace_name,x.contents tablespace_type,t."SUM_SPACE(M)",t.SUM_BLOCKS,t."USED_SPACE(M)",t."USED_RATE(%)",t."FREE_S

一、查看所有用户select * from dba_users;select * from all_users;select * from user_users;二、查看角色1.当前用户被激活的全部角色select * from session_roles;2.当前用户被授予的角色select * from user_role_privs;3.全部用户被授予的角色select * from dba

以卸载/tmp为例1、系统提示如下错误umount: /tmp: target is busy(In some cases useful info about processes thatuse the device is found by lsof(8) or fuser(1).)则执行下面命令，在umountlsof /tmp|tail -n +2 | awk '{print $2}' |so