RE: What's happening inside the oninit process ?

Posted in 2001

Harold Luse — Tue, 6 Feb 2001 19:15:08 -0600 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C090A3.69044390 Content-Type: text/plain; charset="ISO-8859-1" -----Original Message----- From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk] Sent: Tuesday, February 06, 2001 4:11 PM To: Dirk Moolman Cc: informix-list Subject: Re: What's happening inside the oninit process ? > Dirk Moolman wrote: > > Hallo everyone, I'm not sure how to word this question. > > Regarding the oninit processes running on our machine, is it possible > to see inside the process to see which users are causing the oninit to > do so much work ? > > One thing we do is to run "top" to identify the top processes on the > server. The oninit processes sit right on top - where they should > be, but they don't always do the same amount of work. If we have > badly written code, it will still be the oninit doing all the work, so > how do I trace the problem from the oninit back to the "bad program" / > user ? Well, this may not be exactly what you are looking for, but you can identify which sessions are running high cost SQL statements against the engine. SQL: database sysmaster; select s.username, s.pid unix_pid, s.hostname, s.tty, q.sqx_estcost, q.sqx_estrows, q.sqx_sqlstatement from syssessions s, syssqexplain q where s.sid = q.sqx_sessionid and q.sqx_estcost > 500 order by q.sqx_estcost desc; OUTPUT: username jsmith unix_pid 21506 hostname florida1 tty /dev/pts/3 sqx_estcost 525 sqx_estrows 8 sqx_sqlstatement select * from customer, orders where customer.customer_num = orders.customer_num and ship_date > "01/01/1976" Note on the output: This is only one of several rows that will be returned. They will be in order from highest to lowest estimated cost. I know this is not exactly what you were asking for, but it will give you the UNIX pid for the processes that need to be looked at. HTH Harold Luse, Trainer Informix Software, Inc. ------_=_NextPart_001_01C090A3.69044390 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DISO-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: What's happening inside the oninit process ?</TITLE> </HEAD> <BODY> -----Original Message----- From: Mark D. Stock [<A = HREF=3D"mailto:mdstock@mydas.freeserve.co.uk">mailto:mdstock@mydas.frees= erve.co.uk</A>] Sent: Tuesday, February 06, 2001 4:11 PM To: Dirk Moolman Cc: informix-list Subject: Re: What's happening inside the oninit = process ? > Dirk Moolman wrote: > > Hallo everyone,  I'm not sure how to word = this question. > > Regarding the oninit processes running on our = machine, is it possible > to see inside the process to see which users = are causing the oninit to > do so much work ? > > One thing we do is to run "top" to = identify the top processes on the > server.   The oninit processes sit = right on top - where they should > be, but they don't always do the same amount of = work.  If we have > badly written code, it will still be the oninit = doing all the work, so > how do I trace the problem from the oninit back = to the "bad program" / > user ? Well, this may not be exactly what you are looking = for, but you can identify which sessions are running high cost SQL = statements against the engine. SQL: database sysmaster; select s.username,           s.pid = unix_pid,           = s.hostname,           = s.tty,           = q.sqx_estcost,           = q.sqx_estrows,           = q.sqx_sqlstatement   from syssessions s,            = syssqexplain q   where s.sid =3D q.sqx_sessionid       and q.sqx_estcost = > 500   order by q.sqx_estcost desc; OUTPUT: username          = jsmith unix_pid         &= nbsp; 21506 hostname          = florida1 tty          =      /dev/pts/3 sqx_estcost       = 525 sqx_estrows      8 sqx_sqlstatement  select * from customer, orders   where customer.customer_num =3D = orders.customer_num     and ship_date > = "01/01/1976" Note on the output: This is only one of several rows = that will be returned.  They will be in order from highest to = lowest estimated cost. I know this is not exactly what you were asking for, = but it will give you the UNIX pid for the processes that need to be = looked at. HTH Harold Luse, Trainer Informix Software, Inc. </B

RE: What's happening inside the oninit process ?

Related threads

Your privacy choices