Re: processes without sessions? (was: IO statistics of the ARCH process)
Date: Tue, 20 Mar 2012 18:36:46 +0000
(resending to oracle-l)
The Oradism (ora_dism_SID process) is actually a fake background process which doesn't have neither a process state object (v$process) nor a session state object (v$session). It actually uses $ORACLE_HOME/bin/oradism executable (not the $OH/bin/oracle one and the process just renames itself to look similar to other background processes).
I remember, that the other process without a session was VKTM, but now on 11.2 I see it has a session too... might have been some bug (or maybe I saw it in my dreams or something :)
-- *Tanel Poder* Enkitec Europe +372 56 956 181 http://www.enkitec.com/ Expert Oracle Exadata book: http://www.apress.com/9781430233923 On Sat, Mar 17, 2012 at 5:18 PM, Tanel Poder <tanel_at_poderc.com> wrote:Received on Tue Mar 20 2012 - 13:36:46 CDT
> Hi Martin,
> VKTM is one and there's probably more special purpose ones by now...
> Sent from mobile
> On 17 Mar 2012, at 08:51, Martin Berger <martin.a.berger_at_gmail.com> wrote:
> > Tanel,
> > one more good reason to have snapper with me all the time.
> > But here you made me curious with just one word: 'most'
> > Do you know any background process without a session? It sounds scary!
> > Shared Servers (MTS) comes to my mind, I just don't know what they do
> > when no clients are connected?
> > thanks for any advise
> > Martin
> > On Sat, Mar 17, 2012 at 00:01, Tanel Poder <tanel_at_tanelpoder.com> wrote:
> >> Snapper can show it as arch processes have sessions (and populate
> >> V$SESSION) like most other background processes...