以下的文章主要讲述的是Oracle 数据库中如何正确的查看sql,以及查询表的相关状态,如果你对其相关的实际操作有兴趣的话,请看下文。
select uo.OBJECT_NAME,uo.OBJECT_ID,lo.Oracle_USERNAME,lo.LOCKED_MODE from user_objects uo,v$locked_object lo where uo.OBJECT_ID=lo.OBJECT_ID; |
查看数据库字符集
select * from nls_database_parameters; |
查看表创建,修改时间
select * from ALL_OBJECTS where object_name =upper('tname'); |
每个表所占空间
select Segment_Name, round(Sum(bytes)/1024/1024,0) "MBytes" From User_Extents Group By Segment_Name order by "MBytes" desc; |
查询正在执行的存储过程
select * from dba_ddl_locks where owner='USERNAME'; |
查看表空间的使用情况
select a.tablespace_name,round(a.bytes/(1024*1024),2) "Total MB", round(b.bytes/(1024*1024),2) "Used MB", round(c.bytes/(1024*1024),2) "Free MB", round((b.bytes*100)/a.bytes,2)||'%' "% Used", round((c.bytes*100)/a.bytes,2)||'%' "% Free" from sys.sm$ts_avail a,sys.sm$ts_used b,sys.sm$ts_free c where a.tablespace_name=b.tablespace_name and a.tablespace_name=c.tablespace_name; |