Last Updated:

mon.sh sesstat #sid


 06/01/98 09:13:40 - statistics for SID: 7
statistic name                                      value
logons current                                          1
user rollbacks                                         12
user calls                                            344
recursive calls                                        18
recursive cpu usage                                     6
session stored procedure space                         29
CPU used when call started                             29
global lock release time                                4
db block gets                                           2
calls to kcmgcs                                         4
Unnecesary process cleanup for SCN batching             4
data blocks consistent reads - undo records a           2
deferred (CURRENT) block cleanout application           2
table scans (direct read)                               2
table scan rows gotten                                  2
cluster key scan block gets                             1
parse time elapsed                                      5
parse count                                           174
execute count                                        1704
bytes sent via SQL*Net to client                     1795
bytes received via SQL*Net from client                 12
get SCN recovery lock in EX mode                       27
OS User time used                                       2
OS Integral shared text size                          724
OS Integral unshared data size                          5
OS Voluntary context switches                           3


Questions or comments ? Send a note to oraperf@yahoo.comom