Oracle process overview

Oracle process overview. There are 3 types of oracle processes:
USER processes
SERVER processes
BACKGROUND processes

connected to a user application (eg sql*plus)
controls the application
associated with an oracle server process

Server processes
there are 2 types of oracle server process, depending on configuration
Dedicated ( 1 server process per user process )
Shared ( user processes are handled by a shared pool of server processes)

Leave a Reply