Processes in Oracle

Share this post!

Vote this!

Oracle server processes perform all the database operations such as inserting and deleting data. The oracle processes working with the SGA (oracle memory structure) manage the database.
There are two types of Oracle process

• User process - Responsible for running the application that connects to the database
• Oracle server process - Perform oracle tasks that manage the database.

There are a number of server processes that could be running , Windows will only have one process called Oracle, this process will have one thread for each of the below processes.  more...