Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why "execute count" larger than "user call" in v$sysstat.
I am monitoring the database 8i on solaris sparc (SunOS 5.8) by query
rows from v$sysstat, usually the "user call" is larger than "execute
count", because the "user all" include parse call, fetch call and
execute call, but some times I found the "execute count" much larger
than the "user call", so what's the difference?
System Load (2005-05-13 10:51:58)
22 logons cumulative 148 user commits 8480 user calls 2392 CPU used by this session 20K db block gets 314K consistent gets 287 physical reads 2768 db block changes 145 consistent changes 296 physical writes 0 DBWR buffers scanned 159 free buffer requested 0 free buffer inspected 1096 redo blocks written 1869K table scan rows gotten 193K table fetch by rowid 562 parse count (total) 62 parse count (hard) 4309 execute count 13M bytes sent via SQL*Net to client 226 sorts (memory) 1 sorts (disk)
and
System Load (2005-05-13 10:54:19)
13 logons cumulative 127 user commits 2871 user calls 1488 CPU used by this session 17K db block gets 203K consistent gets 211 physical reads 2313 db block changes 99 consistent changes 287 physical writes 0 DBWR buffers scanned 131 free buffer requested 0 free buffer inspected 1048 redo blocks written 980K table scan rows gotten 273K table fetch by rowid 603 parse count (total) 104 parse count (hard) 5489 execute count 9517K bytes sent via SQL*Net to client 295 sorts (memory) 1 sorts (disk)
System Load (2005-05-13 10:54:25)
19 logons cumulative 156 user commits 3825 user calls 1360 CPU used by this session 6952 db block gets 514K consistent gets 394 physical reads 2592 db block changes 105 consistent changes 564 physical writes 0 DBWR buffers scanned 134 free buffer requested 0 free buffer inspected 1086 redo blocks written 528K table scan rows gotten 363K table fetch by rowid 447 parse count (total) 38 parse count (hard) 3631 execute count 9043K bytes sent via SQL*Net to client 147 sorts (memory) 2 sorts (disk)
Thanks
http://www.anysql.net/en/
Received on Thu May 12 2005 - 21:54:41 CDT