Execution Environment:  SQL*PLUS  Access Privileges:
     Create the procedure as user SYS

Usage:
     Create procedure with the following command:  
     sqlplus sys/ @SCRIPTFILE
     
     Than grant execute permission to your user in sqlplus connect as user sys.
     SQL>GRANT EXECUTE ON PQSTAT TO 
     
     The user given execute permissions can execute the script using the following commands:.
     
     SQL>set serverouput on
     SQL>execute sys.PQSTAT( detail, sid); 
           
      
     For an overview of the procedure parameters, refer to the header of the script. 

Instructions:
   Overview of the different calls.
   The command 'set serveroutput on' is mandatory , because otherwise the output would not be 
   displayed.
 
                        set serveroutput on
                        execute pqstat;            -- Gives Summary of all PX sessions 
                                                          and slaves running. 
                        execute pqstat(1);         -- Gives the current SQL for each 
                                                             PX session also. 
                        execute pqstat(0, SID ); 
                                                   -- Gives the summary of PQ slaves 
                                                                  for the given SID 
                        execute pqstat(1, SID ); 
                                                     -- as above plus current SQL . 

PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text 
editors, e-mail packages, and operating systems handle text formatting (spaces, 
tabs, and carriage returns), this script may not be in an executable state
when you first receive it. Check over the script to ensure that errors of
this type are corrected. The script will produce an output file named [output file].
This file can be viewed in a browser or uploaded for support analysis.

This procedure gives you an overview of current PX statements.