Subject | Re: how to retrieve the IDX_READS and the SEQ_READS of a statement or a transaction |
---|---|
Author | hvlad |
Post date | 2010-12-01T10:37:40Z |
> s their a way to retrieve the IDX_READS and the SEQ_READS of a statement or a transaction Without doint a select in the monitoringLook at isc_database_info call. You need isc_info_read_seq_count and isc_info_read_idx_count tags.
Note, this stats is per-database, not per-statement. So you need to obtain stats before and after statement execution and compute a difference. This is exactly how isql (and other tools) works.
Also note that for SS it will show you cumulative stats of all connections at given time slot. For CS\SC it is not a problem as it have this stats per attachment.
Regards,
Vlad