An Oracle database uses memory structures and processes to manage and access the database. All memory structures exist in the main memory of the computers that constitute the RDBMS.
dell emc training courses malaysia
When applications connect to an Oracle database, they connect to a database instance. The instance services applications by allocating other memory areas in addition to the SGA, and starting other processes in addition to background processes.
Oracle Database Processes
A process is a mechanism in an operating system that can run a series of steps. Some operating systems use the terms job, task, or thread.
comptia training courses malaysia
For the purposes of this topic, a thread is equivalent to a process. An Oracle database instance has the following types of processes:
- Client processesThese processes are created and maintained to run the software code of an application program or an Oracle tool. Most environments have separate computers for client processes.
citrix training courses malaysia - Background processesThese processes consolidate functions that would otherwise be handled by multiple Oracle Database programs running for each client process. Background processes asynchronously perform I/O and monitor other Oracle Database processes to provide increased parallelism for better performance and reliability.
- Server processesThese processes communicate with client processes and interact with Oracle Database to fulfill requests.
Oracle processes include server processes and background processes. In most environments, Oracle processes and client processes run on separate computers.
Leave a Reply