命令二

TBS_RMYYEM_001 1.查看表空间 select *from dba_data_files 2 查看当前用户的角色 select * from user_role_privs;

3 . 查看当前用户的系统权限和表级权限

　　SQL>select * from user_sys_privs;

　　SQL>select * from user_tab_privs;

4. 查看用户下所有的表 select * from user_tables; 5 查看当前用户的缺省表空间 select username,default_tablespace from user_users;

6 显示当前会话所具有的权限 select * from session_privs; 7 显示指定用户所具有的系统权限 select * from dba_sys_privs where grantee='GAME'; 8 查看所有表空间大小 select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name; 9. 未使用的表空间大小

select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name; 10,查看当前用户每个表占用空间的大小 Select Segment_Name,Sum(bytes)/1024/1024 From User_Extents Group By Segment_Name
11 查看表创建时间

     SELECT CREATED FROM USER_OBJECTS WHERE OBJECT_NAME='ELECTRICITY_CLASS_T';

12 系统当前时间 select sysdate from dual

转载于:https://my.oschina.net/u/2400219/blog/1614757