Oracle 常用脚本
yaserchen
这个作者很懒,什么都没留下…
展开
-
GetHidPar.sql获取隐含参数
set linesize 120col name for a30col value for a20col describ for a60select x.ksppinm name, y.ksppstvl value, x.ksppdesc describfrom sys.x$ksppi x,sys.x$ksppcv ywhere x.indx = y.indxand转载 2013-10-08 10:40:11 · 957 阅读 · 0 评论 -
查看表空间使用情况
SELECTD.TABLESPACE_NAME, SPACE || 'M'"SUM_SPACE(M)", BLOCKS "SUM_BLOCKS", SPACE - NVL (FREE_SPACE, 0) || 'M'"USED_SPACE(M)", ROUND ( (1 - NVL (FREE_SPACE, 0) /S转载 2013-10-09 15:08:02 · 674 阅读 · 0 评论