The composition of the oracle database

本文详细介绍了Oracle数据库的组成部分,包括安装在主机计算机上的Oracle软件、包含用户数据与元数据的物理文件、确保数据完整性的控制结构、负责数据存取与恢复的后台进程以及用于网络通信的Oracle Net等。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

 

Oracle database is composed of the following elements:


1、The Oracle software that you install on your host computer.


2、The database, which is a collection of physical files on one or more disks.


   The database contains user data, metadata, and control structures. Metadata, or data about the data, is the collection of information about a disk that permits Oracle

software to manage user data. An example of metadata is the data dictionary. Control structures(such as the control file and redo log)ensure the integrity, availability, and

recoverability of user data.


3、The Oracle instance, which is composed of the following:


   (1)the background processes, which are the operating system processes or threads that perform the work of accessing, storing, monitoring, and recovering user data, metadata, and control files associated with the database.


   (2)The Shared memory areas used by the background processes


4、Server processes that perform work on behalf of connected users and applications, and the memory and temporary storage used by these processes

   server processes parse and execute SQL statements, and retrieve and return results to the user or application.


5、Oracle Net, which is a software layer that enables client applications and Oracle Database to communicate over a network, and the Oracle Net listener, which is a process that listens for connection requests from the network.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值