OraFAQ Forum: Performance Tuning » Set NOLOGGING for tables in UAT

Home » RDBMS Server » Performance Tuning » Set NOLOGGING for tables in UAT (windows 2012, oracle 12c)

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

Set NOLOGGING for tables in UAT [message #637550]

Wed, 20 May 2015 01:32

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Have a small question to clarify with you.

Making all the tables in UAT server to NOLOGGING mode will increase the performance? as the UAT server is not generating the ARCHIVE LOGS?

Regards
Muktha

Report message to a moderator

Re: Set NOLOGGING for tables in UAT [message #637551 is a reply to message #637550]

Wed, 20 May 2015 01:36

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Found the answer just now,

The NOLOGGING feature never affects redo generation for regular INSERT, UPDATE, MERGE, and DELETE statements.

Thanks
Muktha

Report message to a moderator

Re: Set NOLOGGING for tables in UAT [message #637590 is a reply to message #637551]

Wed, 20 May 2015 09:28

bpeasland
Messages: 51
Registered: February 2015
Location: United States

Member

Muktha gave you a pretty good answer. But let's just assume that it is possible and that you can do this. My question would be *why*? Sure, you make performance of your test environment better. But at the same time, you would be masking performance issues that you would see as soon as the change goes to production. That would be a very bad thing to do, IMO. I for one would hate to be the DBA that had to polish his resume because the test environment the company paid for was intentionally modified so that performance issues were harder to spot until production.

Cheers,
Brian

Report message to a moderator

Re: Set NOLOGGING for tables in UAT [message #637594 is a reply to message #637590]

Wed, 20 May 2015 09:36

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Or the guy who lost a test environment because it couldn't be restored and teams of devs are sitting idling for a few days whilst it is rebuilt. That would suck.

Report message to a moderator

Re: Set NOLOGGING for tables in UAT [message #637599 is a reply to message #637590]

Wed, 20 May 2015 10:11

Lalit Kumar B
Messages: 3171
Registered: May 2013
Location: World Wide on the Web

Senior Member

bpeasland wrote on Wed, 20 May 2015 19:58

Muktha gave you a pretty good answer.

Muktha is the OP.

Report message to a moderator

Re: Set NOLOGGING for tables in UAT [message #637602 is a reply to message #637594]

Wed, 20 May 2015 10:49

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

Senior Member

This is a very good point; I consider any dev/test system to be a production one as far as the developers are concerned.

[Edit: typo]

[Updated on: Wed, 20 May 2015 10:55]

Report message to a moderator

Re: Set NOLOGGING for tables in UAT [message #637682 is a reply to message #637594]

Thu, 21 May 2015 09:24

bpeasland
Messages: 51
Registered: February 2015
Location: United States

Member

Roachcoach wrote on Wed, 20 May 2015 09:36

Or the guy who lost a test environment because it couldn't be restored and teams of devs are sitting idling for a few days whilst it is rebuilt. That would suck.

I always say that it may not be production for our end users, but its production for someone. If I lost a test database, I have 40 people out of work until I get it restored.

Report message to a moderator

Previous Topic:	Find cpu MHz in Oracle view
Next Topic:	Select statement taking Long time to execute

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 26 10:15:43 CST 2021