Wait Statistics

Dies ist eine mehrteilige Nachricht im MIME-Format. --------------D0A6CF4F56568525466558CB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, i have some difficulties in interpreting the output of the following SQL-statement: select reason[1,20], trunc (sum(cumtime)) wartezeit from sysseswts where reason != "condition" group by reason having sum(cumtime) > 0 order by 2 desc I cannot understand the meaning of some of the reasons: mt yield mt yield 0 mt yield n buffer (if "buffer" is in the first line of output of the above statement, what must we do for better performance? More buffers in ONCONFIG?) Thanks in advance Christian Winterhager --------------D0A6CF4F56568525466558CB Content-Type: text/x-vcard; charset=us-ascii; name="christianw.vcf" Content-Transfer-Encoding: 7bit Content-Description: Visitenkarte f'r Christian Winterhager Content-Disposition: attachment; filename="christianw.vcf" begin:vcard n:Winterhager;Christian tel;cell:0171/5804126 tel;work:02223/905970 x-mozilla-html:FALSE adr:;;K'nigswintererstr. 303b;K'nigswinter;NW;53639; version:2.1 email;internet:christianw@tronet.de title:Diplom-Mathematiker fn:Christian Winterhager end:vcard --------------D0A6CF4F56568525466558CB--