Hello, For troubleshooting reasons I like to find the link between a system process id, the corresponding SQL statement, the user executing it and the system impact of the query (ioread,iowrites,...) If I understand the documentation well: the sessions and commandstatistics system tables can provide me this information. However the sessions table is not in my system en the commandstatistics table is always empty. I tried with different users logged in (normal user, dba,sysdba). In the dbmgui I get results when using the sessions button (does that come from the sessions table?).
DB: 7.5.00.14 OS: Suse 9.1 Second question: how long is information stored in these tables? Since instance startup? I like to get an overview of all executed query during one day of users testing an application. Regards, Filip -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
