OraFAQ Forum: Performance Tuning » Is there a equivalent of delete nologging operations

Home » RDBMS Server » Performance Tuning » Is there a equivalent of delete nologging operations (11.2.0.4 SE, Windows 2012 r2 Datacenter)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is there a equivalent of delete nologging operations [message #665732]

Tue, 19 September 2017 03:13

juniordbanewbie
Messages: 250
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

Report message to a moderator

Re: Is there a equivalent of delete nologging operations [message #665737 is a reply to message #665732]

Tue, 19 September 2017 04:12

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

Truncate?

Report message to a moderator

Re: Is there a equivalent of delete nologging operations [message #665741 is a reply to message #665737]

Tue, 19 September 2017 06:44

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Hi gazzag,

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

thanks

Report message to a moderator

Re: Is there a equivalent of delete nologging operations [message #665746 is a reply to message #665741]

Tue, 19 September 2017 10:24

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, 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

Report message to a moderator

Re: Is there a equivalent of delete nologging operations [message #667951 is a reply to message #665746]

Thu, 25 January 2018 18:13

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear gazzag,

thanks for your solution.

Report message to a moderator

Previous Topic:	Driving Table is not given more speed result
Next Topic:	View Performance Tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 01 01:00:21 CDT 2023