Skip to content

what is a oracle user process and oracle server process – knowledge article for the new oracle dba




you are a new oracle dba and you would like to know about what is a oracle user process and what is a oracle server process.
you need to use a tool like sqlplus to connect to a oracle database.There are also other tools like toad, oracle sql developer etc with which you can connect to the database.
when you first start the sqlplus tool on your windows machine and you connect to the database whih is on a different machine , you are infact opening a connection to the database. your connection is called the user process and this process talks with the oracle listener which is on the server. The listener then hands over your connection to a process that gets created on the server. This is called the server process and this server process which exists on the server does all the work that your user process on your machine asks it to do.

read about the oracle process architecture here
oracle user process and server process

VN:F [1.9.22_1171]
Rating: 9.6/10 (8 votes cast)
VN:F [1.9.22_1171]
Rating: +4 (from 4 votes)
what is a oracle user process and oracle server process - knowledge article for the new oracle dba , 9.6 out of 10 based on 8 ratings

Post a Comment

You must be logged in to post a comment.