Filip Sergeys wrote: > > 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".
You missed the fact that every statement sent to the server via dbmcli has to be prefixed with sql_execute / util_execute / db_execute (depending on the version used) > Is it switched on for a single session or for the entire database? For the entire database Elke SAP Labs Berlin > > 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
