Diagnose Performance Issues Using DYNAMIC Performance Views:
v$session : Session Complete Details Type= USER/ BACKGROUND. sid, serial#, event, parameter, etc..
v$session_event -- summary of sessions wait-events prior to Oracle 10g,
v$system_event -- wait experieced by Instace, from the time it started (but only Summary)
View for High Load Session:- Consuming intensive Resource (CPU, PIO, LIO,No of commits/rollback)
v$sesstat, v$sysstat.
Get complete details of wait events experienced, for eg. the time (how long), Sql Statment, Event and corresponding parameter details so as to drill down to the problem resolution.
v$active_session_history
v$session : Session Complete Details Type= USER/ BACKGROUND. sid, serial#, event, parameter, etc..
v$session_event -- summary of sessions wait-events prior to Oracle 10g,
v$system_event -- wait experieced by Instace, from the time it started (but only Summary)
View for High Load Session:- Consuming intensive Resource (CPU, PIO, LIO,No of commits/rollback)
v$sesstat, v$sysstat.
Get complete details of wait events experienced, for eg. the time (how long), Sql Statment, Event and corresponding parameter details so as to drill down to the problem resolution.
v$active_session_history
No comments:
Post a Comment