patternMinor
Question about 'user process' in the context of Oracle
Viewed 0 times
theprocessuseraboutcontextoraclequestion
Problem
The following is an excerpt from Oracle's documentation:
When a user runs an application
program (such as a ProC program) or
an Oracle tool (such as Enterprise
Manager or SQLPlus), Oracle creates a
user process to run the user's
application.
As per my understanding, a user process is a piece of software that can connect to an Oracle server. You (the user) can start this piece and then connect to Oracle. If so, why does Oracle create a user process to run the user's application?
When a user runs an application
program (such as a ProC program) or
an Oracle tool (such as Enterprise
Manager or SQLPlus), Oracle creates a
user process to run the user's
application.
As per my understanding, a user process is a piece of software that can connect to an Oracle server. You (the user) can start this piece and then connect to Oracle. If so, why does Oracle create a user process to run the user's application?
Solution
an user process is a piece of software
that can connect to an oracle server.
You (the user) can start a piece of
this kind of software, then connect to
oracle.
Not quite. A User Process in Oracle is different than a client, which is what I think you are referring to. The user starts a client program (SQLPlus, ProC, etc.), which runs on the client system. This program contacts the Oracle database server, typically either via TNS or IPC. It is the Oracle database that spawns the User Process. It's a bit confusing terminology in that a User Process from the database perspective is really just another process that Oracle starts, but it is specific to a user's connection to the database - it is a server process. It is outside of the user's direct control.
that can connect to an oracle server.
You (the user) can start a piece of
this kind of software, then connect to
oracle.
Not quite. A User Process in Oracle is different than a client, which is what I think you are referring to. The user starts a client program (SQLPlus, ProC, etc.), which runs on the client system. This program contacts the Oracle database server, typically either via TNS or IPC. It is the Oracle database that spawns the User Process. It's a bit confusing terminology in that a User Process from the database perspective is really just another process that Oracle starts, but it is specific to a user's connection to the database - it is a server process. It is outside of the user's direct control.
Context
StackExchange Database Administrators Q#3676, answer score: 7
Revisions (0)
No revisions yet.