Learning methods that Oracle beginners have to learn

It can be said that Oracle's related systems are too large, so for Oracle beginners, there will be some difficulties in the actual learning process, it can be said that they do not know from that learning, the following articles mainly explain the answer to this question. Of course, I am also learning about Oracle.

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 learning 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 database management has a major responsibility, few companies are willing to ask a person who has just been in contact 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 of Oracle: www.oracle.com, which contains 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.

Oracle has a huge system. To learn about it, you must first understand the Oracle framework. Here, we will give a brief introduction to the Oracle architecture, so that Oracle beginners can have a general understanding of Oracle.

1. The physical structure consists of control files, data files, redo log files, parameter files, archive files, and password files)

Control File: contains necessary information to maintain and verify the integrity of the database. For example, a control file is used to identify data files and redo log files. A database requires at least one control file.

Data File: The file that stores the data.

Redo log file: contains the changes made to the database, so that data recovery can be enabled in case of a fault. A database requires at least two redo log files.

Parameter file: defines the features of Oracle routines. For example, it contains parameters for adjusting the memory structure of SGA.

Archive file: an offline copy of the redo log file, which may be necessary to recover from a media failure.

Password File: Authenticate which users have the permission to start and close Oracle routines.

2. Logical Structure tablespaces, segments, partitions, and blocks)

Table space: a set of data files in the basic logical structure of the database.

Segment: the space occupied by objects in the database.

ZONE: A large storage space reserved for data at one time.

Block: the most basic storage unit of ORACLE, which is specified when a database is created.

3. Memory Allocation SGA and PGA)

SGA is the memory area used to store database information, which is shared by database processes. It contains data and control information of the Oracle server. It is allocated in the actual memory of the computer where the Oracle server resides. If the actual memory is insufficient, it is written into the virtual memory.

PGA: contains the data and control information of a single server process or a single background process. The SGA shared with several processes is the opposite. PGA is only used by one process, PGA is allocated during Process Creation and recycled upon Process Termination.

4. background process data writing process, log writing process, system monitoring, process monitoring, Checkpoint Process, archiving process, service process, and user process)

Data Writing Process: responsible for writing changed data from the database buffer cache to the data file

Log writing process: writes changes in the redo log buffer to online redo log files.

System Monitoring: Checks Database Consistency and starts database recovery when the database is opened if necessary.

Process Monitoring: clears resources when an Oracle process fails.

Checkpoint Process: updates the database status information in control files and data files whenever changes in the buffer cache are permanently recorded in the database.

Archiving process: backs up or archives a full log group during each log switch.

Service Process: User process service.

User process: On the client, the user is responsible for passing the user's SQL statement to the service process and retrieving the query data from the server segment.

5. Oracle routine: The Oracle routine consists of the SGA memory structure and background processes used to manage the database. A routine can only open and use one database at a time.

6. SCN (System ChangeNumber): System Change number, a serial number maintained by the System. It is automatically added when the system needs to be updated. It is an important indicator of maintaining data consistency and sequential recovery in the system.

4. Deep Learning

Management: You can take an examination of the OCP certificate. First, you can have a system for Oracle, and then read Oracle Concepts and Oracle online document. You will have a deeper understanding of the oracle principles, at the same time, you can start some special research such as RMAN, RAS, STATSPACT, DATAGUARD, TUNING, BACKUP & RECOVER, etc.

Development: for Oracle development, after learning about the basic architecture of Oracle, you can focus on PL/SQL and Oracle development tools. PL/SQL mainly includes how to write SQL statements, how to use Oracle functions, How to Write stored procedures, stored functions, and triggers.

Oracle development tools are mainly Oracle Developer SuiteOracle Forms Developer and Reports Developer), so that Oracle beginners can learn how to use these tools skillfully.

Iii. Oracle System