Focused on Oracle DBA's position in the growth phase

Mainly for Oracle DBA in the growth stage of the positioning, learning methods and other aspects of the classic discussion, the details please refer to the following.

First, positioning

Oracle is divided into two chunks, one for development and one for management. Development is mainly about writing stored procedures, triggers and so on, and using Oracle's develop tool as a form. A bit similar to the programmer, need to have strong logical thinking and creative ability, personal feel will be more hard, is the youth Rice J; Management needs to have a deep understanding of the principles of Oracle database, the ability to manipulate globally and the tight thinking, the responsibility is greater, because a small mistake will drop the entire database, the former, the latter more emphasis on experience. Because database management is a big responsibility, few companies are willing to ask someone who has just contacted Oracle to manage the database.

For young people just graduated, can choose to do development, have some experience after the transformation, to do database management. Of course, this still depends on the actual situation of people to decide.

Ii. Methods of Learning

My method is very simple, that is: reading, thinking, writing notes, doing experiments, thinking, and then write notes after reading the theory of things, their own quiet heart to think about, ask yourself a few why, and then to learn and think of the knowledge point to make a note; When you don't know or have questions, do the experiment, think about how it happens, and write down the results of the experiment. Thinking and doing experiments is to understand this point of knowledge in depth. The process of taking notes is also the process of clearing up your own ideas. The process of learning is to make a problem from vague to clear, then from clear to fuzzy process. And each change represents a new point of knowledge that you have learned.

The process of learning is also from the point to the line, from the line to the net, from the network to the surface of the process. When a point becomes a line, you will always have the feeling of being enlightened. When the network to the surface, you are a lot of users, especially beginners, a encounter problems to get the forum to ask, before asking, you have checked the book, have you studied, have you searched the forum? This is called thinking inertia. Someone else to answer your question, will let you in a short period of time to understand this knowledge point, but through their own efforts to study it, not only will be more in-depth understanding of this knowledge point, more importantly, in the process of research will improve your ability to solve problems and analyze problems. In general, no study attitude, no matter what you learn, will not succeed. Of course, beginners are many times because of problems encountered, do not know where to go to find information, will go to the forum to ask questions. But I think, in asking questions, is it possible to ask others how to analyze the problem? Where can I find the relevant information? Instead of the answer to the question, what is it? Give a man a fish rather than a fisherman.

Next I'll talk about the process I'm dealing with. The first thing to know about Oracle's official website: www.oracle.com There are various versions of Oracle's database, application tools, and authoritative official documentation.

Second, know that http://metalink.oracle.com/is here to buy Oracle Services or Oracle partners to go in, there are many authoritative solutions and patches.

Then there are some famous websites: Asktom.oracle.com www.orafaq.net, www.dbazine.com. There is a lot of experience here. I'm having a problem.

If it is a conceptual problem, the first time you can find tahiti.oracle.com, here will give you the most detailed explanation. If something went wrong during the run. can go to Metalink to see. If you want to know the experience of dealing with transactions. can go to Asktom. Of course. It's just relative.

Third, Oracle's system

Oracle's system is huge, and to learn it, first understand the Oracle framework. Here, briefly speaking about Oracle's architecture, gives beginners a holistic understanding of Oracle.

1. Physical structure (composed of control files, data files, redo log files, parameter files, archive files, password files) control files: Contains necessary information to maintain and verify database integrity, for example, control files are used to identify data files and redo log files, a database requires at least one control file Data files: File redo log files that store data: Records of changes made to the database so that data recovery can be enabled in the event of a failure. A database requires at least two redo log file parameter files: Defines the attributes of an Oracle routine, such as a parameter archive that adjusts the size of some memory structures in the SGA: an offline copy of the redo log files that may be necessary to recover from media failure. Password files: Authenticate which users have permission to start and close Oracle routines

2. Logical Structure (table space, segment, area, block) Table space: is the basic logical structure of the database, a series of data Files collection. Segment: Is the space occupied by the object in the database: a large block of storage that is reserved for data at one time: Oracle's most basic storage unit, specifying when the database is built

3. Memory allocation (SGA and PGA) SGA: is the memory area used to store database information that is shared by the database process. It contains data and control information for the Oracle server, which is allocated in the actual memory of the computer where the Oracle server resides, if the actual memory is not enough to be written in virtual memory. PGA: Contains data and control information for a single server process or a single background process, which is the same as the SGA shared by several processes the PGA is a zone that is used only by one process, and the PGA is allocated when the process is created to recycle when the process is terminated

4, background process (data write process, log write process, system monitoring, process monitoring, checkpoint process, archive process, service process, user process) data write process: Responsible for changing the data from the database buffer cache to write to the data file log write process: The redo log buffer changes are written to the online redo log file System monitoring: Check the consistency of the database if necessary, the recovery process that initiates the database when the database is opened is monitored: responsible for cleaning up the resource checkpoint process when an Oracle process fails: responsible for the changes in the buffer cache whenever the change is permanently recorded in the database, Updates the database state information in the control files and data files. Archive process: The full log group is backed up or archived during each log switchover process: User process Service. User process: On the client side, is responsible for passing the user's SQL statement to the service process and taking back the query data from the server segment.

5. Oracle Routines: Oracle routines consist of the SGA memory structure and the background process used to manage the database. A routine can only open and use one database at a time.

6. SCN (System change number): The number of systems changes, a sequence of internal maintenance by the system. When the system needs to be updated automatically increases, he is the system to maintain data consistency and sequential recovery of important signs.

Iv. in-depth learning

Management: You can test the OCP certificate, a system for Oracle to learn, and then see Oracle Concepts, Oracle online document, the principle of Oracle will have a deeper understanding of the principles, and can begin to do some research topics such as: RMAN, RAS, Statspact, DATAGUARD, TUNING, Backup&recover, and so on.

Development: For Oracle Development, after understanding the basic Oracle architecture, you can focus on PL/SQL and Oracle's development tools section. PL/SQL consists mainly of how to write a statement, how to use Oracle's own functions, how to write stored procedures, stored functions, triggers, and so on. Oracle's development tools are primarily Oracle's own Developer Suite (Oracle Forms Developer and Reports Developer), and learn how to use these tools skillfully.

Introducing a few good books on Oracle Oracle Official Documentation: "Concept" above is about Oracle's systems and concepts, which are ideal for beginners. The OCP's teaching book, also known as the Study Guide (SG). Oracle8i Backup Recovery manual Oracle8 Advanced Management and Optimization oracle8i PLSQL programming Oracle8 Database Administrator manual The above books are published by the mechanical industry press.

Describes several website Http://tahiti.oracle.comoracle official documentation for Http://metalink.oracle.com/oracle's technical support website. Need to purchase Oracle services to have an account, to login, there are a lot of knowledge Base, a lot of problem solving experience.

http://www.arhzfu.com/snseuf/

http://yijciqit.com/hxkvb/

http://434503.com/ldqec/

http://www.ztvzm.com/cwyhpj/

http://ahdhsa.com/rxzbte/

http://www.589303481.com/joecq/

http://www.mxwzp.com/rfa/

http://www.takerrkug.com/nfflji/

http://yanhucity.com/zdqmmh/

Focused on Oracle DBA's position in the growth phase