摘要：本文转自http://space.itpub.net/?uid-22489585-action-viewspace-itemid-729944alterindex&index_name monitoring usage;alter index &index_name nomonitoring usage;select * from v$object_usage where index_name = &index_name;--求数据文件的I/O分布select df.name,phyrds,phywrts,phyblkrd,phyblkwrt,singleblkrds, 阅读全文

摘要：select df.tablespace_name "表空间名",totalspace "总空间M",freespace "剩余空间M",round((1-freespace/totalspace)*100,2) "使用率%",(totalspace-freespace)/1024 "已用空间G"from (select tablespace_name,round(sum(bytes)/1024/1024) totalspace from dba_data_files group by tabl 阅读全文

摘要：本文转自http://space.itpub.net/?uid-7836777-action-viewspace-itemid-722830在SQLPLUS下，实现中-英字符集转换0fz[,r;v3g0alter session set nls_language='AMERICAN';4\#J B4gxz b0alter session set nls_language='SIMPLIFIED CHINESE';ITPUB个人空间rQ4p4iO:k)k+~主要知识点：0d|/`%IjB*w2f0一、有关表的操作ITPUB个人空间H1Cmw& 阅读全文