Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Most frequent SQL statements

Status
Not open for further replies.

schu

MIS
Jun 21, 2001
188
HK
How do I get a list of the most frequently used statements running on an Informix Instance, and also the Average time it runs?

I know Oracle has a similar feature, But I do not know if Informix Does. If not is there a way through UNIX to get similar information?

Thanks
 
informix can calculate resources spent on per-query basis (EXPLAIN) and show details on every statement using onaudit tool or i-spy product, onstat is a simplest statistics display tool
 
Capture in a file

dbaccess sysmaster <<EOF
set isolation to dirty read;
select * from syssqexplain;
EOF

look for statement filed.
 
Capture in a file

dbaccess sysmaster <<EOF
set isolation to dirty read;
select * from syssqexplain;
EOF

look for statement filed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top