monitoring the test where we have perfomance issue
I have perfomance issue where the application team will run some job and it will run few hours.
I need to monitor the perfomance issue while test is going on.Apart from below can you please add few more thoughts what more I can capture so that i can diagnoise and troubleshoot the perfomance issue.
1.from below check the load whether it is very high.
select distinct (select value from v$osstat
where stat_name='LOAD') load,LAST_CALL_ET,spid,sw.sid,S.event,sql_text ,s.machine,s.program,s.machine,s.ROW_WAIT_OBJ# from v$session_wait sw,v$sql q,v$process p,v$session s where sw.sid=s.sid