How to find what a user Oracle process that uses 100% cpu is doing
We have a process in a Weblogic server that connects to a database 11g in another server, and as soon as it starts the process for that connection on the DB side goes to 100% utilization and stays there until we kill it.
In the v$session the event is SQL*Net message from client. I tried do a sql trace from another session but no relevant information is captured, and I can't change the client process.
Software Versions
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
HP-UX xxxx B.11.31 U ia64
AWR Report - Foreground Wait Events
In the v$session the event is SQL*Net message from client. I tried do a sql trace from another session but no relevant information is captured, and I can't change the client process.
Software Versions
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
HP-UX xxxx B.11.31 U ia64
AWR Report - Foreground Wait Events
| Event | Waits |
|---|
2