Check query execution time in IDS 10 fc9

Hi , We have a IDS version 10 fc9 at our place i have the following questions: 1) How can I check which table on the Informix DB is getting the most used. 2) We also face a issue of high CPU usage on informix, how can we check which query is taking the most time for execution and why is it doing the same? Thanks in advance Regards Shri.

For your second question, the sysmaster:syssessions and sysmaster:syssesprofile tables have information about each session and what resources they are using. For the first, you have to turn on partition profiling in the ONCONFIG file (TBLSPACE_STATS). Once that's done, the sysmaster:sysptprof table will give you statistics by partition (a partition is a table, index, table fragment, or index fragment). Then you just have to define what you mean by "most used". Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Apr 8, 2010 at 7:52 AM, SHRIKANT SABLE < shrikant.sable@hed.ltindia.com> wrote: > Hi , > We have a IDS version 10 fc9 at our place i have the following questions: > 1) How can I check which table on the Informix DB is getting the most used. > 2) We also face a issue of high CPU usage on informix, how can we check > which > query is taking the most time for execution and why is it doing the same? > > Thanks in advance > > Regards > Shri. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e68ef392659acc0483b99f16