Hi,
During peak usage, if I do a top, I see that oninit threads taking 80%
of the cpu. Is there a way I can trace the oninit thread back to a user
and an sql statement if applicable? The oninit thread might not be
running an sql statement, but more times than not I would guess that it
is. Or is there a version of the onstat command that will tell me the
threads(oninit in particular) that a user is currently using?
TIA.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
↪ replying to jsmith112469@my-deja.com
Since oninit will run many Informix threads, it would be difficult to
determine which thread is running on which oninit.
My guess would be that some combination of onstat -u, onstat -g ath, or
onstat -g ses would give you what you need.
John Carlson
Informix DBA
WHSmith USA
jsmith112469@my-deja.com wrote:
>
> Hi,
>
> During peak usage, if I do a top, I see that oninit threads taking 80%
> of the cpu. Is there a way I can trace the oninit thread back to a user
> and an sql statement if applicable? The oninit thread might not be
> running an sql statement, but more times than not I would guess that it
> is. Or is there a version of the onstat command that will tell me the
> threads(oninit in particular) that a user is currently using?
>
> TIA.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.