|
Explanation: To avoid redo information generating you can use NOLOGGING mode in SQL statements, use direct path loading without archiving and direct path loading with archiving using NOLOGGING mode. Incorrect Answers:
2: There is no direct load UPDATE to NOLOGGING mode in Oracle. 5: There is no NOLOGGING initialization parameter in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 873-876. Chapter 18: Tuning Memory and Operating System Use
|