oracle的nologging

最新推荐文章于 2021-09-01 11:03:58 发布

yfleng2002

最新推荐文章于 2021-09-01 11:03:58 发布

阅读量3.2k

点赞数

分类专栏： ORACLE 文章标签： oracle database logging table parallel generation

本文链接：https://blog.csdn.net/yfleng2002/article/details/7368980

版权

Oracle数据库允许控制redo记录的生成，Nologging特性能提升性能，但可能影响可恢复性。Nologging适用于如INSERT语句等可重复操作。在表空间级别设置Nologging是对象的默认属性，但可被对象级别设置覆盖。在备用数据库中，Nologging可能导致问题，可以使用NOFORCE模式。Direct-Path INSERT是高效的插入方式，不生成数据的undo信息，但在特定数据库模式下会生成redo记录。该操作受一些限制，并且在插入后无法立即查询或修改数据。

摘要由CSDN通过智能技术生成

官方如是说：

Controlling the Writing of Redo Records

For some database operations, you can control whether the database generates redo records. Without redo, no media recovery is possible. However, suppressing redo generation can improve performance, and may be appropriate for easily recoverable operations. An example of such an operation is a CREATE TABLE...AS SELECT statement, which can be repeated in case of database or instance failure.

Specify the NOLOGGING clause in the CREATE TABLESPACE statement to suppress redo when these operations are performed for objects within the tablespace. If you do not include this clause, or if you specify LOGGING instead, then the database generates redo when changes are made to objects in the tablespace. Redo is never generated for temporary segments or in temporary tablespaces, regardless of the logging attribute.

The logging attribute specified at the tablespace level is the default attribute for objects created within the tablespace. You can override this default logging attribute by specifying LOGGING or NOLOGGINGat the schema object level--for example, in a CREATE TABLE statement.

If you have a standby database, NOLOGGING mode causes problems with