Introduction to Oracle Architecture

The Oracle database system is very huge. For some beginners, I always feel that I don't know how to learn from it. I want to learn a lot, but it is hard to learn, so today, I want to share my learning experience with everyone. I hope that those who are just getting started will have a general understanding of Oracle and take less detours.

In fact, no matter what database you want to learn, remember to master the database principles. I suggest you look at the database principles. It may be boring at the beginning, but it doesn't matter, it will be helpful for you to learn about the database later.

Second, we should master SQL statements and be familiar with SQL statements. In many databases around us, no matter which database we use, SQL statements are similar. Before getting started with Oracle, if you have a good understanding of the database principles and SQL statements, learning Oracle is not very difficult.

First, let's first look at the Oracle architecture, how to create databases, tablespace, and delete;

Second, I read the Oracle system and have a system understanding of Oracle databases. If you are a DBA, you need to see how to manage, create tables, modify, query, and delete the database, grant permissions, roles, and audits to different users. In particular, databases are often backed up.

Third, the focus of Oracle database backup and recovery should be on the issue of database exception errors for a DBA, which should be handled in a timely manner. Of course, this can be ignored for development. If you like to better understand what I think is better, focus on the SQLPLUS statement. I hope the above is a little helpful for beginners, so don't lose your way.

I. Positioning

Oracle has two major parts: development and management. Development is mainly about writing stored procedures, triggers, and so on, as well as using Oracle's Develop tool for form. It is a bit similar to a programmer who needs to have strong logical thinking and creative ability. I personally think it will be hard, but it is a problem of youth. management requires a deep understanding of the principles of Oracle databases, it has the ability to perform global operations and close thinking, and has a greater responsibility. Because a small mistake will lead down the entire database, the latter places more emphasis on experience than the former.

Because the database management responsibilities are significant, few companies are willing to ask a person who is just getting started with Oracle to manage databases. For young people who have just graduated, they can choose development first, and then transform to database management after some experience. Of course, this depends on the actual situation of individual users.

Ii. Learning Methods

My approach is simple: Reading, thinking, taking notes, experimenting, thinking, and taking notes.

After reading the theoretical things, Let me calm down and think about it. I will ask myself a few more questions and take notes on what I have learned and what I think. I will do experiments when I cannot figure out or have questions, think about how it works. Similarly, write down the experiment results. Thinking and doing experiments aims to gain a deep understanding of this knowledge point. The process of taking notes is also a process of clarifying your own ideas.

The learning process is to make a problem from fuzzy to clear, then from clear to fuzzy. Every change means that you have learned a new knowledge point.

The learning process is also from point to line, from line to network, from network to surface. When the point turns into a line, you will suddenly feel open. When the network reaches the surface, you are the master.

Many netizens, especially beginners, have obtained questions from the Forum. Have you checked the books, studied the books, and searched the Forum before asking? This is called the inertia of thinking. When someone else answers your question, it will make it difficult for you to understand this knowledge point in a short period of time. However, through your own efforts to study it, you will not only gain a deeper understanding of this knowledge point, more importantly, the research process will improve your ability to solve and analyze problems. In general, no matter what you learn, you will not succeed.

Of course, beginners often go to the forum to raise questions when they encounter problems and do not know where to find information. But in my opinion, can I ask others how to analyze this question? Where can I find relevant materials? What is the answer to this question? It is better to teach people to fish than to teach them to fish.

Next I will talk about how to handle the problem.

First, you must know the official website www.Oracle.com for getting started with Oracle. There are various Oracle versions of databases, application tools, and authoritative official documents. Second, also want to know http://metalink.Oracle.com/here is bought Oracle service or Oracle partners can go in, there are a lot of authoritative solutions and patches. Then there are some famous websites: asktom.Oracle.com www.orafaq.net and www.dbazine.com. There are many experiences here.

Encountered a problem. If it is a conceptual issue, you can first find tahiti.Oracle.com. Here we will give you the most detailed explanation. If any errors occur during the running process. You can go to metalink. If you want to know the experience of transaction processing. You can go to asktom. Of course. This is just relative.

Article by: http://www.programbbs.com/doc/3419.htm