Peoplesoft Process monitor view

View to analyze the Process in the process monitor in Peoplesoft.

 

This view gives clear information about the process with time taken for the execution in hours minutes and seconds.

 

SELECT PRCSINSTANCE

, PRCSNAME

, OPRID

, RUNCNTLID

, SERVERNAMERUN

, RQSTDTTM

, RUNDTTM

, BEGINDTTM

, ENDDTTM

, floor(TO_CHAR((enddttm-begindttm)*24*60)) AS MINUTES

, lpad(FLOOR(((TO_CHAR((enddttm-begindttm)*24*60))-floor(TO_CHAR((enddttm-begindttm)*24*60)))*60)

,2

,0) AS SECONDS

, decode (FLOOR(TO_CHAR((enddttm-begindttm)*24*60))||':'||lpad(FLOOR(((TO_CHAR((enddttm-begindttm)*24*60))-floor(TO_CHAR((enddttm-begindttm)*24*60)))*60)

,2

,0)

, ':'

,' '

,FLOOR(TO_CHAR((enddttm-begindttm)*24*60))||':'||lpad(FLOOR(((TO_CHAR((enddttm-begindttm)*24*60))-floor(TO_CHAR((enddttm-begindttm)*24*60)))*60)

,2

,0)) AS MINSEC

, RUNSTATUSDESCR

FROM PS_PMN_PRCSLIST

ORDER BY RUNDTTM DESC

 

Posted by

Ganesh A.M

 

 

2 comments:

  1. KAB said,
    This comment has been removed by the author.

    on February 19, 2009 at 1:32 PM  


  2. KAB said,

    Hi,
    I am trying to create a query which subtracts begindttm from enddttm. I created an expression, but so far I have been unsuccessful. I even used your query in the query tool, since I donot have an access to the Oracle database directly.

    I would appreciate your help in this matter.

    Thanks & Regards,
    Ketan
    ketanbenegal@yahoo.com

    on February 19, 2009 at 1:35 PM