s_pq_slave_sec.sql

	WARNING:
	--------
		MUST BE RAN AS SYS creates a VIEW and public SYNONYM
	-------------------------------------------------------------------
	Improved view to replace v$pq_slave
rem     This script creates a view similar to the Oracle-supplied view
rem     v$pq_slave only a lot better.
rem	--
rem     It reports:
rem             messages sent and received split into local and remote
rem             times in seconds, and CPU time in hundredths
rem             the process address (v$process.addr) of the slave
rem
rem             the calling instance number
rem             the process (v$process.addr, v$session.paddr) of the caller
rem
rem             An id for the slave
rem             the number of times that process has been started
rem             the number of times that pmon has cleaned up the process
rem             the number of times the process has been used
rem	--
rem     Note:
rem     Some of the stats (e.g. cpu_sec_cur) are not updated in real time.
rem     This means they are always zero.
rem	--
rem     Furthermore, some of the totals are per startup (cpu time), whilst
rem     some are for the full lifetime of the instance (messages sent etc.)