<!-- Title: 10:46:34  Fri Sep  2 2005 -->
<!-- Crewchief: New day -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity 
</pre>


<!-- Date: Fri Sep 2 10:52:14 2005 -->
<pre>more activity on cdfonprd then ususal causing 
excessive number of archives............. 
 
current space assignment  
 
/cdf/backup/arch/cdfonprd =  Total 20G 
 
bzora1&gt; ls -rlt | grep 'Aug 28 ' | wc -l 
      88 
bzora1&gt; ls -rlt | grep 'Aug 29 ' | wc -l 
     196 
bzora1&gt; ls -rlt | grep 'Aug 30 ' | wc -l 
     208 
bzora1&gt; ls -rlt | grep 'Aug 31 ' | wc -l 
     181 
bzora1&gt; ls -rlt | grep 'Sep  1 ' | wc -l 
     261 
bzora1&gt; ls -rlt | grep 'Sep  2 ' | wc -l 
      87 
 
/cdf/backup/rman  =   Total  479G  
 
Available:  535G   
 
We keep 6 days of archives !   
</pre>
<!-- Author: nstanfield  -->
<!-- Comment: Fri Sep  2 11;32;30 comment by...nstanfield  -->
<pre>i just reviewed a few strategies with anil & we've decided to not make any changes...

daily archive activity is NOT as HIGH as i thought....

we expect 5.2G of archives a  day & we are a little high for a few days but not enough to take any action 

also,  anil noticed run configurations is where all the updates
are occurring  


=====================================

1)  delete archives reconcile rerun rman
or
2) rerun rman changing it to sysdate-? vs 5
or
3)  
the idea i really like is to take the keeper to
enstore before 4pm (current assigned time)
and then delete the files! 


</pre>

<!-- Comment: Fri Sep  2 13;49;04 comment by...W.Badgett -->
<pre>Is this the RUNDB_PRD.RUNCONFIGURATIONS table?   That's 
very strange -- I don't know of any special work on 
that table today.   Can you tell the db user & os user?</pre>

<!-- Date: Sat Sep 3 00:02:41 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 03 2005 12:02:30 AM 



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


<!-- Date: Sat Sep 3 00:10:46 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 03 2005 12:09:49 AM 



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


<!-- Date: Sat Sep 3 03:07:23 2005 -->
<pre>
Name : cdfonprd_long_transaction 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: cdf-cap-solenoid ICICLE 90 47909 icicle.exe FERMI\SOLENOID2 UPDATE SENSORS SET LAST_MEASURE= 3.8,LAST_ERROR= 0,LAST_STATUS= 'ON',SENST_ID= 1902896 WHERE SENS_ID= 4549 6.54999999999999999999999999999999999984 
CRITICAL 
Sep 03 2005 03:06:32 AM 



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


<!-- Date: Sat Sep 3 03:07:23 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Sep 03 2005 03:06:53 AM 



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


<!-- Date: Sat Sep 3 03:12:27 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Sep 03 2005 03:11:52 AM 



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


<!-- Date: Sun Sep 4 00:03:22 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 04 2005 12:02:30 AM 



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


<!-- Date: Sun Sep 4 00:10:47 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 04 2005 12:09:49 AM 



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


<!-- Date: Sun Sep 4 10:38:36 2005 -->
<pre>
Name : cdfonprd_tablespaces 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace MCS_INDEX is 89.00% full.  11797000.0 KBytes of free space remain. Tablespace CALIB_SML_DATA is 75.06% full.  1060792.0 KBytes of free space remain. Tablespace CALIB_SML_INDEX is 78.45% full.  1539864.0 KBytes of free space remain. 
CRITICAL 
Sep 04 2005 10:37:39 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Tue Sep  6 11;02;49 comment by...ns  -->
<pre>since there is no plan to move mcs off this db to it's own db

i have increased   mcs_index by 4G    and added 1 G to calib_sml_data </pre>
<!-- Date: Sun Sep 4 13:02:38 2005 -->
<pre>
Name : cdfonprd_long_transaction 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: cdf-cap-solenoid ICICLE 46 23738 icicle.exe FERMI\SOLENOID2 INSERT INTO SENSOR_HISTORIES (SENSH_ID, VALUE,SENS_ID,SENST_ID, HISTYP_ID) VALUES (:f1     ,:f2       ,:f3     ,:f4     ,:f5     ) 5.35000000000000000000000000000000000032 
CRITICAL 
Sep 04 2005 01:01:37 PM 



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


<!-- Date: Sun Sep 4 13:02:38 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Sep 04 2005 01:02:17 PM 



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


<!-- Date: Sun Sep 4 13:07:34 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Sep 04 2005 01:07:13 PM 



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


<!-- Date: Mon Sep 5 00:03:27 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 05 2005 12:02:31 AM 



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


<!-- Date: Mon Sep 5 00:10:51 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 05 2005 12:09:49 AM 



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


<!-- Date: Mon Sep 5 02:52:02 2005 -->
<pre>
Name : cdfonprd_long_transaction 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CRITICAL 

User Defined SQL Test 
Current Value: cdf-cap-solenoid ICICLE 75 50900 icicle.exe FERMI\SOLENOID2 INSERT INTO SENSOR_HISTORIES (SENSH_ID, VALUE,SENS_ID,SENST_ID, HISTYP_ID) VALUES (:f1     ,:f2       ,:f3     ,:f4     ,:f5     ) 7.69999999999999999999999999999999999968 
CRITICAL 
Sep 05 2005 02:51:29 AM 



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


<!-- Date: Mon Sep 5 02:53:09 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : WARNING 

User Defined SQL Test 
Current Value: 1 
WARNING 
Sep 05 2005 02:51:48 AM 



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


<!-- Date: Mon Sep 5 04:35:45 2005 -->
<pre>
Name : cdfofpr2_tablespaces 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CRITICAL 

Tablespace Full 
Tablespace RUNDB_DATA is 70.11% full.  8549064.0 KBytes of free space remain. Tablespace OPERATIONAL_IDX_01 is 70.02% full.  2455704.0 KBytes of free space remain. 
CRITICAL 
Sep 05 2005 04:34:11 AM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Tue Sep  6 10;55;35 comment by...ns  -->
<pre>added 4G RUNDB_DATA 
added 2G OPERATIONAL_IDX_01 </pre>
<!-- Date: Mon Sep 5 04:48:10 2005 -->
<pre>
Name : cdfonprd_long_transaction_count 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

User Defined SQL Test 
Current Value: 0 
CLEARED 
Sep 05 2005 04:47:17 AM 



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


<!-- Date: Mon Sep 5 16:03:30 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : WARNING 

Alert 
The following errors are in the ALERT file : ORA-01555 caused by SQL statement below (Query Duration=5846 sec, SCN: 0x056e.d582030c):. 
WARNING 
Sep 05 2005 04:02:30 PM 



</pre>
<!-- Author: oem-admin (email) -->
<!-- Comment: Tue Sep  6 12;02;04 comment by...ns  -->
<pre>
undo_retention    =&gt;&gt;    3600

// *Cause: rollback records needed by a reader for consistent read are
//         overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
//          setting. Otherwise, use larger rollback segments


query failed ....no action for now will monitor 


ORA-01555 caused by SQL statement below (Query Duration=5846 sec, SCN: 0x056e.d582030c):
Mon Sep  5 16:02:03 2005

               select data_files.file_id, DATA_FILES.FILE_NAME, file_size_in_bytes, event_count, crc_value,
 crc_type_id
                 from data_files
                where (data_files.file_id) in (
               select data_files.file_id
                 from data_files, param_values param_values##141, param_types param_types##141, param_categ
ories param_categories##141, data_files_param_values data_files_param_values##141
                where param_values##141.param_type_id = param_types##141.param_type_id
                  and param_values##141.param_value_id = data_files_param_v
</pre>
<!-- Date: Tue Sep 6 00:04:04 2005 -->
<pre>
Name : cdfofpr2_alert_log 
Target Name : cdfofpr2.fnal.gov 
Target Type : Database 
Node Name : fcdfora4.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 06 2005 12:02:31 AM 



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


<!-- Date: Tue Sep 6 00:10:38 2005 -->
<pre>
Name : cdfonprd_alert_log 
Target Name : cdfonprd.fnal.gov 
Target Type : Database 
Node Name : bzora1.fnal.gov 
Status : CLEARED 

Alert 
Event test "Alert" is cleared 
CLEARED 
Sep 06 2005 12:09:49 AM 



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