Re: Column descriptions for x$kxfpdp table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 22 Jun 1998 18:59:03 GMT
Message-ID: <01bd9e0f$a5c2b160$0300a8c0@WORKSTATION>

rem
rem pq_slave_sec.sql
rem
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
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.)
rem

create or replace view v$pq_slave_sec as select

        kxfpdpnum                           	id,
        kxfpdpnam                           	name,
        kxfpdppro                           	process,
        decode(bitand(kxfpdpflg, 16), 
		0, 'BUSY', 
		   'IDLE'
	  )					        	status,
        kxfpdpsta                           	started,
        kxfpdpcln                           	cleaned,
        kxfpdpcin                           	calling_inst,
        kxfpdpcpr                               calling_paddr,
        kxfpdpses                               sessions,
        floor(kxfpdpcit / 100)                  idle_sec_cur,
        floor(kxfpdpcbt / 100)                  busy_sec_cur,
        round(kxfpdpcct / 100,2)                cpu_sec_cur,
        kxfpdpclsnt                             local_sent_cur,
        kxfpdpcrsnt                             remote_sent_cur,
        kxfpdpclrcv                             local_recd_cur,
        kxfpdpcrrcv                             remote_recd_cur,
        floor((kxfpdptit + kxfpdpcit) / 100)    idle_sec_total,
        floor((kxfpdptbt + kxfpdpcbt) / 100)    busy_sec_total,
        round((kxfpdptct + kxfpdpcct) / 100,2)	cpu_sec_total,
        kxfpdptlsnt + kxfpdpclsnt               local_sent_tot,
        kxfpdptrsnt + kxfpdpcrsnt               remote_sent_tot,
        kxfpdptlrcv + kxfpdpclrcv               local_recd_tot,
        kxfpdptrrcv + kxfpdpcrrcv               remote_recd_tot

from x$kxfpdp
where bitand(kxfpdpflg, 8) != 0
;

create public synonym v$pq_slave_sec for sys.v$pq_slave_sec;

Vaughan Mc Carthy <vaughanm_at_medscheme.co.za> wrote in article <6mlf6d$r9p$1_at_hermes.is.co.za>...
> Hi there
>
> Does anybody know what the column descriptions for the x$kxfpdp
table are? I
> want to find out how to link PQ_Slaves, to the Parent process which
spawned
> them.
>
> Regards
> Vaughan Mc Carthy
>
>
>
Received on Mon Jun 22 1998 - 13:59:03 CDT