We have 15 dbs in one server we got the cpu usage alert, ran top command oracle user is taking 92% cpu usage, now in which db i need to check for that oracle user is taking more cpu among 15 db's?
how would i know that in which db i have to execute the query among the 15db's?
Oracle CPU consumption is shown in V$SESSTAT every session. This view can be used to discover which session is utilising the most CPU.