Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why "execute count" larger than "user call" in v$sysstat.

Why "execute count" larger than "user call" in v$sysstat.

From: <anysql_at_gmail.com>
Date: 12 May 2005 19:54:41 -0700
Message-ID: <1115952881.234586.304040@g43g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US