Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Location
    Madrid
    Posts
    1

    Unanswered: Queries heavies in informix

    To excuse my Englishman's level, sorry.

    I would like know if there is some way to obtain of the engine of informix all of heavies queries?

    Thank you in advance

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    Hi,

    If you want to monitor running queries use the 'onstat -g ...' utility from the command line. Check out your 'Administrator's Reference' about the utility.
    If you're working in a UNIX environment the script in this post http://www.dbforums.com/showthread.php?t=1616295 might be helpful to determine the heaviest running queries.

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •