Oracle Basics and Management

Oracle
http://www.cnoug.orghttp://www.itpub.netwww.oradb.nethttp://www.oracle.com.cn/


Sql
Microsoft SQL Server Chinese home http://www.microsoft.com/china/sql/default.mspx

Database Network College http://www.pconline.com.cn/pcedu/empolder/db/index.html teaches you to learn SQL statements from scratch, MYSQL, SQL Server.



The road of Data Warehouse http://www.dwway.com/is a website that has many years of history, focused on data Warehouse collection, Data Warehouse knowledge discussion, merged with Www.yiyiya.net in May 2002.


Data mining
Data Mining Discussion group http://www.dmgroup.org.cn/This is a few graduate students interested in data mining together to discuss the content of the class.

Data Mining Institute http://www.dmresearch.net/A technical description of the basic concepts of data mining. Classification, association, clustering, web mining algorithms, application scenarios, and data mining tools and experience.
Oracle
Itpub Forum Http://www.itpub.net famous It Technology forum. Especially in the database technology. The predecessor of the Itpub forum should be the Oracle group based in smiling, whose home page should be at the bottom of this address! http://oracle.myrice.com/

Cnoug Forum http://www.cnoug.org/oracle China User group, experts gathered to discuss Oracle database installation, management, backup, recovery, performance optimization; Oracle database Advanced technology ha, VLDB, Oracle INTERNAL Oracle OCP certification, etc.

Chinaunix-oracle Sub-Forum http://www.chinaunix.net/forum/viewforum.php?f=19 The number of online, daily discussion of more posts.

OracleDB Technical Forum Http://www.oracledb.com.tw/Oracle Education Training, certification, books and other related information and experience exchange.

Dbanotes.net http://www.dbanotes.net/The author of the book review of the non-liability Data Warehouse Homepage



http://www.jlcomp.demon.co.uk Oracle Database Technology Master Jonathan Lewis's site.



Hotsos http://www.hotsos.com/is an authoritative website that focuses on Oracle database performance. You can find a lot of classic technical papers on Oracle.

http://asktom.oracle.com/

http://www.oracle-base.com/

http://oracle.ittoolbox.com/

http://www.oraperf.com/

Oracle's introductory experience--> highly recommended

Oracle's system is too large, for beginners, it is inevitable that some will not be able to feel, what all want to learn, the results of what are not good, so the learning experience to share, I hope that the people just getting started on Oracle has a general understanding, less to take some detours. First, positioning Oracle divided into two pieces, a piece is development, a piece 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. Sort of like a programmer, need to have a strong logical thinking and creative ability, personally think will be more hard, is the youth Rice J; management requires a deep understanding of the principles of Oracle database, the ability to control the overall situation and close thinking, responsibility is greater, because a small error will down the entire database,   In contrast to the former, the latter value experience more. 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, that is: reading, thinking, writing notes, doing experiments, rethinking, 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; In the confusion or doubt, do the experiment, think about how this, Also, 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 the process I'm dealing with.

First you need to know Oracle's official website: www.oracle.com Here are Oracle's various versions of databases, utilities, 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.

    is 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. Oracle's system Oracle's system is very large, to learn it, first of all to understand the Oracle 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 close Oracle Routines   2, logical structure (table space, segment, area, block) Tablespace: is the basic logical structure in the database, a series of data file 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 allocation (SGA and PGA) SGA when building databases: is the memory area used to store database information, This information is shared by the database process. 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 recycle   4 when the process is created, the 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 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, it will also start when the database is openDatabase recovery Process Monitoring: Responsible for cleaning up the resource checkpoint process when an Oracle process fails: responsible for updating the state information in the control files and data files whenever changes in the buffer cache are permanently recorded in the database. Archive process: The full log group is backed up or archived during each log switch: User process service. 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: An Oracle routine consists 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): Changes to systems, a serial number maintained 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.

Four, in-depth study management: You can test OCP certificate, Oracle First have a systematic study, and then look at Oracle Concepts, Oracle online document, Oracle will have a better understanding of the principles,   At the same time, we can start to study some 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.

A few good books on Oracle introduction

Oracle Official Document: "Concept" above the Oracle system and concepts, is suitable for beginners to see.

OCP's teaching book, 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 machinery Industry press. Describes several web site http://tahiti.oracle.com Oracle's official documentation Http://metalink.oracle.com/oracle's technical Support website. Need to purchase Oracle services to have an account, to log in, there are a large number of knowledge Base, a large number of problem-solving experience. Http://www.oracle.com Oracle's official website, where you can down Oracle's software, official documentation, and get the latest news Http://www.dbazine.com/Oracle magazine http:// asktom.oracle.com http://www.orafaq.net/http://www.ixora.com.au/http://www.oracle-base.com http:// Www.dba-oracle.com/oracle_links.htm



[Getting Started book]

First look at some Oracle basics books, such as Oracle Management Basics, and then learn about the syntax of Oracle Sql,pl/sql, and advanced development books and materials for Oracle databases. At the same time to practice more, think more, see more. Recommended book:

Oracle PL_SQL Advanced Programming Oracle Database Administrator technical guide oracle8i Designing and tuning for performanceoracle9i SQL Referenceoracle Beginner's Guide Pl_sql User Guide and reference (recommended)

Forum Csdnitpubcnoug

Oracle Video Download ftp://202.96.64.144/

http://www.oradb.net/

, where to download Oracle software, Oracle's document Otn.oracle.com, need to register an account, but a free 2, beginners should see what Oracle books? The Oracle9i Beginner's Guide, oracle9i dba Manual, Oracle9i dba Basic Tutorial, or to www.china-pub.com, typing Oracle in the search field, you can see all kinds of Oracle books, and there are 3,  What are the good Oracle software tools? A, Toad, in www.quest.com, the registration code in the Forum can be found in B, pl/sql developer in www.51delphi.com can down to