<!-- Title: 10:48:48  Mon Mar 18 2002 -->
<!-- Crewchief: New Day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>

<!-- Date: Mon Mar 18 11:05:44 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Tablespace Full
Event test "Tablespace Full" is cleared
CLEARED
Mar 18 2002 11:04:37 AM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Mar 19 07:26:57 2002 -->
<pre>
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Mar 19 07:28:39 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Node UpDown
Event test "Node UpDown" is cleared
CLEARED
Mar 19 2002 08:28:03 AM
Database UpDown
Event test "Database UpDown" is cleared
CLEARED
Feb 19 2002 11:32:27 AM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Mar 19 07:28:39 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov
Target Type : Database
Node Name : fcdfora1.fnal.gov

Node UpDown
Event test "Node UpDown" is cleared
CLEARED
Mar 19 2002 08:28:03 AM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Mar 19 07:57:48 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Node UpDown
 VNI-4044 : Cannot contact agent. Node may be down, or the network may be down or slow.
NODE UNREACHABLE
Mar 19 2002 08:55:48 AM
Database UpDown
Event test "Database UpDown" is cleared
CLEARED
Feb 19 2002 11:32:27 AM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Mar 19 07:57:48 2002 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Node UpDown
Event test "Node UpDown" is cleared
CLEARED
Mar 19 2002 08:57:03 AM
Database UpDown
Event test "Database UpDown" is cleared
CLEARED
Feb 19 2002 11:32:27 AM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Mar 19 15:32:00 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov
Target Type : Database
Node Name : fcdfora1.fnal.gov

Process Limit
The process usage is reaching its limit.  Current value: 160, limit: 200.
WARNING
Mar 19 2002 03:30:59 PM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Tue Mar 19 16:12:49 2002 -->
<pre>
Target Name : cdfofprd.fnal.gov
Target Type : Database
Node Name : fcdfora1.fnal.gov

Process Limit
Event test "Process Limit" is cleared
CLEARED
Mar 19 2002 04:11:54 PM
</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Tue Mar 19 17:08:32 2002 -->
<pre>Randy Herber's browser was doing a sequence of  
very time consuming queries, apparently requested by  
some random user.   The  query is listed below.   Someone  
kept renewing the question, several times, starting around  
11:00 a.m. until now...   But who?!?!? 
 
1012       oracle               oracle               SELECT CVS.CREATE_DATE, CVS.PROCESS_NAME, CVS.JOBSET JOBSET, (SE 
           oracle                                    LECT COUNT(DISTINCT PROCESS_RUN) FROM USED_SETS WHERE USED_SETS. 
           oracle                                    JOBSET = CVS.JOBSET) NDATARUNS, (SELECT COUNT(DISTINCT C.CALIB_R 
           oracle                                    UN) FROM SET_RUN_MAPS S, CALIBRUNLISTS C WHERE S.JOBSET = CVS.JO 
           oracle                                    BSET AND S.CID = C.CID) NCALIBRUNS, CRL.CALIB_TABLE, CRL.CALIB_R 
           oracle                                    UN, CRL.CALIB_VERSION, CRL.DATA_STATUS, CRL.ALGORITHM, CRL.CID F 
           oracle                                    ROM CALIBRUNLISTS CRL, SET_RUN_MAPS CSRM, VALID_SETS CVS  WHERE 
           oracle                                    CRL.CID(+) = CSRM.CID AND CSRM.JOBSET(+) = CVS.JOBSET AND CVS.PR 
           oracle                                    OCESS_NAME = 'L3_PHYSICS_CAL' ORDER BY JOBSET DESC, PROCESS_NAME 
           oracle                                     DESC 
</pre>
<!-- Author: W.Badgett -->


<!-- Date: Thu Mar 21 11:31:11 2002 -->
<pre>As mentioned in the Database meeting yesterday, the  
run database cut v1_0y has gone in, adding  
tables SILICON_RUN_STATUS and LEVEL3_STATUS 
 
Also added to replication, including indices, synonyms. 
 
</pre>
<!-- Author: W.Badgett -->


<!-- Date: Thu Mar 21 17:31:07 2002 -->
<pre>I am planning on run a job populating cdfofdev with huge amount  
of data. This is DataFileDB application. This should take 2-3 
days.  
 
If no one objects I will start it today evening  </pre>
<!-- Author: Dmitry Litvintsev -->
<!-- Comment: Fri Mar 22 08;32;08 comment by...ns -->
<pre>OK.  Have changed the archive to save 2 days worth was 4.
</pre>

<!-- Comment: Fri Mar 22 08;35;21 comment by...ns -->
<pre>FILECATALOG2_DATA       9,437,184,000    6,343,884,800    3,093,299,200        68
FILECATALOG2_INDEX      6,493,798,400    3,872,358,400    2,621,440,000        60</pre>