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

This article introduces the relevant knowledge of "which Oracle learning suggestions". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Learning Oracle is a long and arduous process. If there is no interest, just forced to learn, then it is very difficult to learn well. To a certain extent, if you want to further improve, you have to come into contact with a lot of things other than Oracle, such as Unix, such as network, storage and so on. Therefore, if you are really determined to learn Oracle well, you must be interested. With interest, everything will become simple and happy. To sum up briefly, that is: interest, study, practice.

How to get started is the biggest headache for many beginners. Oracle involves too many aspects: SQL, management, optimization, backup and recovery. So where to start to learn well? If you have studied database theory in college, or have a certain database foundation, it is naturally good; if not, it is really a big problem. Personally, I think we should start with SQL sentences. The better textbook is "SQL and PL/SQL" certified by Oracle OCP. When learning SQL, stick to SQLPLUS, a tool that comes with Oracle as much as possible.

With a certain SQL foundation, it is necessary to understand the architecture of Oracle as much as possible, which involves the content of Oracle management. When I was studying, the Oracle9i DBA Handbook of Machinery Industry Publishing House helped me a lot. Maybe the 11g version is out now. Oracle's "Oracle Concepts" is a great book that is good for understanding Oracle architecture. Each Oracle version has a corresponding version, you can read it carefully several times, each time there will be a new harvest.

Almost all of the company's products now use Oracle, when we do maintenance, backup and recovery is the content that we have to contact. For those with a small amount of data, such as 20 or 30 gigabytes, you can also consider using exp/imp to back up and restore, but with a large amount of data, this method is not suitable at all. So it is inevitable to learn Oracle backup and recovery technology. In the case of a large amount of data, Oracle recommends using RMAN for data backup and recovery. At present, there are a lot of database backup and recovery software on the market, in fact, many of them are also called RMAN in the background. Oracle 9i RMAN backup and recovery Technology published by Tsinghua University Press is a very good book to introduce RMAN.

With the above foundation, it can be said that it has been started, and some of the primary Oracle problems encountered will no longer be at a loss. However, we still have a long way to learn. Our users may often complain that the database is slow. At this time, if you have some knowledge of optimization, it will be easy to do. Sometimes you will see a job that needs to be run for several hours before optimization, and may be completed in a few seconds after optimization! Oracle9i's performance diagnosis toolkit statspack and Oracle10g/11g 's automatic work conformance repository AWR are all good helpers for tuning. The Oracle9i STATSPACK High performance Adjustment published by Machinery Industry Press is a good book for learning statspack.

In database architecture, programming optimization, there is a great book, this is the world's top Oracle expert Thomas Kyte wrote "Oracle9i&10g programming Art" (English name "Expert Oracle Database Architecture"). Tom used to write a book called "Expert One-on-One Oracle", which is also very classic. These two books are regarded as a treasure book by many Oracle learners. If you want to study deeply on Oracle, you are strongly recommended to study them carefully.

If you have mastered the above content, or basically mastered the above content, then you are a master of Oracle in the eyes of many people, and it should not be a problem to solve the database problems in the company's products. However, Oracle has a lot of advanced content to learn further. Here are some of them for reference only to those who are interested.

1. Advanced replication technology

2. Oracle Real Application Cluster (RAC)

3. Data Guard

4. Oracle Stream

5. Data warehouse

6. Proc and OCI programming

The reference materials for these high-level contents listed above are mainly the electronic documents of Oracle. To tell you the truth, I am not familiar with the data warehouse, Proc, and OCI programming of the above columns.

In the process of learning Oracle, making full use of network resources can get twice the result with half the effort.

This is the end of the content of "which Oracle Learning suggestions". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.