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

This is my personal learning route.

1. Sql, pl/sql (there are many videos on the Internet, you can do a simple start, then read a few books and do more experiments)

As the basic skills of oracle, we need to be very familiar with sql and plsql. Especially the multi-table joins, subqueries, various new versions of functions in sql, and all the syntax in plsql. It is suggested that you take enough time to study these two pieces. Do not think that this is the job of the developer, he is also an important job of DBA, and the DBA is more demanding, you can not only understand, but also be able to find problems. The main point of learning some knowledge in this area is to practice and think more.

2. Oracle management (architecture) (this part must listen to lectures, but also to listen to the "master" lectures, more discussion)

This is the difficulty of Oracle, Orcle technology is broad and profound, the main difficulty is concentrated in this. It includes Oracle storage management, object management, memory and process, undo management, initialization parameters, data dictionary view, security, latch and lock, permissions and roles, resource scheduling, flashback, logging principles and so on.

When learning this piece of knowledge, one of the key points is to know the principle and "root", and to know that what is superficial does not make any sense.

After knowing the principle, prove it through experiments and sum up the principle.

Whether the study in this area is good or not directly determines a backup recovery, optimization and troubleshooting in the future.

Although this part is research management, it pays more attention to the analysis and anatomy of principle and architecture.

It should be called "in-depth analysis of the Oracle architecture", no matter how deep it is.

In this part of the study, we have learned a lot of optimization content, in learning any knowledge point, we can not do without the analysis of performance.

3. Backup and restore (listen to lectures, read a few books, do more experiments, more discussions)

With the preparation of the second part, the study of this chapter is relatively interesting, as long as we study the logging principle of Oracle and the memory and process of oracle. Plan a perfect and correct backup plan and implementation plan (to analyze the principle), implement the backup; recover all kinds of damage (still be able to analyze the principle); in addition, you can do some difficult recovery experiments (or old saying, to be able to analyze the principle).

4. Optimization (single instance optimization) (still have to listen to lectures, it is best to listen to some thematic, in-depth expert classes, or to read some classic books, especially English books)

This piece is a complete combination of the first part and the second part. The study in this area is not the deepest, only deeper, and the learning method is similar to the second part.

First of all, we need to master some basic knowledge of Oracle optimization, such as in-depth analysis of index principles, partitioning, wait events, time statistics model, dynamic performance view, operating system performance optimization and view commands, such as: top, iostat, vmstat, sar, pmap, prstat, filemon, nmon, svmon and so on.

The most important thing is to do three things: the dynamic performance view of Oracle, the report of Oracle (trace, statspack, awr, addm, ash), and the execution plan; be familiar with and analyze these three pieces. The analysis and hands-on experiments in this part are very important.

5. RAC (you can listen to lectures. With the previous foundation, you can basically read books by yourself, so you can read books or listen to some special topics.)

Now that RAC is used more and more, the focus of learning RAC is: fundamentals + RAC optimization.

The optimization of RAC system is divided into two steps: RAC system optimization and single instance optimization; according to the basic principle of RAC, it can design high-performance RAC system and analyze RAC performance problems. Be able to understand and analyze the dynamic performance view, waiting events and reports of RAC.

6. GC, DG, Stream, Gold Gate, etc.

For these tools and components, we are familiar with their architecture, principles, some tools to monitor performance, and so on.

Learn a few points about these parts: familiarity with architecture, principles, building, monitoring (including failure and performance), troubleshooting and optimization.

7. SQL optimization (read a classic English book, do more experiments, more practice, more analysis)

Why take it out alone? Because this part requires persistent research and experiments, and the work is done almost every day.

At present, there are some classic Chinese books worth reading.

8.PL/SQL deep learning

In this part of the study, we should pay close attention to the performance, mainly focus on testing.

9. Comprehensive project actual combat

Simulated environment:

Planning, building, testing, troubleshooting, optimization, analysis

Actual combat environment:

Same as above

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.