Performance issues in RAC 11g and weblogic
Good morning.
We are experiencing abnormal performance issues in our system.
This is what is happening:
If we check the application server (weblogic server) with the top command we get the following output:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5966 oracle 20 0 133m 30m 18m R 99.5 0.2 15:03.72 frmweb
If I connect to the database and check the session associated to the process id I get the following results:
select inst_id, username,schemaname, osuser, process, machine, port, event, state from gv$session where process = '5966';
INST_ID USERNAME SCHEMANAME OSUSER PROCESS MACHINE PORT EVENT STATE
---------- ------------------------------ ------------------------------ ------------------------------ ------------------------ ---------------------------------------------------------------- ---------- ---------------------------------------------------------------- -------------------
We are experiencing abnormal performance issues in our system.
This is what is happening:
If we check the application server (weblogic server) with the top command we get the following output:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5966 oracle 20 0 133m 30m 18m R 99.5 0.2 15:03.72 frmweb
If I connect to the database and check the session associated to the process id I get the following results:
select inst_id, username,schemaname, osuser, process, machine, port, event, state from gv$session where process = '5966';
INST_ID USERNAME SCHEMANAME OSUSER PROCESS MACHINE PORT EVENT STATE
---------- ------------------------------ ------------------------------ ------------------------------ ------------------------ ---------------------------------------------------------------- ---------- ---------------------------------------------------------------- -------------------
0