Re: Capturing SQL

Javier Puente wrote: > > You can access this information by making : > 1.- onstat -u To get the session conection id > 2.- With the sessionid you can trace SQL tasks by doing > onstat -g sql sessioid > EX: > onstat -u |grep myuser> > ---Supposing that sessionid is 123 > onstat -g sql 123 -r 1 Correct Javier but I must add the rejoinder - DO NOT DO THIS if you are running on a fast multiple CPU SMP or NUMA machine that is very busy. The query that onstat -g sql executes against shared memory will NEVER complete and the command may never return. Even if you kill the onstat process the thread it launches will live until the engine is shutdown. Not even onmode -z or -Z can stop it! (Similarly do not query sysmaster:syssq1explain for the same reason.) Again this is only a problem for large fast SMP hosts that are busy. Art S. Kagel