Hi Guys,
I'm facing system performance issue as CPU utilization(ST06) will always hit up to 90%. Below is my platform's info:
O/S: Window 2003
DB: Oracle 9.2.0.6.0
SAP: Solution Manage 3.2
From ST06, i went on to check from ST06->Detail analysis menu->TOP CPU, from here i realize the top job(with highest CPU utilization) is always <b>ORACLE.EXE</b>.
From here i further proceed to ST04->Oracle Session, and notice there is a active SQL statement that performing heavy Logical read. I further drill down to the SQL statement and found out that FM ORA_SQL_SESSION_READ is the one being executing, and i suspect the native SQL statement that causing the problem....
Do you guys have any idea on my above case....?
1. What is going on for the FM ORA_SQL_SESSION_READ?
2. Do i need execute the FM at the first place?
3. What is the purpose this FM being executing?
Million thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.