Syssesprof (onstat -g ses)

View sysyesprof: User session performance statistics.

sid integer, Session Id

lockreqs decimal(16,0), Locks requested

locksheld decimal(16,0), Locks held

lockwts decimal(16,0), Locks waits

deadlks decimal(16,0) Deadlocks detected

lktouts decimal(16,0), Deadlock timeouts

logrecs decimal(16,0), Logical Log records written

isreads decimal(16,0), Reads

iswrites decimal(16,0), Writes

isrewrites decimal(16,0), Rewrites

isdeletes decimal(16,0), Deletes

Previous slide

Next slide

Back to first slide

View graphic version