<!-- Title: 10:30:42  Mon Jan  6 2003 -->
<!-- Crewchief: New Day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Mon Jan 6 10:30:49 2003 -->
<pre>I ran the following query to find the top 15 cpu users on cdfrep01 
in the last 4 hours: 
 
 
&gt; sqlplus cdf_reader/reader@cdfrep01 
SQL&gt; COLUMN "User's login name" FORMAT A17; 
SQL&gt; COLUMN "CPU used (sec)" FORMAT 999999; 
SQL&gt; SELECT OSUSER "User's login name", CPU_SEC "CPU used (sec)" 
 2   FROM ( SELECT OSUSER,SUM(CPU_USED) "CPU_SEC" 
 3     FROM LOGINTRACES 
 4     WHERE LOGON_TIME &gt;= SYSDATE - 1/6 
 5     AND CPU_USED IS NOT NULL 
 6     GROUP BY OSUSER 
 7     ORDER BY SUM(CPU_USED) DESC ) 
 8   WHERE ROWNUM &lt;= 15; 
 
 
 
and I obtained the following list: 
 
    User's login name CPU used (sec) 
    ----------------- -------------- 
    ikado                       4388 
    cafuser                     2106 
    thomsone                    1621 
    igv                         1539 
    yoshio                       222 
    bhatti                       114 
    sagara                       103 
    yik                           70 
    mjones                        63 
    aa                            63 
    toolman                       62 
    tatsuya                       56 
    johnzhou                      54 
    peonyisi                      37 
    yliu                          34 
 
It looks as if we could find a way to have Koji Ikado's 
jobs make more efficient use of the database, 
that we could reduce the load on the database. 
</pre>
<!-- Author: wicklund -->


<!-- Date: Mon Jan 6 13:44:32 2003 -->
<pre>Daily monitoring scripts finds the duplicate views in the database. Due to the bug in the script, it was giving wrong results. Script has been fixed.  
 
CDF2_FILE_LUMINOSITIES view is duplicate and owned by CDFPEXO,RATNIKOV,RLC,LENA,DFC_SAM,FILECATALOG,JTSENG on cdfofprd. 
Eric Wicklund will investigate further why this view is duplicate. 
 
CDF2_RUNSECTIONS_VIEW is not duplicate. Old script was pointing out to this one.  
</pre>
<!-- Author: akumar & Eric  -->


<!-- Date: Mon Jan 6 18:50:08 2003 -->
<pre>RunDb schema precut v1_2b has taken  
place:  create table Lost_Events 
 
No rush to add to replication. 
</pre>
<!-- Author: W.Badgett -->

<!-- Date: Mon Jan 6 21:42:50 2003 -->
<pre>
Target Name : b0dau35.fnal.gov 
Target Type : Node 
Node Name : b0dau35.fnal.gov 

CPU Utilization 
The CPU utilization is high.  Current utilization: 77. 
WARNING 
Jan 06 2003 09:42:35 PM 


</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Jan 6 22:28:36 2003 -->
<pre>
Target Name : b0dau35.fnal.gov 
Target Type : Node 
Node Name : b0dau35.fnal.gov 

CPU Utilization 
The CPU utilization is high.  Current utilization: 89. 
CRITICAL 
Jan 06 2003 10:27:38 PM 


</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Mon Jan 6 22:43:07 2003 -->
<pre>
Target Name : b0dau35.fnal.gov 
Target Type : Node 
Node Name : b0dau35.fnal.gov 

CPU Utilization 
Event test "CPU Utilization" is cleared 
CLEARED 
Jan 06 2003 10:42:39 PM 


</pre>
<!-- Author: oem-admin (email) -->