-
编辑 删除
v$datafile_header各属性解释
http://youngcow.net/doc/oracle10g/server.102/b14237/dynviews_1078.htm#i1403314[@more@]This view displays datafile information from the datafile headers.ColumnDatatypeDescriptionFILE#NUMBERDatafile number (from control file)STATUSVARCHAR2(7)ONLINE | OFFLINE (from control file)ERRORVARCHAR2(18)NULL if the datafile header read and validation were successful. If the read failed then the rest of the columns are NULL. If the validation failed then the rest of columns may display invalid data. If there
-
编辑 删除
v$datafile各属性解释
http://youngcow.net/doc/oracle10g/server.102/b14237/dynviews_1076.htm[@more@]1、created_change# --scn_to_timestamp 转换成建立时间；2、status:system,online,offline;3enabled :read only ,read write,disable;4、checkpoint_change#,checkpoint_time--当alter database datafile '' resize 5m的时候触发改变；... 执行alter system switch logfile或者alter system flush buffer_cache或者alter system archive log current以后各个数据文件记录的检查点统一和日志文件对齐525357 2009-9-17 11:07:18525357 2009-9-17 11:07:1852
-
博文量153
-
访问量176622
搜博主文章
他的分类
- 逻辑备份 imp/exp impdp/expdp(5)
- audit(4)
- tablespace -- undo(2)
- lsnrctl server(1)
- role(3)
- package (2)
- sql*plus,pl/sql,isqlplus(6)
- 我的oracle问题(1)
- parameters(9)
- asm(3)
- sql语句优化和调整(1)
- 伪列(2)
- alert threshold metric_value(3)
- 分析函数(2)
- 美丽的大连我的家(2)
- privilege(1)
- job(2)
- rman(1)
- os 登录验证(1)
- oracle 概念(3)
- instance_process(1)
- dml(1)
- tablespace -- sysaux(2)
- 一般分类(1)
- startup and shutdown(2)
- recover database(12)
- parameters-plsql(1)
- 体系结构--模式对象schema(1)
- function by myself(2)
- oss and dedicate server (1)
- sqlserver(4)
- os(1)
- block(1)
- rac(1)
- linux(5)
- em (3)
- profile(1)
- process(3)
- tablespace(7)
- dump(1)
- oca,ocp,ocm 其他朋友考试问题(1)
- regedit(1)
- pfile spfile and memory(1)
- 正则表达式(2)
- 体系结构--文件系统(4)
- datafile(2)
- flashback(2)
- oracle install(1)
- sga内存的cpu的调整和优化(4)
- segment(6)
- index(1)
- trigger(1)
- 引用我的qq好朋友的文章(8)
- 我积累的零散的小知识点(2)
- tree(1)
- 默认分类(9)
