Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PMON
I never thought to OS trace PMON, I'll take your word for it! Well, every 3
seconds sounds plenty often enough for me anyhow.
I did want to add, in re idle connection issues, this is the big reason I don't like applications that connect into Oracle all as the same username. It's soo much easier to track down a session that is sucking the life out of your server if the usernames are meaningful and individual, so you can call up RSH, say, and ask if he's tryiing to set a new record for Cartesian products or something.
I know, I know, with 3 tier things, etc, it's just a dream. I miss the "old" client-server days at times like that.
RSH.
"Yong Huang" <yong321_at_yahoo.com> wrote in message
news:b3cb12d6.0204211303.12d291e6_at_posting.google.com...
> It's shown as ACTIVE in v$session all the time. At the OS level, it
> wakes up every 3 seconds (run OS process tracing on it; Solaris has
> truss, others strace). Other times it goes to sleep. You can
> explicitly wake it up in svrmgrl oradebug. But since it wakes up so
> frequently, there's rarely such need.
>
> Follow RSH's advice to deal with SNIPED sessions.
>
> Yong Huang
> yong321_at_yahoo.com
>
> i_rahim_at_hotmail.com (Imran Rahim) wrote in message
news:<e7519cfe.0204190844.7f85ae2f_at_posting.google.com>...
> > Can someone please tell me how often PMON runs or how I can determine
> > this?
> > I have SNIPED sessions that I want eradicating and I hear that PMON
> > should be doing this when it wakes up and does its job
Received on Mon Apr 22 2002 - 11:17:42 CDT