| 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
|  |  |