ORA10G_DBA1_ch08

ORA10G_DBA1_ch08 - OCA Oracle 10G Administration-I Chapter...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
OCA Oracle 10G Administration-I Chapter 8 Managing Consistency and Concurrency
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Objectives Undo Management Monitor and administer undo. Configure undo retention. Guarantee undo retention. Use the Undo Advisor. Describe the relationship between undo and transactions. Size the undo tablespace. Monitor and Resolve Lock Conflicts Detect and resolve lock conflicts. Manage deadlocks. Describe the relationship between transactions and locks. Explain lock modes within the Oracle Database 10g.
Background image of page 2
3 Leveraging Undo Management Understanding Undo Segments Used for rollback, read-consistency and flash back query and data recovery. Stored in undo tablespace. Only one active undo tablespace at a time. Multiple undo segments created by system. Automatic expand and shrink extents. Minimum two extents per undo segment. Used by transactions at circular basis. One transaction resides in one undo segment.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/10/2010 for the course CS CS 2102 taught by Professor Knight during the Spring '09 term at UVA.

Page1 / 10

ORA10G_DBA1_ch08 - OCA Oracle 10G Administration-I Chapter...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online