HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Is a process created in Oracle for every SQL statement?

Submitted by: @import:stackexchange-dba··
0
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.

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.

Context

StackExchange Database Administrators Q#14625, answer score: 9

Revisions (0)

No revisions yet.