show parameter threaded

ps -ef |grep ora_ |grep _db02 |wc -l

set linesize 200
set pagesize 50
col spid format a5
col pname format a5
col program format a35
col execution format a10

SELECT spid, stid, pname, program, execution_type
  FROM v$process
 ORDER BY execution_type, pname, program; 

ps aux |grep ora_ |grep -v grep |awk '{SUM += $6} END {print SUM/1024}'

ALTER SYSTEM SET threaded_execution=true SCOPE=spfile;

SHUTDOWN IMMEDIATE;

STARTUP

set linesize 200
set pagesize 50
col spid format a5
col pname format a5
col program format a35
col execution format a10

SELECT spid, stid, pname, program, execution_type
  FROM v$process
 ORDER BY execution_type, pname, program; 

ps -ef |grep ora_ |grep _db02

-- Clean-Up

ALTER SYSTEM SET threaded_execution=false SCOPE=spfile;