2008年7月2日
Desc most of all data dictionary
摘要： 详细字典内容如下： ALL_CATALOG All tables, views, synonyms, sequences accessible to the user ALL_COL_COMMENTS Comments on columns of accessible tables and views ALL_COL_GRANTS_MADE Grants on columns for w... 阅读全文
posted @ 2008-07-02 22:14 Alex.Zhang 阅读(208) 评论(0) 推荐(0)
(Alex note) Using Data Dictionary and Dynamic Performace View
摘要： Data dictionary (read-only / in system tablespace / owned by sys / maintained by Oracle / Accessed with select ) #当执行DDL语句的时候Oracle 自动会对数据字典进行维护. #DD view is the static view , not means absolutely sta... 阅读全文
posted @ 2008-07-02 17:12 Alex.Zhang 阅读(280) 评论(0) 推荐(0)
undo segment
摘要： 在 undo segment中，Insert是记录rowid，update 记录被更改数据的前镜像，delete 记录整行数据。因此delete产生的undo最多。 select segment_name,tablespace_name,status from dba_rollback_segs; select xidusn,xidslot,xidsqn,ubablk,ubafil from v... 阅读全文
posted @ 2008-07-02 15:17 Alex.Zhang 阅读(809) 评论(0) 推荐(0)
(Training) EDW Architech
只有注册用户登录后才能阅读该文。 阅读全文
posted @ 2008-07-02 13:32 Alex.Zhang 阅读(14) 评论(0) 推荐(0)