How to grow into a real Oracle dba__oracle

First, positioningOracle is divided into two pieces, one is development, the other is management. Development is mainly written to write stored procedures, triggers, and so on, as well as using Oracle's develop tool to do 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 requires a deep understanding of the principles of Oracle databases, the ability to manipulate globally, and a strong sense of responsibility, because a small error will drop the entire database, which in contrast to the former, the latter more value experience. 　　Because of the heavy responsibility of database management, few companies are willing to ask someone who has just contacted Oracle to manage the database. For young people who have just graduated, you can choose to do the development, have a certain experience after the transformation, to do the management of the database. Of course, this still depends on the actual situation of people to decide. Second, learning methods 　　My method is very simple, is: reading, thinking, writing notes, doing experiments, thinking, and then write notes to see the theory of things, their own quiet down to think, ask yourself a few why, and then 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 will be, and write down the results of the experiment. To think and do experiments is to get a deeper understanding of this knowledge point. The process of taking notes is also the process of clearing up your own thinking. The process of learning is to make a problem from fuzzy to clear, and then from clear to fuzzy process. 　　And every change means you've learned a new point of knowledge. The process of learning is also from point to line, from line to net, from the network to the surface of the process. When the point becomes a line, you will have a feeling of always being enlightened. When the net to face, you are a lot of friends, especially beginners, a problem to get the forum to ask, before asking, you have checked the book, have you ever studied, did you search the forum? This is called thinking inertia. By someone else to answer your question, will let you in a short time to understand this point of knowledge, but through their own efforts to study it, not only will be more in-depth understanding of this knowledge, but more importantly, the process of research will improve your ability to solve problems and analyze problems. On the whole, no study attitude, no matter what learning, will not succeed. Of course, beginners are often because of the problems encountered, do not know where to find information, will be to the forum to ask questions. But I think that when asking questions, is it possible to ask others how to analyze the problem? Where can I find the relevant information? And not the answer to this question? 　　It is better to teach a man to fish than to teach. 　　Let me talk about my process of dealing with the problem first of all to know Oracle's official website: www.oracle.com Here are Oracle's various versions of the database, application tools and authoritative official documentation. 　　Second, it is also necessary to know that http://metalink.oracle.com/  is here to buy Oracle Services or Oracle partners to enter, with many authoritative solutions and patches. Then there are some famous websites: Asktom.oracle.com www.orafaq.net, www.dbazine.com. There's 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 affairs. can go to Asktom. Of course. 　　 It's just relative. Third, Oracle the System 　　 Oracle's system is huge, and to learn it, you first need to understand Oracle's framework. 　　 Here, give a brief introduction to Oracle's architecture, giving beginners a holistic understanding of Oracle. 1, physical structure (consisting of control files, data files, redo log files, parameter files, archive files, password files) control files: contains the necessary information to maintain and validate 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 for recovery from media failure. Password file: Authenticate which users have permission to start and turn off Oracle routines 2, Logical structure (table space, segment, area, block) Tablespace: 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 chunk of storage space reserved for data: ORACLE's most basic storage unit, specifying 3, memory allocations (SGA and PGA) SGA when building databases: is the memory area used to store database information, which is the database process are shared. It contains data and control information for the Oracle server, which is allocated in real memory on the computer where the Oracle server resides, if the actual memory is not enough to write to virtual memory. PGA: Data and control information that contains a single server process or a single background process. The SGA that is shared with several processes the PGA is an area that is used by only one process, and the PGA is assigned to reclaim 4 when the process is terminated, background processes (data write processes, log write processes, system monitoring, process monitoring, checkpoint Process, archive process, service process, user process data write process: Responsible for writing changed data from database buffer cache to data file log write process: Write changes in redo log buffers to online redo log files System monitoring: Checking the consistency of the database if necessary, the recovery process monitoring of the database will be initiated when the database is opened: responsible for cleaning up the resource checkpoint process when an Oracle process fails: Responsible for the changes that occur whenever the buffer cache is permanently recorded in the database, Updates the database state information in the control files and data files. Archiving process: To back up or archive a full log group during each log switch: User accessProcess services. 　　 User process: At the client, responsible for passing the user's SQL statement to the service process and getting the query data back from the server segment. 5. Oracle Routines: The Oracle routines consist of a SGA memory structure and a background process for managing the database. 　　 Routines can only open and use one database at a time. 6. SCN (System change number): A serial number, which is maintained by the system, is changed. 　　 When the system needs to be updated automatically increases, he is the system to maintain data consistency and sequential recovery of important signs. Iv. further studyManagement: You can take a OCP certificate, have a systematic study of Oracle, and then look at Oracle Concepts, Oracle online document, a more in-depth understanding of the principles of Oracle, and can begin to do some research topics such as: RMAN 　　, RAS, Statspact, DATAGUARD, tuning, Backup&recover, and so on. Development: For Oracle developers, after learning Oracle's basic architecture, focus on the Pl/sql and Oracle Development tools section. Pl/sql mainly includes how to write SQL statements, how to use the functions of Oracle itself, how to write stored procedures, storage 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.