I did a quick check of some facts I’m studying about Oracle 12c and its new threaded execution mode. I set this parameter:
alter system set THREADED_EXECUTION=true scope=spfile;
I had to connect SYS as SYSDBA with a password to get the system to bounce.
Then it had these processes only:
oracle 1854 1 0 09:17 ? 00:00:00 ora_pmon_orcl oracle 1856 1 0 09:17 ? 00:00:00 ora_psp0_orcl oracle 1858 1 2 09:17 ? 00:00:00 ora_vktm_orcl oracle 1862 1 3 09:17 ? 00:00:00 ora_u004_orcl oracle 1868 1 99 09:17 ? 00:00:17 ora_u005_orcl oracle 1874 1 0 09:17 ? 00:00:00 ora_dbw0_orcl
This differs from some of my 12c OCP study material but agrees with the manuals. Only pmon, psp, vktm, and dbw have dedicated processes.
Also, I found that I needed this value in the listener.ora:
dedicated_through_broker_listener=on
I needed that value to connect using a thread. Before I put that in it spawned a dedicated server process when I connected over the network.
Lastly, contrary to what I had read I didn’t need to set the local_listener parameter to get the new connections to use a thread:
SQL> show parameter local_listener NAME TYPE VALUE ------------------------------------ ----------- --------------------- local_listener string
– Bobby
