Home » RDBMS Server » Performance Tuning » Is there a equivalent of delete nologging operations (11.2.0.4 SE, Windows 2012 r2 Datacenter)
Is there a equivalent of delete nologging operations [message #665732] Tue, 19 September 2017 03:13 Go to next message
juniordbanewbie
Messages: 169
Registered: April 2014
Senior Member
Dear all,

is there such a thing called delete nologging operations,

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_8005.htm#SQLRF01505

it looks like there no such thing called delete nologging operations.

thanks a lot in advance
Re: Is there a equivalent of delete nologging operations [message #665737 is a reply to message #665732] Tue, 19 September 2017 04:12 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
Truncate?
Re: Is there a equivalent of delete nologging operations [message #665741 is a reply to message #665737] Tue, 19 September 2017 06:44 Go to previous messageGo to next message
juniordbanewbie
Messages: 169
Registered: April 2014
Senior Member
Hi gazzag,

only thanks for the answer, just to confirm only insert statement can have nologging properties right?

thanks
Re: Is there a equivalent of delete nologging operations [message #665746 is a reply to message #665741] Tue, 19 September 2017 10:24 Go to previous message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
All DML will generate a degree of redo. I have typically used NOLOGGING in CREATE TABLE, CREATE INDEX operations. There's a good Metalink note here: 290161.1
Previous Topic: Why use Oracle In-Memory database from another perspective
Next Topic: How to partition unpartitioned existing table
Goto Forum:
  


Current Time: Thu Nov 23 21:37:55 CST 2017

Total time taken to generate the page: 0.01508 seconds