3 ms·
FWIW: Oracle also uses one process per connection on Unix/Linux. I think since Oracle 12 this can be changed during installation, but it's still the default. W
by hans_castorp 6y ago
FWIW: Oracle also uses one process per connection on Unix/Linux. I think since Oracle 12 this can be changed during installation, but it's still the default.
When using connection pools, this isn't really such a problem in the majority of the cases.
- voganmother42 6y agoIn oracle its been an option for a long time(since atleast 10g, I think before), shared vs dedicated servers in their language, and in my experience pretty rare to use shared servers.
- hans_castorp 6y agoShared servers represent a built-in connection pool. They still use one process for each connection. Oracle uses a thread model in Windows (one "orcle" process, each connection is a thread), but not on Unix/Linux.
- aeyes 6y agoOracle doesn't handle TCP connections, the Oracle Net Listener (a separate process) is responsible for that. It supports connection pooling. I'm no expert on how this scales compared to Postgres as it is hard to find benchmarks, thanks to Oracle licensing terms.