摘要:
详细字典内容如下: 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... 阅读全文
摘要:
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... 阅读全文
摘要:
在 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... 阅读全文
只有注册用户登录后才能阅读该文。 阅读全文