Oracle Undo rollback Segment in-depth resolution-beyond OCP proficient in Oracle Video course Training 15

Oracle Video Tutorial Goals      

Oracle Video tutorial, wind Brother this set of Oracle Tutorial Training learning the role of Oracle database undo and related data dictionary, undo Automatic Management, DDL and DML operations and undo relationship, undo table space Full of what to do? Analog Ora-01555,undo table space damage how to deal with it? Undo Segment Header/Rollback block/Transaction slot resolution, Undo rollback segment Header deep analysis, before and after transaction commit Oracle internal operations? In-depth analysis of pre-image and consistent reads.

Applicable people

It-related practitioners, Oracle database technicians, those who want to pay, want to get promoted.

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/8B/3F/wKioL1hIFaSwbwdLAACO4droMV4094.gif-wh_500x0-wm_3 -wmp_4-s_1249195125.gif "title=" Oracle "alt=" Wkiol1hifaswbwdlaaco4dromv4094.gif-wh_50 "/>

Video Online learning Address:

Http://edu.51cto.com/course/course_id-6612.html

About Oracle Video Tutorials

Oracle Video tutorial, wind Brother this set of Oracle Tutorial Training learning the role of Oracle database undo and Undo Related Data dictionary, Undo automatically manages and Undo_retention, simulates and really understands the relationship between DDL and DML operations and undo, What if the Undo table space is full? Analog Ora-01555,undo table space damage how to deal with it? Undo Segment Header/Rollback block/Transaction slot resolution, Undo rollback segment Header in-depth analysis, what exactly did Oracle do before and after the transaction was committed? How to find the pre-image, drill down on the consistent read of undo, understand the status modification of the rollback section and the daily management and maintenance of the rollback mask introduction.

Oracle database Undo Rollback Segment Technology in-depth analysis, the course content is as follows:

1. The role of undo

2. Undo Related Data Dictionary

3, Undo automatic management and Undo_retention

4. Simulate and really understand the relationship between DDL operations and undo

5. Simulate and really understand the relationship between DML operations and undo

6, Undo table space Full of what to do?

7, simulated ora-01555 snapshot over the old problem and treatment methods

8, Undo table space Damage how to deal with?

9. Undo Daily maintenance and management in depth

10. Undo Segment Head/Rollback block/Transaction slot resolution

11. Deep analysis of undo rollback segment Head

12. What did Oracle do before and after the transaction was committed?

13, how to find and delete from undo to modify the previous image of the operation

14. How to find a previous image with multiple records updated in a transaction from undo

15, in-depth analysis of the consistency of undo read

16, understand the rollback section status modification and rollback shielding introduction

This article is from the Oracle Database tutorials Blog, so be sure to keep this source http://oracle13c.blog.51cto.com/8020378/1880515

Oracle Undo rollback Segment in-depth resolution-beyond OCP proficient in Oracle Video course Training 15