NOLOGGING 應用場景
NOLOGGING Wrap-up
The operations that may be performed in a NOLOGGING mode are as follows:
特別注意,在非歸檔下,Create表和索引都不會產生大量日誌。
You would not see the differences
in redo size in a NOARCHIVELOG mode database as the index CREATE and REBUILD operations are not logged in
NOARCHIVELOG mode.
If you test this on a NOARCHIVELOG-mode database, The CREATE TABLE will not be logged, with the exception of the data dictionary modifications, in a NOARCHIVELOG-mode database.
[@more@]• Index creations and ALTERs (rebuilds).
• Bulk INSERTs into a table using a direct-path INSERT such as that available via the
/*+ APPEND */ hint or SQL*Loader direct-path loads. The table data will not generate redo, but all index modifications will (the indexes on this nonlogged table will generate redo!).
• LOB operations (updates to large objects do not have to be logged).
• Table creations via CREATE TABLE AS SELECT.
• Various ALTER TABLE operations such as MOVE and SPLIT.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14377/viewspace-1059435/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ES 應用場景
- Zookeeper應用場景
- 3.4 應用場景
- DDD應用場景
- 【實操】小程式的應用場景分析——線下場景應用
- Nginx應用場景配置Nginx
- FRAM的應用場景
- Numpy的應用場景
- redis的應用場景Redis
- Vuex 的應用場景Vue
- snapshot應用場景
- SAP BTP MTA 應用的應用場景
- 7.3 應用場景簡介
- Redis 應用場景彙總Redis
- 從應用場景看棧
- Redis常見應用場景Redis
- 閉包及其應用場景
- 【分散式】Zookeeper應用場景分散式
- zookeeper使用(四)--應用場景
- PON網路應用場景
- 人工智慧應用場景人工智慧
- 理解 Fragment 的應用場景Fragment
- 13 個 GCD 應用場景GC
- 單例模式應用場景:單例模式
- Redis實際應用場景Redis
- 業務建模:CQRS應用場景
- openGauss MOT應用場景
- openGauss-應用場景
- ZooKeeper核心原理及應用場景
- 什麼場景應該用MongoDB ?MongoDB
- RabbitMQ核心元件及應用場景MQ元件
- redis應用場景及例項Redis
- 堆排序原理及其應用場景排序
- MPLS VPN典型應用場景——VecloudCloud
- BFC的概念與應用場景
- 區塊鏈應用場景解析區塊鏈
- ThottleStop 軟體的應用場景
- 商品API的應用場景分析API