Baanboard.com

Go Back   Baanboard.com > Common DBA Misconceptions

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
14%
200 - 500 GB
32%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 28

Baanboard at LinkedIn


Reference Content

Book Navigation

 
Redo & Rollback: No logging turns off redo logging
By patvdv at 23 Feb 2008 - 23:25

Many people believe that by setting a segment to NOLOGGING mode, no redo will be generated for DML performed against that segment. In fact, only a limited number of operations can be performed NOLOGGING. According to the Oracle 8i Concepts Guide, only the following operations may take advantage of the NOLOGGING feature:

 

  • direct load (SQL*Loader)
  • direct-load INSERT
  • CREATE TABLE ... AS SELECT
  • CREATE INDEX
  • ALTER TABLE ... MOVE PARTITION
  • ALTER TABLE ... SPLIT PARTITION
  • ALTER INDEX ... SPLIT PARTITION
  • ALTER INDEX ... REBUILD
  • ALTER INDEX ... REBUILD PARTITION
  • INSERT, UPDATE, and DELETE on LOBs in NOCACHE NOLOGGING mode stored out of line
0
No votes yet


All times are GMT +2. The time now is 22:57.


©2001-2018 - Baanboard.com - Baanforums.com