Re: Pls help to interpret

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Pls-help-to-interpret-tp7278p7280.html

Your db is not heavly loaded. Your db is okay.
Your top event is CPU, but you are using 0,4 cpu per sec.
Your I/O subsystem is performing good as well.

That SQL (SELECT PEGGING_ID) you have sent to me is CPU bound and It is executed so frequently.
BEGIN OE_SCH_CONC_REQUESTS.Request takes plenty of time as well. It also spents its time significantly on CPU.
Bytheway, this is not a CPU problem. You have the necessary CPU resources.
You are just using them.
And those 2 session that I mentioned above do lots of "gets".

So, I would concantrate on tracing the related sessions that are executing these sqls.
I would check the execution plan as well.
I would run the BEGIN OE_SCH_CONC_REQUESTS manually with correct arguments and check.
I would go inside the sqls that are present in OE_SCH_CONC_REQUESTS.Request and see if there is a big loop or a heavy sql statement there.. I would try to check the tables from where it gets the data..  Maybe there is something to be done in terms of archiving or purging..