On Thu, Jan 26, 2012 at 3:18 PM, Thomas Kellerer
<spam_eater@gmx.net> wrote:
Rodrigo E. De León Plicet wrote on 26.01.2012 22:52: Oracle claims it for releases going back to 7
Quote from the Oracle concepts manual:
"Multiple-process Oracle (also called multiuser Oracle) uses several processes to run different parts of the Oracle Database code and additional processes for the users—either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantages of a database is managing data needed by multiple users simultaneously."
Oracle offers intra-query parallelism. I am not entirely sure how they do it, but it is supported. I don't know if these subtasks are pthreads within the separate session process or if they are additional processes.
Best Wishes,
Chris Travers