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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ASM processes asm_pz99_+ASM1 and asm_pz98_+ASM1?

Re: ASM processes asm_pz99_+ASM1 and asm_pz98_+ASM1?

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Sun, 21 May 2006 20:06:24 +0200
Message-ID: <c2213f680605211106h4ac0a31cp275d7933cdff3a18@mail.gmail.com>


Thanks Dimitre. You are right:
SQL> select slave_name,status from v$pq_slave;

SLAVE_NAME STATUS
------------ ------------

PZ98         IDLE
PZ99         IDLE

Obviously, ASM also spawns parallel slaves to access GV$ views: SQL> select inst_id, slave_name,status from gv$pq_slave;

   INST_ID SLAVE_NAME STATUS
---------- ------------ ------------

         2 PZ99         BUSY
         1 PZ99         BUSY

I've got confused as I used to see them as ora_Pxxx where x is [0-9].

2006/5/21, Radoulov, Dimitre <cichomitiko_at_gmail.com>:
> > 2006/5/21, Alex Gorbachev <gorbyx_at_gmail.com>:
> >> Anyone knows what are these processes in ASM instance?
>
> Parallel slaves.
>
> select slave_name,status from v$pq_slave;

-- 
Best regards,
Alex Gorbachev

http://oracloid.blogspot.com
--
http://www.freelists.org/webpage/oracle-l
Received on Sun May 21 2006 - 13:06:24 CDT

Original text of this message

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