How do I know how many times a particular statement was executed UDB V8 on Aix 5

[dba2adm]

The SNAPSHOT_STATEMENT table function gives the CPU used rows read etc
information. How do I know the total number of time the particular
statement was executed (as in snapshot_dyn_sql's num_executions)?
Also, is the value "STMT_USR_CPU_TIME_S" etc cumulative?

Thanks.

[Amit]

Snapshot monitor just give you a snapshot of the statements that are
executing at the time you took the snapshot. To capture all the
executions of statements and figure out the number of times a
statement was executed reliably you need to create and event monitor
on the database. Look at CREATE EVENT MONITOR in sql referebce for
more details.

db*****@yahoo.com wrote in message news:<90**************************@posting.google. com>...

The SNAPSHOT_STATEMENT table function gives the CPU used rows read etc
information. How do I know the total number of time the particular
statement was executed (as in snapshot_dyn_sql's num_executions)?
Also, is the value "STMT_USR_CPU_TIME_S" etc cumulative?

Thanks.

[dba2adm]

Also on the same topic, is the times such as TOTAL_EXEC_TIME in
SNAPSHOT_DYN_SQL in milli second unit? Where do I find the explantion
for these fields? (I looked at system monitor guide but did not find
much info).

Thanks.

db*****@yahoo.com wrote in message news:<90**************************@posting.google. com>...

The SNAPSHOT_STATEMENT table function gives the CPU used rows read etc
information. How do I know the total number of time the particular
statement was executed (as in snapshot_dyn_sql's num_executions)?
Also, is the value "STMT_USR_CPU_TIME_S" etc cumulative?

Thanks.

[dba2adm]

I found the information on the system monitor giude for my follow-up
question.
But it confuses on the total_exec_time.

Element identifier:
-------------------
total_exec_time

Element type:
-------------
time

Description:
------------
"The total time in seconds and microseconds that was spent executing a
particular statement in the SQL cache."

The field is a bigint and how does it represent both seconds and
microseconds at the same time?

Thanks.

db*****@yahoo.com wrote in message news:<90**************************@posting.google. com>...

The SNAPSHOT_STATEMENT table function gives the CPU used rows read etc
information. How do I know the total number of time the particular
statement was executed (as in snapshot_dyn_sql's num_executions)?
Also, is the value "STMT_USR_CPU_TIME_S" etc cumulative?

Thanks.