Re: selects/inserts/updates/deletes

Posted in 1998

Sujit.Pal@alltel.com — Fri, 17 Apr 1998 14:22:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Kerry How about DATABASE sysmaster; SELECT tabname, SUM(isreads+seqscans) selects, SUM(iswrites) inserts, SUM(isrewrites) updates, SUM(isdeletes) deletes FROM sysptprof WHERE dbsname = your_db_name GROUP BY 1 ORDER BY 1; HTH Sujit Pal ______________________________ Reply Separator _________________________________ Subject: selects/inserts/updates/deletes Author: Kerry Adkins <kadkins@gte.net> at Internet Date: 4/17/98 8:14 AM is there a way with the systables or with the onstats to show how many selects, inserts, updates, deletes have been performed against the engine? i'm running 7.24 on sun solaris 2.5.1. tia. -- _^..^_ _^..^_ =\\ "/= =\\ "/= email - kadkins@gte.net / | | / | | / )| || / )| || _ ( __\\...) _( __\\...) \\ \\ (_) homepage - http://www.geocities.com/~kkitten