Oracle DBA Question:
Download Questions PDF

What does the NO LOGGING option do? Why would we use it? Why would we be careful of using it?

Answer:

It disables the logging of changes to the redologs. It does not disable ALL LOGGING, however as Oracle continues to use a base of changes, for recovery if you pull the plug on the box, for instance. However it will cause problems if you are using standby database. Use it to speed up operations, like an index rebuild, or partition maintenance operations.

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?Tell me about standby database? What are some of the configurations of it? What should we watch out for?