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: 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
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: 1118
Registered: November 2010
Location: Bedwas, 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: 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
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 messageGo to next message
gazzag
Messages: 1118
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
Re: Is there a equivalent of delete nologging operations [message #667951 is a reply to message #665746] Thu, 25 January 2018 18:13 Go to previous message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear gazzag,

thanks for your solution.
Previous Topic: Driving Table is not given more speed result
Next Topic: View Performance Tuning
Goto Forum:
  


Current Time: Thu Mar 28 21:39:59 CDT 2024