How to find out how many parallel slaves available in database. 



 select STATUS , count(*) from v$PX_PROCESS group by status ;

STATUS      COUNT(*)
--------- ----------
IN USE            87
AVAILABLE          1

SQL>