Shulou(Shulou.com)06/01 Report--

Initial stage: you can start with OCP textbooks, as well as Administrator's Guide, Concepts, Performance Tuning Guide, Backup and Recovery Advanced User's Guide, Backup and Recovery Basics in the documentation. In particular, Administrator's Guide, Concepts and Performance Tuning Guide should be read in detail. More operations, more experiments.

Intermediate stage: continuous operation, plus metalink to see all kinds of articles, their own summary. There is a very important one, go to the Oracle website, find the OCM exam outline, click on the map, and break it one by one. Whether or not to take the OCM is another matter. For books, you can refer to "the Art of 9i&10g programming", "cost-based oracle Optimization rules", "lie Cluster rac", "ORACLE RAC Diary" and so on.

Advanced: continue to read (optimization, features, integration) to the depth and breadth of learning. You can delve into the following topics one by one:

1. Storage format: data file format, data storage format, etc.

2. Shared pool: parsing processes and principles, sharing related Latch, Lock, Pin,Row cache lock principles, related waiting events. And shared pool memory allocation mechanism.

3. Buffer Cache part: logical reading, physical reading process and principle, related Latch, Pin, and related waiting events.

4. The generation process of Redo:Redo, related Latch, waiting events.

5. Undo:Undo space usage rules, principles of commit and rollback

6. Principle of backup and recovery mechanism, learn to use BBED

7 、 ASM

8 、 RAC

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.