Server Load(Yesterday)

Displays the total number of sessions that ran and the total session run duration for yesterday by server by repository. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.


Click on the text to copy the query report to your clipboard.


select "ACTUAL_START",
"SESSION_TIMESTAMP",
"SERVER_NAME",
"REPOSITORY_NAME",
"INSTANCE_ID"
from (SELECT  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  TO_CHAR(SESSION_LOG.ACTUAL_START,'DD-MON-YYYY')                   AS "ACTUAL_START",  SESSION_TASK_INST_RUN.SERVER_NAME,  (COUNT(SESSION_LOG.INSTANCE_ID)) AS INSTANCE_ID,  (SUM(   CASE    WHEN SESSION_LOG.SESSION_TIMESTAMP IS NOT NULL    THEN (SESSION_LOG.SESSION_TIMESTAMP - SESSION_LOG.ACTUAL_START) * 86400  END))                   AS "SESSION_TIMESTAMP"  FROM  REP_LOAD_SESSIONS ALL_SESSIONS,  REP_SESS_LOG SESSION_LOG,  REP_REPOSIT_INFO SESSION_REPOSIT_INFO,  REP_TASK_INST_RUN SESSION_TASK_INST_RUN  WHERE  (ALL_SESSIONS.SESSION_ID = SESSION_LOG.SESSION_ID AND  ALL_SESSIONS.SESSION_VERSION_NUMBER = SESSION_LOG.TASK_VERSION_NUMBER AND  ALL_SESSIONS.SESSION_ID <> SESSION_REPOSIT_INFO.REPOSITORY_ID AND  SESSION_LOG.SESSION_ID = SESSION_TASK_INST_RUN.TASK_ID AND  SESSION_LOG.INSTANCE_ID = SESSION_TASK_INST_RUN.INSTANCE_ID AND  SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TASK_INST_RUN.TASK_VERSION_NUMBER   AND  SESSION_LOG.WORKFLOW_ID = SESSION_TASK_INST_RUN.WORKFLOW_ID AND  SESSION_LOG.WORKFLOW_VERSION_NUMBER = SESSION_TASK_INST_RUN.VERSION_NUMBER   AND  SESSION_LOG.WORKFLOW_RUN_ID = SESSION_TASK_INST_RUN.WORKFLOW_RUN_ID AND  SESSION_TASK_INST_RUN.TASK_TYPE = 68 ) AND  (TO_CHAR(SESSION_LOG.ACTUAL_START,'DD-MON-YYYY') = TO_CHAR(SYSDATE-1, 'DD-MON-YYYY') )   GROUP BY  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  TO_CHAR(SESSION_LOG.ACTUAL_START,'DD-MON-YYYY') ,  SESSION_TASK_INST_RUN.SERVER_NAME) "query"
order by "REPOSITORY_NAME", "ACTUAL_START"

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*