From TOP command linux i have found a proccess oracle this use many CPU. The PID proccess 6434
From Oracle connession i haved launched this select:
SQL> select sid from v$session, v$process
2 where paddr = addr
3 and spid = ‘6434’;
This is output of select
SID
———-
338
I find with google search this query :
select char(client_name,10) as “Sess”,CAST(CAST(bytes_received/1024/1024 as decimal(15,0))/CAST((current_timestamp-start_time)seconds as decimal(15,0)) as decimal(10,2)) as “Receive [MB/s]”,CAST(CAST(bytes_sent/1024/1024 as decimal(15,0))/CAST((current_timestamp-start_time)seconds as decimal(15,0)) as decimal(10,2)) as “Sent [MB/s]” from sessions where session_type=’Node’
output:
Sess Receive [MB/s] Sent [MB/s]
———– ————— ————-
KELLY 4193.64 0.00
KELLY 0.00 0.00