hostname high cpu usage investigation:

 hostname high cpu usage investigation:

oracle@PRD:hostname:hostname:(54) /home/oracle
$ ps -eo pcpu,pid,user,args --sort=-pcpu | head -n 11
%CPU     PID USER     COMMAND
62.7  131071 oracle   ora_j001_hostname
11.9  192558 oracle   oraclehostname (LOCAL=NO)
10.0  193835 oracle   oraclehostname (LOCAL=NO)
 8.0  245093 root     s1-agent
 5.8  184915 oracle   oraclehostname (LOCAL=NO)
 5.6  109801 oracle   oraclehostname (LOCAL=NO)
 5.1  184808 oracle   oraclehostname (LOCAL=NO)
 4.9  133171 oracle   oraclehostname (LOCAL=NO)
 4.8  133165 oracle   oraclehostname (LOCAL=NO)
 4.7  130391 oracle   oraclehostname (LOCAL=NO)

SELECT s.sid, s.serial#, s.username, s.program, s.module, s.action
FROM v$session s, v$process p
WHERE s.paddr = p.addr
AND p.spid = '131071';

SELECT * FROM v$scheduler_running_jobs WHERE session_id = '2503';

SELECT sql_text
FROM v$sqltext
WHERE sql_id = (SELECT sql_id FROM v$session WHERE sid ='2503')
ORDER BY piece;