The composition of the oracle database

数据库 专栏收录该内容
5 篇文章 0 订阅


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.

  • 0
  • 0
  • 0
  • 一键三连
  • 扫一扫,分享海报

©️2021 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页
钱包余额 0