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