patternMinor
Is a process created in Oracle for every SQL statement?
Viewed 0 times
processstatementcreatedsqleveryfororacle
Problem
After reading the Oracle docs, it´s still not clear for me if an Oracle process is created for every SQL statement or just for every connection (or not really related to both).
Any comment here would be really great.
Thanks.
Any comment here would be really great.
Thanks.
Solution
A process is created per connection, which can then execute SQL statements for the duration of the connection.
A SQL statement may use more than one Oracle background process (for things like Parallel Query) during its execution, but these aren't forked specifically for the SQL statement.
Note that I'm ignoring things like connection pooling (DRCP) and shared servers (MTS) to keep the answer simple.
A SQL statement may use more than one Oracle background process (for things like Parallel Query) during its execution, but these aren't forked specifically for the SQL statement.
Note that I'm ignoring things like connection pooling (DRCP) and shared servers (MTS) to keep the answer simple.
Context
StackExchange Database Administrators Q#14625, answer score: 9
Revisions (0)
No revisions yet.