Oracle Study Notes (4) ------------ learning route summary, oracle Study Notes

Oracle Study Notes (4) ------------ learning route summary, oracle Study Notes

It was a little difficult to learn Oracle, so I found some learning routes on the Internet to learn regularly, which is more efficient and shared with you.

Concepts
|
New Features
_________________ | _______________
|
Developer DBA
Application Backup & Recovery
Dev Guide (Fundamentals) Concepts
|
PL/SQL User Guide Recovery Reference
& References |
|
Performance Administrators 'Guide
Planning |
| _________________________________ |
|
Performance
& Tunning Guide

1. SQL, pl/SQL (there are a lot of videos on the Internet. You can start with a simple one, read a few books, and do more experiments)
As a basic oracle skill, you need to be familiar with SQL and plsql. In particular, multi-table join, subquery, various new functions in SQL, and all the syntaxes in plsql. We recommend that you take enough time to study the two parts. Do not think that this is a developer's job. It is also an important job of DBA, and it has higher requirements for DBA. You can not only understand it, but also identify problems. The main points of learning this knowledge are: Practice more and think more.

 

In my opinion, MySQL is the foundation for getting started, easy to learn, and faster to learn SQL statements. Although some MySQL syntaxes differ from those of Oracle, they are similar, I am optimistic about MySQL.

 

2. Oracle Management (Architecture)
This is the difficulty of Oracle. Orcle technology is profound and profound, and the main difficulties are concentrated here. Including 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, and log principles.
When learning this piece of knowledge, one key point is to know the principle and "root", knowing what is superficial does not make any sense.
After understanding the principle, we will prove it through experiments and summarize it.
This learning process is good or not, and it directly determines a future Backup recovery, optimization, and troubleshooting.
Although this part is research and management, it pays more attention to the analysis and anatomy of the Principles and architecture.
It should be called "in-depth analysis of the Oracle architecture.
In this part of learning, we have learned a lot of Optimization content. When learning any knowledge point, we cannot do without analyzing performance.

 

 

3. Backup Recovery (listen to lectures, read a few books, do more experiments, and discuss more)
With the help of the second part, the study in this chapter is relatively interesting, on the premise that we have studied Oracle's log principles and oracle's memory and process. Plan a perfect and correct backup plan and implementation plan (specific principles should be analyzed), implement backup, recover various damages (or be able to analyze the Principles ); in addition, you can do some difficult recovery experiments (or you should be able to analyze the principles ).

 

4. Optimization (Single Instance optimization)
This is a combination of the first part and the second part. This part of learning is not deepest, only deeper, the learning method is similar to the second part.
First, you need to have some basic knowledge about Oracle optimization, for example, in-depth analysis of index principles, partitions, wait events, time Statistics Models, dynamic performance views, and some performance optimization and viewing commands of the operating system, such: top, iostat, vmstat, sar, pmap, prstat, filemon, nmon, svmon, etc.
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 parts. This part of analysis and hands-on experiments are very important.

5. RAC)
As RAC is increasingly used, the focus of learning RAC is: Basic Principles + RAC optimization.
RAC system optimization involves two steps: RAC system optimization and single-instance optimization. Based on the basic principle of RAC, a high-performance RAC system can be designed to analyze RAC performance problems. Understand and analyze the dynamic performance view, wait events, and reports of RAC.

6. GC, DG, Stream, and Gold Gate
We are familiar with these tools and components, including their architecture, principles, and performance monitoring tools.
Learn the architecture, principles, setup, monitoring (including faults and performance), and troubleshooting and optimization.

7. SQL optimization (read a classic English book, experiment, practice, and analysis)
Why do they come out separately? This part requires constant research and experimentation, and almost every day at work.
At present, there are some classic Chinese documents, which are worth reading.

 

Learning Materials

1. OCP/OCM textbooks

2. Oracle official documents:

Concepts, Administrator's Guide, Performance Tuning Guide, Backup and Recovery Advanced User's Guide, Backup and Recovery Basics

3. metalink (MOS)

4. Data Server Internal

5. Recommended books