ORACLE little knowledge architecture

Nov 20 posted in Oracle (RSS), 129 views.
As a regular dealings with the database software developers, has not been resolved to seriously sum up the database. Although most came into contact with open source, mysql, then install the linux once oracle, and that was the end of 2005 when the oracle that feels really heavy, I spent a total of 10G of space is not enough. Has been followed do not want to touch. But later in database development, or middleware used in most developing or oracle. Sense of each are not as flexible as a database, including the later sybase, informix, db2, Teradata, I would like to in-depth look at the database's internal structure and working principle, so spent the day yesterday, time to learn a bit oracle architecture.
rn

rn
ORACLE from the routine (Instance) and database (Database) composed of two parts. Routine is a set of memory structures and background processes collections. The memory structure includes data cache, redo log buffer and shared pool of three parts, these memory structures referred to as SGA (System Global Area); background process includes SMON, PMON, DBWR, CKPT, LGWR, ARCH and so on. The database is a collection of a set of OS files, which consists of data files, control files and redo log files. As for the detailed function of each block and each process uses, see the detailed documentation. And then there are the database works, to be continued
rn
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of ORACLE little knowledge architecture

  • ORACLE instance of the process of the structure and memory structure

    ORACLE instance of the process of the structure and memory structure 1. ORACLE instance of the process of the structure and memory structure 1) the process of the structure of the process is a mechanism for the operating system, which operated a seri ...

  • How to restore archived logs have a missing data file

    Kamus yesterday asked a question, if a cold backup, but missing one data file, but the existence of all of the archive, it should be how to restore data files. Try yourself, is probably the following steps: [oracle @ jumper eygle] $ sqlplus "/ a ...

  • Log archive have a how to restore lost data files

    Kamus yesterday asked a question, if a cold backup, but missing one data file, but the existence of all of the archive, it should be how to restore data files. Try yourself, is probably the following steps: [oracle @ jumper eygle] $ sqlplus "/ a ...

  • Oracle database on the start and stop

    Oracle database on the start and stop Shutdown normal: waiting for all users disconnected, the closure of the database, uninstall the instance of the database and shut down. immediate: all users rollback services, the closure of the database, uninsta ...

  • How to have the archive log restore a lost data files

    Kamus yesterday to ask a question, if a cold backup, but missing one of a data file, but the archive of all existence, it should be how to restore data files. Try yourself, is perhaps the following steps: [oracle @ jumper eygle] $ sqlplus "/ as ...

  • Back to archive not archiving

    -bash-2.05b $ svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1. ...

  • Oracle structure

    500) this.width = 500; "height = 324> Data cache pool (Database Buffer) data files stored in data blocks of copy, to facilitate quick access to (minimize physical io). It contains the default buffer pool (Default pool), to preserve the cache ...

  • Detailed: database name. Instance name. ORACLE_SID. Database name

    Detailed: database name, instance name, ORACLE_SID, database name, global database names, service names and hand the script to create oracle database Database name, instance name, database name, global database names, service names, This is easy for some

  • Oracle locking mechanism (reprint)

    Blocking mechanism is set up in order to control the concurrent operation of the block interference, to ensure data consistency and accuracy. Oracle database blockade There are three ways: sharing blockade blockade exclusive, shared update blockade [ ...

Leave a Reply

Recent
Recent Entries
Tag Cloud
oracle on linux dbconsole multi imp commit y recordlength accidentally oracle alert log got deleted remove crs vip analysing tkprof reports in oracle 11g manuel schema analyze sqlap@hd copy en  sql y java share+lock+exclusive+oracle criteria hibernate oracle to_date column name size" 30 characters oracle rac dba daily activities crontab format 2 */2 * * * oracle positive number sql script for create partition in table space tkprof incident toad para ubuntu 10.04 apex clear cache columnDefinition hibernate oracle oracle "transaction not connected sga break down util_smtp source aix command reference to_char(timestamp,'yyyy-MM-dd hh24:mi:ss ff') oracle create pfile ora-00845 endless loop sqlplus how to refresh oracle lock table sqlplus inport data csv auto backup oracle data to another oracle ora-01427 bug
Random Entries
Latest Comments
Categories
Related