全部博文
-
编辑 删除
oracle学习笔记----在线修改redo.log文件的大小
1.查看当前日志组成员： SQL> select member from v$logfile; MEMBER ------------------------------------------------------ C:ORACLEPRODUCT10.2.0ORADATAFYDBREDO01.LOG C:ORACLEPRODUCT10.2.0ORADATAFYDBREDO02.LOG C:ORACLEPRODUCT10.2.0ORADATAFYDBREDO03.LOG 2.查看当前日志组状态： SQL> select group#,members,bytes/1024/1024,status from v$log; GROUP# MEMBERS BYTES/1024/1024 STATUS ---------- ---------- ------
