Home » RDBMS Server » Performance Tuning » Set NOLOGGING for tables in UAT (windows 2012, oracle 12c)
Set NOLOGGING for tables in UAT [message #637550] Wed, 20 May 2015 01:32 Go to next message
muktha_22
Messages: 526
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
Re: Set NOLOGGING for tables in UAT [message #637551 is a reply to message #637550] Wed, 20 May 2015 01:36 Go to previous messageGo to next message
muktha_22
Messages: 526
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
Re: Set NOLOGGING for tables in UAT [message #637590 is a reply to message #637551] Wed, 20 May 2015 09:28 Go to previous messageGo to next message
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
Re: Set NOLOGGING for tables in UAT [message #637594 is a reply to message #637590] Wed, 20 May 2015 09:36 Go to previous messageGo to next message
Roachcoach
Messages: 1571
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.
Re: Set NOLOGGING for tables in UAT [message #637599 is a reply to message #637590] Wed, 20 May 2015 10:11 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
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.
Re: Set NOLOGGING for tables in UAT [message #637602 is a reply to message #637594] Wed, 20 May 2015 10:49 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, 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 Go to previous message
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.
Previous Topic: Find cpu MHz in Oracle view
Next Topic: Select statement taking Long time to execute
Goto Forum:
  


Current Time: Sat Oct 20 02:25:56 CDT 2018