Re: Kill Session question #2 - Thank You !

Thank You, Vladimir. We did not know the SNP details _this_ deeply yet ... now it is most clear.

Jan=)

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> schrieb im Newsbeitrag news:b17sqp$47c$1_at_babylon.agtel.net...
> Just an extra bit of info for your manager:
>
> SNPn processes are actually part of replication subsystem (SNP
> stands for SNaPshot) and are used to deliver table snapshots in
> background to destination systems. Coincidentally, they appeared
> to be useful for scheduling user jobs as well, hence DBMS_JOB
> was made available to public. Certainly, you don't want to mess
> with replication and kill these processes manually - that's why
> PMON restarts them if they die for any reason and that's why
> they are so pervasive in trying to finish their job queue. For
> these reasons, your manager should consider these processes
> as background Oracle processes (which they in fact are) and
> do not attempt to kill them using regular means. SNPn processes
> indeed do impersonate various users during their job execution
> runs, but in no way they are user processes.
>
> References:
> Oracle8i Concepts, Part III, Process Architecture, Background Processes
> Oracle8i Administrator's Guide
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
Received on Wed Jan 29 2003 - 01:44:56 CST