and how do I switch it on? I tried it in dbmcli, in a sql session and I looked in the parameters, but I get unknown command "diagnose". Is it switched on for a single session or for the entire database?
Regards, Filip Sergeys On Wed, 2003-12-17 at 13:47, Becker, Holger wrote: > Filip Sergeys wrote: > > > Is there a way to get an overview of recently executed queries on the > > db? Queries are stored in the catalog cache, only I cannot find the > > view that gives me this information. > > Can queries be linked to statistics? How many times executed, disk > > reads/writes or cash reads/writes, ... > > > Not in general but you could enable "diagnose analyze" feature. > > You could switch it on with the command "diagnose analyze on". > Afterwards the table syscmd_analyze is filled with the text > of the sql command and the table sysdata_analyze with some > information about resource consumption of the statements. > > HTH. > > Kind regards, > Holger > SAP Labs Berlin -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * 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]
