Overview/Description
Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented automatically, which can sometimes cause lock conflicts. Lock conflicts can be detected and managed through Enterprise Manager or SQL statements. Managing undo data and implementing Oracle Database security are also important DBA roles. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction that changes data. Security requirements have been a matter of individual concern until recently, but now there are a variety of laws enforcing the privacy and accuracy of data. This course discusses the locking mechanism in Oracle and how to resolve lock conflicts and deadlocks. It also discusses how to manage undo data, and how to implement database auditing and maintain the audit trail. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.