Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

user process and server process

629255Apr 29 2008 — edited Apr 30 2008
Hi all
Oracle9i Database Concepts says
An Oracle instance has two types of processes: user processes and Oracle processes.
A user process executes the code of an application program (such as an Oracle
Forms application) or an Oracle Tool (such as Oracle Enterprise Manager).
Oracle processes are server processes that perform work for the user processes
and background processes that perform maintenance work for the Oracle
server.


If I use sql*plus to connect to Oracle Database, only one process oracle$SID added to "ps -ef | grep oracle" result.
In this connection, what is the user process and what is the server process?

Regards,
Sen
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2008
Added on Apr 29 2008
13 comments
1,066 views