My Oracle Support Banner

Effect Of Nologging Hint On Direct-Path-Insert Statement (Doc ID 285285.1)

Last updated on AUGUST 08, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.4 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

@ ***Checked for relevance on 21-Sep-2016***

Want to make use of the nologging option in direct-path-insert.

1)
a. create a table with attribute NOLOGGING
b. insert /*+ append */ .....
this results in a modified unrecoverable_time in v$datafile - as expected

2)
a. alter table test logging
b. insert /*+ append nologging */ ... or ... insert /*+ append */ nologging
Would have expected that unrecoverable_time had changed after issuing this command, but it didn't.
Is No.2 really no NOLOGGING-Operation or is just unrecoverable_time not adjusted as it should.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.