2012年5月31日
Oracle 相关的专业术语 说明
摘要： 2PC: (See two-phase commit) ACID: The properties of a reliable transactional system: Atomic,Consistent, Isolated and Durable. archived redo logfile: (See log file(archived)) array: A list of related items of uniform size. If you know the size of anitem, you can calculate the location of the nth item 阅读全文
posted @ 2012-05-31 20:58 davedba 阅读(188) 评论(0) 推荐(0)
Oracle 相关的专业术语 说明
摘要： 2PC: (See two-phase commit) ACID: The properties of a reliable transactional system: Atomic,Consistent, Isolated and Durable. archived redo logfile: (See log file(archived)) array: A list of related items of uniform size. If you know the size of anitem, you can calculate the location of the nth item 阅读全文
posted @ 2012-05-31 20:58 davedba 阅读(182) 评论(0) 推荐(0)
Oracle 11g UNDO 管理 详解
摘要： 从Oracle 11g 开始，使用默认安装时，Oracle 会自动管理UNDO，之前也整理过几篇有关UNDO的文章，如下：Oracle undo 管理http://blog.csdn.net/tianlesoftware/article/details/Oracle undo 表空间管理http://blog.csdn.net/tianlesoftware/article/details/5689558Currentonline Redo 和 Undo 损坏的处理方法http://blog.csdn.net/tianlesoftware/article/details/6261475整理的都. 阅读全文
posted @ 2012-05-31 17:18 davedba 阅读(354) 评论(0) 推荐(0)
Oracle 11g UNDO 管理 详解
摘要： 从Oracle 11g 开始，使用默认安装时，Oracle 会自动管理UNDO，之前也整理过几篇有关UNDO的文章，如下：Oracle undo 管理http://blog.csdn.net/tianlesoftware/article/details/Oracle undo 表空间管理http://blog.csdn.net/tianlesoftware/article/details/5689558Currentonline Redo 和 Undo 损坏的处理方法http://blog.csdn.net/tianlesoftware/article/details/6261475整理的都. 阅读全文
posted @ 2012-05-31 17:18 davedba 阅读(261) 评论(0) 推荐(0)
Oracle 查看表空间使用率 SQL 脚本
摘要： SQL 语句：/* Formatted on 2012/5/31 14:51:13 (QP5 v5.185.11230.41888) */SELECT D.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) / SPACE) * 100, 2) || &# 阅读全文
posted @ 2012-05-31 14:51 davedba 阅读(170) 评论(0) 推荐(0)
Oracle 查看表空间使用率 SQL 脚本
摘要： SQL 语句：/* Formatted on 2012/5/31 14:51:13 (QP5 v5.185.11230.41888) */SELECT D.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) / SPACE) * 100, 2) || &# 阅读全文
posted @ 2012-05-31 14:51 davedba 阅读(105) 评论(0) 推荐(0)