Multiple-Process Oracle Systems (107)

Multiple-process Oracle (also called multiuser Oracle) uses several processes to run

different parts of the Oracle code and additional processes for the users—either one

process for each connected user or one or more processes shared by multiple users.

Most database systems are multiuser, because one of the primary benefits of a

database is managing data needed by multiple users at the same time.

Each process in an Oracle instance performs a specific job. By dividing the work of

Oracle and database applications into several processes, multiple users and

applications can connect to a single database instance simultaneously while the system

maintains excellent performance.

[@more@]