Database Tuning (MOSC)

MOSC Banner

monitoring the test where we have perfomance issue

edited Aug 26, 2013 10:25PM in Database Tuning (MOSC) 1 commentAnswered
My Dear friends,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center