Multiprocessing and multithreading with Oracle Database
I would like to understand how Oracle Database software makes use of the multiprocessing and multiprocessing cabalilities of a database server hardware. E.g. if Oracle database runs on a multi-core and/or multi-cpu machines, how does it make use of all the cores and CPUs? And if the CPUs and cores have muti-threading capabilities, how does it uses those capabilities.
Does this depend on how the O/S manages processes and threads, or is it something the database software needs to manage?
Thanks.