On Thu, Jan 26, 2012 at 3:18 PM, Thomas Kellerer <spam_ea...@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 >> > > Not true. > > 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
