摘要: SELECT t.NAME "TABLESPACE_NAME", SUM(u.ALLOCATED_SPACE) * 8 / 1000 "USED_SPACE(M)", SUM(u.FILE_MAXSIZE) * 8 / 1000 "MAX_SIZE(M)" FROM v$filespace_usage u, v$tablespace t WHERE ... 阅读全文
posted @ 2009-03-28 13:20 添乱 阅读(72) 评论(0) 推荐(0) 编辑
摘要: SELECT obj.OWNER || '.' || obj.OBJECT_NAME AS OBJ_NAME, -- 对象名称(已经被锁住) obj.SUBOBJECT_NAME AS SUBOBJ_NAME, --子对象名称(已经被锁住) obj.OBJECT_ID AS OBJ_ID, ... 阅读全文
posted @ 2009-03-27 16:38 添乱 阅读(347) 评论(0) 推荐(0) 编辑
摘要: SELECT t.NAME "TABLESPACE_NAME", SUM(u.ALLOCATED_SPACE) * 8 / 1000 "USED_SPACE(M)", SUM(u.FILE_MAXSIZE) * 8 / 1000 "MAX_SIZE(M)" FROM v$filespace_usage u, v$tablespace t WHERE u.TABLES... 阅读全文
posted @ 2009-03-27 16:15 添乱 阅读(367) 评论(0) 推荐(0) 编辑
摘要: 1、HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment 代表系统环境变量空间的注册表项 2、HKEY_CURRENT_USER\Environment 代表当前用户环境变量空间的注册表项 阅读全文
posted @ 2009-03-24 02:35 添乱 阅读(1788) 评论(0) 推荐(0) 编辑