Chinaunix首页 | 论坛 | 博客
  • 博客访问: 5609884
  • 博文数量: 745
  • 博客积分: 10075
  • 博客等级: 上将
  • 技术积分: 7716
  • 用 户 组: 普通用户
  • 注册时间: 2005-04-29 12:09
文章分类

全部博文(745)

文章存档

2019年(1)

2016年(1)

2010年(31)

2009年(88)

2008年(129)

2007年(155)

2006年(197)

2005年(143)

分类: Oracle

2006-08-06 23:23:36

The Oracle architecture includes a number of primary components, which are discussed further in this lesson.
 
Oracle server:There are several files, processes, and memory structures in an Oracle server; however, not all of them are sued when processing a SQL statement. Some are used to improve the performance of the database, ensure that the database can be recovered in the event of a software or hadware error, or perform other tasks necessary to maintain the database. The Oracle server consists of an Oracle instance and an Oracle database.
 
Oracle instance:An Oracle instance is the combination of the background processes and memory structures. The instance must be started to access the data in the database. Every time an instance is started, a System Global Area(SGA) is allocated and Oracle background process. They consolidate functions that would otherwise be handled by multiple Oracle programs running for each user. The background processes perform input/output(I/O) and monitor other Oracle processes to provide increased parallelism for better performance and reliability
 
Oracle database: An Oracle database consists of operating system files, also known as database files, that provide the actual physical storage for database information. The database files are used to ensure that the data is kept consistent and can be recovered in the event of a failure of the instance
 
Other key files:Nondatabase files are used to configure the instance, authenticate privileged users, and recover the database in the event of a disk failure
 
User and server processes:The user and server processes are the primary processes involved when a SQL statement is executed; however, other processes may help the server complete the processing of the SQL statement.
 
Other processes:Many other processes exist that are used by other options within Oracle, such as Advanced Queuing, Real Application Clusters, Shared Server, Advanced Replication, and so on. These processes are discussed within their respective courses
 
阅读(2349) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~