Database Architecture An Oracle database server consists of an Oracle database and an Oracle instance. Oracle Database architecture is based on physical and logical structures. Oracle Database Physical Structure Oracle database consists of physical files to store information. Basically there are three types of physical files required for database: Core Files: Data Files [...]
Archive for the ‘Process Architecture’ Category
21 Mar
Background Processes
Background Processes The Oracle architecture has five mandatory background processes that are discussed further in this lesson. In addition to the mandatory list, Oracle has many optional background process that are started when their option is being used. These optional processes are not within the scope of this course, with the exception of the background [...]
21 Mar
Connections and Sessions
Establishing a Connection Before users can submit SQL statements to an Oracle database, they must connect to an instance. The user starts a tool such as SQL*Plus or runs an application developed using a tool such as Oracle Forms. This application or tool is executed as a user process. In the most basic configuration, when [...]
