Forum Stats

  • 3,824,841 Users
  • 2,260,429 Discussions
  • 7,896,325 Comments

Discussions

include the processor id on which each process runs in "oclumon report -process"

User_8VQUE
User_8VQUE Member Posts: 19 Red Ribbon
edited Aug 19, 2020 3:33AM in Database Ideas - Ideas

Hello,

investigating a "CPU starvation" case where I suspect that a user query process (SELECT) impacts the logwriter process itself (waits are seen on "log file sync" event), I found that, unfortunately,  the processor# on which each process runs is not in the columns of "oclumon report -process".

my idea: having the column "processor#"  I could conclude that the process X and Y are on the same CPU and that X impacts Y when the 2 processes are using mainly CPU.

(here the doc https://docs.oracle.com/en/database/oracle/oracle-database/12.2/atnms/oclumon-dumpnodeview.html#GUID-E6489AC0-34B3-4B20-… )

regards

Noel TALARD

COWIGO

User_8VQUEuser8793481berx
3 votes

Active · Last Updated