Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ora_psp0_SID process in 10g R2: what is it ?

Re: ora_psp0_SID process in 10g R2: what is it ?

From: Joel Garry <joel-garry_at_home.com>
Date: 20 Jan 2006 17:09:09 -0800
Message-ID: <1137805749.902567.104110@o13g2000cwo.googlegroups.com>

Spendius wrote:
> I've noticed a PSPn process: does someone know its purpose ?
> (10.2.0.1 on SunOS 9)
>
> Thanks.

http://download-west.oracle.com/docs/cd/B19306_01/win.102/b15688/architec.htm search for process spawn

select * from v$bgprocess where paddr <> '00'; works for me on XE on W2K

Odd they wouldn't doc it on unix.

jg

--
@home.com is bogus.
Soooo glad they would never hire me:
http://www.signonsandiego.com/uniontrib/20060120/news_1n20sony.html
Received on Fri Jan 20 2006 - 19:09:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US