ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle nologging

Oracle nologging

原创 Linux操作系统 作者:chncaesar 时间:2013-11-24 00:37:16 0 删除 编辑
The size of a redo log generated for an operation in NOLOGGING mode is significantly smaller than the log generated in LOGGING mode.

The NOLOGGING clause causes minimal redo information to be generated during the table creation. And direct-path inserts will not be logged.

However, DML statements (UPDATE, DELETE, and conventional path insert) are unaffected by the NOLOGGING attribute of the table and generate redo.

If the object for which you are specifying the logging attributes resides in a database or tablespace in force logging mode, then Oracle Database ignores any NOLOGGING setting until the database or tablespace is taken out of force logging mode.





来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/638844/viewspace-777429/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Linux sed Tips
请登录后发表评论 登录
全部评论

注册时间:2013-07-30

  • 博文量
    102
  • 访问量
    899678