Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ASM processes asm_pz99_+ASM1 and asm_pz98_+ASM1?
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-lReceived on Sun May 21 2006 - 13:06:24 CDT
![]() |
![]() |