<!-- Title: 07:46:15  Thu Apr 12 2001 -->
<!-- Crewchief: nstanfield -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>


<!-- Date: Thu Apr 12 11:41:40 2001 -->
<pre>Spoke to Jeff may require a reboot if a refresh does not 
work!   He will let us know. 
--------- 
 
Your "cron" job on b0dau36 
. bin/bootstrap_toolman_cron; every1min 
 
produced the following output: 
 
ERROR: Error in call to fopen: Stale NFS file handle 
ERROR: Unable to open file /cdf/code-IRIX-6.5/products/upsii_database/.upsfiles/dbconfig. 
WARNING:  '/cdf/code-IRIX-6.5/products/upsii_database' is not a directory 
 
---------- 
 
also see the error  
 
b0dau30:/cdf/code-common 
                     17775472 10798196 6977276    61%    /var/cdf/code-common 
df: cannot statvfs /var/cdf/code-IRIX-6.5: Stale NFS file handle 
b0dau36> </pre>
<!-- Author: nstanfield -->


<!-- Date: Thu Apr 12 14:28:06 2001 -->
<pre>Dropping calibration schema in cdfonint.</pre>
<!-- Author: nstanfield -->


<!-- Date: Thu Apr 12 15:29:58 2001 -->
<pre>Machine:   b0dau36 
Instance:  cdfonint   
 
GOAL:  Refresh calib_int from calib_prd & run simulation  
 
1.	Export of calib_int  - 6 min 
	Export calib_prd on dau36 so I don't have to ftp... set TWO_TASK 
	20 some minutes  files located=/backup0/export/cdfonint/xxx.dmp 
 
2.	Check Space  
 
Information for: cdfonprd 
 
Tablespace Name       Tablespace Size  Used (in bytes)  Free (in bytes) Pct. Used 
-------------------- ---------------- ---------------- ---------------- --------- 
CALIB_DATA             23,070,334,976    3,003,482,112   20,066,852,864        14 
CALIB_INDEX            13,631,488,000    1,389,903,872   12,241,584,128        11 
 
 
Information for: cdfonint 
 
Tablespace Name       Tablespace Size  Used (in bytes)  Free (in bytes) Pct. Used 
-------------------- ---------------- ---------------- ---------------- --------- 
CALIB_DATA              2,075,721,728    1,183,916,032      891,805,696        58 
CALIB_INDEX               991,232,000      225,746,944      765,485,056        23 
 
--> We moved the existing calib datafiles to dbs19 & dbs20  
sysadmin gave us additional disk and we consolidated all datafiles. 
 
step 1:  svrmgrl prompt take the tablespace offline 
 
alter tablespace calib_data offline; 
alter tablespace calib_index offline; 
 
step 2:   o/s cmd to move file 
 
mv /dbs10_i/oradata/cdfonint/calib_data_01.dbf   
 
/dbs19_i/oradata/cdfonint/calib_data_01.dbf 
 
mv /dbs10_i/oradata/cdfonint/calib_data_02.dbf   
 
/dbs19_i/oradata/cdfonint/calib_data_02.dbf 
 
mv /dbs11_i/oradata/cdfonint/calib_index_01.dbf  
 
/dbs20_i/oradata/cdfonint/calib_index_01.dbf 
 
step 3:   svrmgrl prompt alter tablespace to rename the files  
 
alter tablespace calib_data rename datafile '/dbs10_i/oradata/cdfonint/calib_data_01.dbf'  
 
to '/dbs19_i/oradata/cdfonint/calib_data_01.dbf'; 
 
alter tablespace calib_data rename datafile '/dbs10_i/oradata/cdfonint/calib_data_02.dbf'  
 
to '/dbs19_i/oradata/cdfonint/calib_data_02.dbf'; 
 
alter tablespace calib_index rename datafile  
 
'/dbs11_i/oradata/cdfonint/calib_index_01.dbf' to  
 
'/dbs20_i/oradata/cdfonint/calib_index_01.dbf'; 
 
step 4:   bring the tablespace back online  
 
alter tablespace calib_data online; 
alter tablespace calib_index online; 
 
..and then add new datafiles 
 
ALTER TABLESPACE CALIB_DATA ADD DATAFILE '/dbs19_i/oradata/cdfonint/calib_data_03.dbf'  
 
SIZE  1900M; 
 
ALTER TABLESPACE CALIB_INDEX ADD DATAFILE '/dbs20_i/oradata/cdfonint/calib_index_02.dbf'  
 
SIZE  900M; 
 
Checking for initial extents larger then 2G due to datafile limit. N/A, 
all are less.    
 
SQL>  
  1  select SEGMENT_NAME, BYTES/1024/1024 
  2  from dba_segments 
  3  where owner = 'CALIB_PRD' 
  4   and  segment_type = 'TABLE' 
  5* order by 2 
SQL>  
 
PHAPED                         18.83 
CHAPED                         19.34 
CLACQIE                        19.34 
PEMPED                         20.35 
CEMPED                         23.40 
SIXCHP                         23.40 
PPRQIE                         38.13 
 
SEGMENT_NAME         BYTES/1024/1024 
-------------------- --------------- 
CESQIE                         63.52 
COTCTT                         90.94 
COTCHANT0                     130.30 
WHAQIE                        243.16 
PESQIE                        254.42 
PHAQIE                        394.41 
PEMQIE                        428.94 
CHAQIE                        448.76 
CEMQIE                        550.27 
 
3.   /usr/people/oracle /drop*  
 
drop tables, syns, sequences, views, function, pkbody, pkg, proc 
 
 
4.  script for import is located  
 
$ORACLE_BASE/admin/cdfonint/export/impparameters_calib.dat change 
the log and the file  
 
5.  public syns need to be run - need ddl will get from John vs Jack 
 
---> Ready for simulation </pre>
<!-- Author: nstanfield/akumar -->


<!-- Date: Fri Apr 13 15:24:44 2001 -->
<html> 
<head>  
<title> The DB Simulation: work with CALIB_INT </title> 
</head> 
<body> 
 
<h3 align=center>The DB Simulation: work with <code>CALIB_INT.</code></h3> 
 
<p align=left>  
<h4> 1st Trial.</h4> 
At 5:30pm started exercises with simulation running <em> CalibDBWriter</em> 
<br>  
Namely: 
<br> 
Started with <i>Run## 800000</i>: 
<br> 
<code>CalibDBWriter -dbtype OTL -dblogin calib_int/calib@cdfonint -days 8 -run 800000 -period 24 -report_rate 8 >& simul_8days_1.log & </code> 
<br> 
<br> 
The fragment of the logfile <em>simul_8days_1.log</em> is here: 
<br> 
<br> 
<code> 
Writing 105 calibrations 
Error 2291 : ORA-02291: integrity constraint (CALIB_INT.CL_CAP_FK) violated - parent key not found 
sql: INSERT INTO CALIBRUNLISTS (TSID,CID,CALIB_RUN,CALIB_TABLE,CALIB_VERSION,PERIOD,DATA_STATUS) VALUES ( :f1     , :f2     , :f3     ,:f4          ,:f5     ,:f6     ,:f7           ) 
FDAQieOTL put runlist: Error =  
OCI Error 
put to FDAQie failed: key=FDAQIE:800003 rc=SQL function call error 
Error 2291 : ORA-02291: integrity constraint (CALIB_INT.CL_CAP_FK) violated - parent key not found 
sql: INSERT INTO CALIBRUNLISTS (TSID,CID,CALIB_RUN,CALIB_TABLE,CALIB_VERSION,PERIOD,DATA_STATUS) VALUES ( :f1     , :f2     , :f3     ,:f4          ,:f5     ,:f6     ,:f7           ) 
FDAPedOTL put runlist: Error =  
OCI Error 
put to FDAPed failed: key=FDAPED:800003 rc=SQL function call error 
</code> 
<br> 
<br> 
So as one can see here there are some new tables which do not  
yet exist in <em>CALIB_PROPERTIES</em> table (parent PK) while tried being inserted  
into  <em>CALIBRUNLISTS</em> admin. table (child FK). We realized that by looking  
to <em>DBA_CONSTRAINTS</em> and <em>DBA_CONS_COLUMNS</em> dictionaries. 
<br> 
The <em>DBCalibWriter</em> has crashed with core dumped  
after some amount of rows written to <em>CALIB_INT</em> 
schema. See the <em>.log</em> output below: 
<br> 
<br> 
<code> 
Time Report, hour = 16 
SIXChp 722432 12 writes=1 cpu(u=208.57,s=0) clk(u=701.053,s=0) 
SVXFibPed 5644 12 writes=1 cpu(u=11.22,s=0) clk(u=16.8544,s=0) 
CEMQie 30720 12 writes=1 cpu(u=8.76,s=0) clk(u=29.2635,s=0) 
CEMQie2 960 12 writes=1 cpu(u=2.78,s=0) clk(u=3.81738,s=0) 
CHAQie 30720 12 writes=1 cpu(u=7.44,s=0) clk(u=28.5652,s=0) 
CHAQie2 960 12 writes=1 cpu(u=2.91,s=0) clk(u=3.93876,s=0) 
CEMPed 960 12 writes=1 cpu(u=0.32,s=0) clk(u=1.00041,s=0) 
CHAPed 960 12 writes=1 cpu(u=0.39,s=0) clk(u=1.04206,s=0) 
WHAQie 18432 12 writes=1 cpu(u=5.27,s=0) clk(u=17.7319,s=0) 
WHAQie2 960 12 writes=1 cpu(u=2.96,s=0) clk(u=3.98148,s=0) 
WHAPed 576 12 writes=1 cpu(u=0.17,s=0) clk(u=0.653374,s=0) 
PEMQie 30720 12 writes=1 cpu(u=9.16,s=0) clk(u=30.2687,s=0) 
PEMQie2 960 12 writes=1 cpu(u=2.83,s=0) clk(u=3.82203,s=0) 
PHAQie 30720 12 writes=1 cpu(u=8.98,s=0) clk(u=29.3092,s=0) 
PHAQie2 960 12 writes=1 cpu(u=2.86,s=0) clk(u=3.91474,s=0) 
PEMPed 960 12 writes=1 cpu(u=0.38,s=0) clk(u=1.15641,s=0) 
PHAPed 960 12 writes=1 cpu(u=0.3,s=0) clk(u=1.00625,s=0) 
COTTimeDistance1 10 2 writes=8 cpu(u=0.015,s=0.00944911) clk(u=0.0986412,s=0.0415837) 
PESLaser 6400 8 writes=2 cpu(u=1.735,s=0.015) clk(u=5.79202,s=0.113335) 
CESQie 294912 12 writes=1 cpu(u=83.79,s=0) clk(u=280.265,s=0) 
CESQie2 9216 12 writes=1 cpu(u=27.02,s=0) clk(u=36.5933,s=0) 
CESPed 9216 12 writes=1 cpu(u=3.49,s=0) clk(u=9.64853,s=0) 
CCRQie 15360 12 writes=1 cpu(u=4.47,s=0) clk(u=14.1412,s=0) 
CCRQie2 480 12 writes=1 cpu(u=1.45,s=0) clk(u=1.99903,s=0) 
CCRPed 480 12 writes=1 cpu(u=0.19,s=0) clk(u=0.530999,s=0) 
CPRQie 49152 12 writes=1 cpu(u=14.6,s=0) clk(u=46.5676,s=0) 
CPRQie2 1536 12 writes=1 cpu(u=4.61,s=0) clk(u=6.20538,s=0) 
CPRPed 1536 12 writes=1 cpu(u=0.55,s=0) clk(u=1.54287,s=0) 
PESQie 212992 12 writes=1 cpu(u=61.34,s=0) clk(u=201.454,s=0) 
PESQie2 6656 8 writes=2 cpu(u=20.605,s=0.035) clk(u=27.1079,s=0.076057) 
PESPed 6656 12 writes=1 cpu(u=2.27,s=0) clk(u=6.52031,s=0) 
PPRQie 3200 12 writes=1 cpu(u=0.79,s=0) clk(u=2.90952,s=0) 
PPRQie2 100 12 writes=1 cpu(u=0.33,s=0) clk(u=0.534342,s=0) 
PPRPed 100 12 writes=1 cpu(u=0.06,s=0) clk(u=0.163935,s=0) 
Error 2291 : ORA-02291: integrity constraint (CALIB_INT.VS_CUSS_FK) violated - parent key not found 
sql: INSERT INTO VALID_SETS (TSID, LAST_RUN, JOBSET, PROCESS_NAME, FIRST_RUN) VALUES (-23877,-1,6077,'TESTPROC',800011) 
OCI Error 
Failed to do query for validset put: SQL function call error 
</code> 
<br> 
<br> 
So apparently we <strong><i>did not get many writes to tables</i></strong> before job crashed - 
we succeeded to simulate just 16 hours with mostly <strong><i>single</i></strong>  
writes to most of the tables. 
</p> 
<p> 
<h4>2nd Trial.</h4> 
Started with <i>Run## 870000</i>: 
<br> 
<code>CalibDBWriter -dbtype OTL -dblogin calib_int/calib@cdfonint -days 8 -run 800000 -period 24 -report_rate 1 >& simul_8days_2.log & </code> 
<br> 
<br> 
Againn we had here the same integrity problem... 
<code> 
Writing 105 calibrations 
Time Report, hour = 1 
Time Report, hour = 2 
COTTimeDistance1 10 2 writes=1 cpu(u=0.08,s=0) clk(u=0.352901,s=0) 
Time Report, hour = 3 
COTTimeDistance1 10 2 writes=1 cpu(u=0.08,s=0) clk(u=0.352901,s=0) 
Time Report, hour = 4 
COTTimeDistance1 10 2 writes=2 cpu(u=0.04,s=0.04) clk(u=0.204014,s=0.148887) 
Time Report, hour = 5 
COTTimeDistance1 10 2 writes=2 cpu(u=0.04,s=0.04) clk(u=0.204014,s=0.148887) 
Time Report, hour = 6 
COTTimeDistance1 10 2 writes=3 cpu(u=0.0333333,s=0.024037) clk(u=0.155335,s=0.0987864) 
Time Report, hour = 7 
COTTimeDistance1 10 2 writes=3 cpu(u=0.0333333,s=0.024037) clk(u=0.155335,s=0.0987864) 
Error 2291 : ORA-02291: integrity constraint (CALIB_INT.CL_CAP_FK) violated - parent key not found 
sql: INSERT INTO CALIBRUNLISTS (TSID,CID,CALIB_RUN,CALIB_TABLE,CALIB_VERSION,PERIOD,DATA_STATUS) VALUES ( :f1     , :f2     , :f3     ,:f4          ,:f5     ,:f6     ,:f7           ) 
FDAQieOTL put runlist: Error =  
OCI Error 
put to FDAQie failed: key=FDAQIE:870003 rc=SQL function call error 
</code> 
<br> 
Job <strong>crashed again after 23 hours ....</strong>  
<br> 
<code> 
Time Report, hour = 23 
SIXChp 722432 12 writes=1 cpu(u=173.53,s=0) clk(u=655.174,s=0) 
SVXFibPed 5644 12 writes=1 cpu(u=11.93,s=0) clk(u=17.4874,s=0) 
CEMQie 30720 12 writes=1 cpu(u=9.74,s=0) clk(u=31.937,s=0) 
CEMQie2 960 12 writes=1 cpu(u=2.9,s=0) clk(u=3.95417,s=0) 
CHAQie 30720 12 writes=1 cpu(u=9.2,s=0) clk(u=29.1857,s=0) 
CHAQie2 960 12 writes=1 cpu(u=2.87,s=0) clk(u=4.11811,s=0) 
CEMPed 960 12 writes=1 cpu(u=0.25,s=0) clk(u=1.05345,s=0) 
CHAPed 960 12 writes=1 cpu(u=0.27,s=0) clk(u=1.13718,s=0) 
WHAQie 18432 12 writes=1 cpu(u=5.92,s=0) clk(u=18.2951,s=0) 
WHAQie2 960 12 writes=1 cpu(u=2.9,s=0) clk(u=4.13987,s=0) 
WHAPed 576 12 writes=1 cpu(u=0.21,s=0) clk(u=0.643297,s=0) 
PEMQie 30720 12 writes=1 cpu(u=10.15,s=0) clk(u=30.7307,s=0) 
PEMQie2 960 12 writes=1 cpu(u=2.99,s=0) clk(u=4.11611,s=0) 
PHAQie 30720 12 writes=1 cpu(u=9.36,s=0) clk(u=29.5919,s=0) 
PHAQie2 960 12 writes=1 cpu(u=2.98,s=0) clk(u=4.11863,s=0) 
PEMPed 960 12 writes=1 cpu(u=0.41,s=0) clk(u=1.12298,s=0) 
PHAPed 960 12 writes=1 cpu(u=0.38,s=0) clk(u=1.0964,s=0) 
COTTimeDistance1 10 2 writes=11 cpu(u=0.0154545,s=0.00665564) clk(u=0.101632,s=0.0274839) 
PESLaser 6400 8 writes=2 cpu(u=1.59,s=0.03) clk(u=5.69977,s=0.0844405) 
CESQie 294912 12 writes=1 cpu(u=87.92,s=0) clk(u=287.676,s=0) 
CESQie2 9216 12 writes=1 cpu(u=27.62,s=0) clk(u=37.0635,s=0) 
CESPed 9216 12 writes=1 cpu(u=3.82,s=0) clk(u=9.74148,s=0) 
CCRQie 15360 12 writes=1 cpu(u=4.46,s=0) clk(u=14.8858,s=0) 
CCRQie2 480 12 writes=1 cpu(u=1.48,s=0) clk(u=2.30591,s=0) 
CCRPed 480 12 writes=1 cpu(u=0.19,s=0) clk(u=0.592225,s=0) 
CPRQie 49152 12 writes=1 cpu(u=15.43,s=0) clk(u=48.6838,s=0) 
CPRQie2 1536 12 writes=1 cpu(u=4.72,s=0) clk(u=6.37182,s=0) 
CPRPed 1536 12 writes=1 cpu(u=0.59,s=0) clk(u=1.71675,s=0) 
PESQie 212992 12 writes=1 cpu(u=61.6,s=0) clk(u=225.234,s=0) 
PESQie2 6656 8 writes=2 cpu(u=20.81,s=0.31) clk(u=27.6955,s=0.1889) 
PESPed 6656 12 writes=1 cpu(u=2.26,s=0) clk(u=6.92029,s=0) 
PPRQie 3200 12 writes=1 cpu(u=1.09,s=0) clk(u=3.46433,s=0) 
PPRQie2 100 12 writes=1 cpu(u=0.31,s=0) clk(u=0.593983,s=0) 
PPRPed 100 12 writes=1 cpu(u=0.03,s=0) clk(u=0.194838,s=0) 
Error 2291 : ORA-02291: integrity constraint (CALIB_INT.VS_CUSS_FK) violated - parent key not found 
sql: INSERT INTO VALID_SETS (TSID, LAST_RUN, JOBSET, PROCESS_NAME, FIRST_RUN) VALUES (-24097,-1,6081,'TESTPROC',870011) 
OCI Error 
Failed to do query for validset put: SQL function call error 
</code> 
<br> 
<strong>Core dumped ...</strong> 
</p> 
<p> 
<h4>3rd Trial.</h4> 
Started with <i>Run## 880000</i>: 
<br> 
<code>CalibDBWriter -dbtype OTL -dblogin calib_int/calib@cdfonint -days 8 -run 800000 -period 24 -report_rate 1 >& simul_8days_3.log & </code> 
<br> 
<br> 
<strong>Core dumped ...</strong> 
</p> 
<p> 
<h4>3rd Trial.</h4> 
Started with <i>Run## 880000</i>: 
<br> 
<code>CalibDBWriter -dbtype OTL -dblogin calib_int/calib@cdfonint -days 8 -run 800000 -period 24 -report_rate 1 >& simul_8days_3.log & </code> 
<br> 
<br> 
<strong>Core dumped ...</strong> 
<br> 
</p> 
<p> 
<h4>4rd Trial.</h4> 
Started with <i>Run## 890000</i>: 
<br> 
<code>CalibDBWriter -dbtype OTL -dblogin calib_int/calib@cdfonint -days 8 -run 800000 -period 24 -report_rate 1 >& simul_8days_4.log & </code> 
<br> 
<br> 
<strong>Core dumped ...</strong> 
<br> 
</p> 
</body> 
</html> 
 
  
<!-- Author: Anil and Igor. -->


<!-- Date: Fri Apr 13 21:03:38 2001 -->
<html> 
<head>  
<title> The DB Simulation: work with CALIB_INT </title> 
</head> 
<body> 
 
<h4 align=center>The DB Simulation: work with <code>CALIB_INT.</code><br> 
(continuing yesterday exercises ...) 
</h3> 
 
<p align=left>  
<h5> 1st Trial.</h5> 
At 6:50pm started exercises with simulation running <em> CalibDBWriter</em><br>  
Namely:<br> 
Started with <i>Run## 890000</i>:<br> 
Continuing work <b><i>started yesterday together with Anil ...</i></b> <br> 
<pre><font color=blue> 
CalibDBWriter -dbtype OTL -dblogin calib_int/calib@cdfonint -days 9 -run 890000 
             -period 24 -report_rate 8 >& simrun_8days_5.log &  
</font> 
</pre> 
<br> 
<br> 
<p>  
 
<h4>The listing of the log output is shown below:</h4> <br> 
<b><i>Simulation ended successfully at 7:59pm on Apr 13 ...</i></b> <br><br> 
<pre> 
Period at hour 24 ended, run = 890011 
Error 2291 : ORA-02291: integrity constraint (CALIB_INT.CL_CAP_FK) violated - parent key not found 
sql: INSERT INTO CALIBRUNLISTS (TSID,CID,CALIB_RUN,CALIB_TABLE,CALIB_VERSION,PERIOD,DATA_STATUS) VALUES ( :f1     , :f2     , :f3     ,:f4          ,:f5     ,:f6     ,:f7           ) 
SiStripDHOTL put runlist: Error =  
OCI Error 
put to SiStripDH failed: key=SISTRIPDH:890012 rc=SQL function call error 
Time Report, hour = 24 
CEMLed 960 24 writes=1 cpu(u=0.22,s=0) clk(u=0.862083,s=0) 
CEMXef 960 24 writes=1 cpu(u=0.41,s=0) clk(u=0.897736,s=0) 
CEMFlashPed 960 24 writes=1 cpu(u=0.25,s=0) clk(u=0.913596,s=0) 
</pre> 
<b><i>etc ...</i></b> <br> 
<pre> 
Period at hour 96 ended, run = 890050 
Time Report, hour = 96 
CEMLed 960 24 writes=4 cpu(u=0.24,s=0.0204124) clk(u=0.962145,s=0.0815561) 
CEMXef 960 24 writes=4 cpu(u=0.285,s=0.0462781) clk(u=1.0432,s=0.14033) 
CEMFlashPed 960 24 writes=4 cpu(u=0.26,s=0.00408248) clk(u=1.30509,s=0.368078) 
CLACQie 3072 24 writes=4 cpu(u=0.805,s=0.0911501) clk(u=3.03485,s=0.147177) 
CLAPed 384 24 writes=4 cpu(u=0.1375,s=0.0193111) clk(u=0.495305,s=0.0646463) 
CLCAmplCalib 96 24 writes=4 cpu(u=0.12,s=0.0057735) clk(u=0.316389,s=0.0101461) 
CLCAmplCalib2 96 24 writes=4 cpu(u=0.045,s=0.005) clk(u=0.163096,s=0.0125773) 
COTStage0 1000 24 writes=4 cpu(u=0.38,s=0.0158114) clk(u=1.13541,s=0.0687301) 
CMUCh 4608 24 writes=4 cpu(u=1.7,s=0.139702) clk(u=4.80816,s=0.225469) 
CMUGlobal 1 24 writes=4 cpu(u=0.015,s=0.00288675) clk(u=0.0645577,s=0.00701763) 
CMPCh 1536 24 writes=4 cpu(u=0.5025,s=0.0249583) clk(u=1.66566,s=0.0987672) 
CMPChEl 1536 24 writes=4 cpu(u=0.3825,s=0.0221265) clk(u=1.46468,s=0.100394) 
CMPGlobal 1 24 writes=4 cpu(u=0.0125,s=0.0025) clk(u=0.110392,s=0.0250448) 
CMXChASP 2304 24 writes=4 cpu(u=0.5375,s=0.0246221) clk(u=2.06941,s=0.0847029) 
CMXChDRV 2304 24 writes=4 cpu(u=0.6025,s=0.0347311) clk(u=2.30558,s=0.183653) 
CMXGlobal 1 24 writes=4 cpu(u=0.0025,s=0.0025) clk(u=0.0585912,s=0.0107007) 
CSXChAST 786 24 writes=4 cpu(u=0.1425,s=0.0390246) clk(u=0.745006,s=0.0621325) 
CSXGlobal 1 24 writes=4 cpu(u=0.0025,s=0.0025) clk(u=0.0707615,s=0.0203297) 
CMUAll 1 24 writes=4 cpu(u=0.01,s=0.00408248) clk(u=0.0647485,s=0.0176042) 
CMPChannel 1112 24 writes=4 cpu(u=0.2325,s=0.0125) clk(u=1.05023,s=0.0827253) 
CMPRegion 2304 24 writes=4 cpu(u=0.3975,s=0.0184278) clk(u=2.02653,s=0.096859) 
CMPStack 1152 24 writes=4 cpu(u=0.25,s=0.0248328) clk(u=0.99182,s=0.0157804) 
CMXAll 1 24 writes=4 cpu(u=0.0025,s=0.0025) clk(u=0.053068,s=0.00213568) 
CMXChannel 2304 24 writes=4 cpu(u=0.4675,s=0.0587899) clk(u=2.0158,s=0.0528696) 
CMXQuadrant 4 24 writes=4 cpu(u=0,s=0) clk(u=0.0702195,s=0.0177012) 
CMXWedge 48 24 writes=4 cpu(u=0.025,s=0.005) clk(u=0.0945348,s=0.00297747) 
PESQie 212992 12 writes=8 cpu(u=54.0038,s=0.650502) clk(u=197.885,s=0.761172) 
PESPed 6656 12 writes=8 cpu(u=2.17375,s=0.0446389) clk(u=6.64673,s=0.0254941) 
PPRQie 3200 12 writes=8 cpu(u=0.82,s=0.030355) clk(u=2.92625,s=0.0240362) 
PPRQie2 100 12 writes=8 cpu(u=0.3175,s=0.00940175) clk(u=0.5685,s=0.0526578) 
PPRPed 100 12 writes=8 cpu(u=0.03875,s=0.00350382) clk(u=0.176854,s=0.0122828) 
</pre> 
<b><i>etc ...</i></b> <br> 
<b><i>Below one can see that we filled up some  <code>SVXDOWNTEST</code> 
....</i></b> <br> 
<pre> 
Period at hour 168 ended, run = 890089 
Error 1631 : ORA-01631: max # extents (505) reached in table CALIB_INT.SVXDOWNTEST 
sql: INSERT INTO SVXDOWNTEST (CID, CHIP, PED1, PED2, PED3, THRESHOLD) VALUES (:f1      ,:f2       ,:f3           ,:f4           ,:f5           ,:f6      ) 
 SVXDownTestOTL::doPut(key,cont)  execute failed 
OCI Error 
Error 2291 : ORA-02291: integrity constraint (CALIB_INT.CL_CAP_FK) violated - parent key not found 
sql: INSERT INTO CALIBRUNLISTS (TSID,CID,CALIB_RUN,CALIB_TABLE,CALIB_VERSION,PERIOD,DATA_STATUS) VALUES ( :f1     , :f2     , :f3     ,:f4          ,:f5     ,:f6     ,:f7           ) 
SiCellDHOTL put runlist: Error =  
OCI Error 
put to SiCellDH failed: key=SICELLDH:890090 rc=SQL function call error 
Time Report, hour = 168 
SVXDownTest 722432 168 writes=1 cpu(u=1277.5,s=0) clk(u=1790.53,s=0) 
SVXDh 7224 168 writes=1 cpu(u=1.01,s=0) clk(u=5.87103,s=0) 
CEMLed 960 24 writes=7 cpu(u=0.252857,s=0.0159932) clk(u=0.934967,s=0.0455676) 
CEMXef 960 24 writes=7 cpu(u=0.252857,s=0.0292538) clk(u=0.982847,s=0.0804525) 
CEMFlashPed 960 24 writes=7 cpu(u=0.255714,s=0.0249626) clk(u=1.15214,s=0.210858) 
CHALaser 768 168 writes=1 cpu(u=0.16,s=0) clk(u=0.710523,s=0) 
CHATimeLaser 768 168 writes=1 cpu(u=0.25,s=0) clk(u=0.806411,s=0) 
WHALaser 576 168 writes=1 cpu(u=0.18,s=0) clk(u=0.586404,s=0) 
PEMLaser 960 168 writes=1 cpu(u=0.24,s=0) clk(u=0.903831,s=0) 
PHALaser 864 168 writes=1 cpu(u=0.18,s=0) clk(u=0.775877,s=0) 
LSALaser 40 168 writes=1 cpu(u=0.01,s=0) clk(u=0.197393,s=0) 
CLACQie 3072 24 writes=7 cpu(u=0.781429,s=0.0517976) clk(u=2.94561,s=0.090476) 
CLAPed 384 24 writes=7 cpu(u=0.144286,s=0.0178429) clk(u=0.478462,s=0.0402381) 
CLCAmplCalib 96 24 writes=7 cpu(u=0.115714,s=0.00368856) clk(u=0.310628,s=0.00635283) 
CLCAmplCalib2 96 24 writes=7 cpu(u=0.0385714,s=0.00704698) clk(u=0.158537,s=0.00705852) 
COTChanT0 30240 168 writes=1 cpu(u=8.02,s=0) clk(u=28.0366,s=0) 
COTCtt 30240 168 writes=1 cpu(u=8.24,s=0) clk(u=28.1971,s=0) 
COTStage0 1000 24 writes=7 cpu(u=0.358571,s=0.0133503) clk(u=1.10339,s=0.0409492) 
CMUCh 4608 24 writes=7 cpu(u=1.60714,s=0.0927545) clk(u=4.76889,s=0.129908) 
CMUGlobal 1 24 writes=7 cpu(u=0.0114286,s=0.0026082) clk(u=0.0618111,s=0.00519663) 
CMPCh 1536 24 writes=7 cpu(u=0.477143,s=0.018089) clk(u=1.5911,s=0.0646591) 
CMPChEl 1536 24 writes=7 cpu(u=0.347143,s=0.0249489) clk(u=1.42659,s=0.0665551) 
CMPGlobal 1 24 writes=7 cpu(u=0.0142857,s=0.00297381) clk(u=0.0872543,s=0.0179407) 
CMXChASP 2304 24 writes=7 cpu(u=0.501429,s=0.0219771) clk(u=2.02136,s=0.0517014) 
CMXChDRV 2304 24 writes=7 cpu(u=0.578571,s=0.0243417) clk(u=2.19619,s=0.110964) 
CMXGlobal 1 24 writes=7 cpu(u=0.00428571,s=0.00202031) clk(u=0.053777,s=0.00650964) 
CMUAll 1 24 writes=7 cpu(u=0.01,s=0.00308607) clk(u=0.05771,s=0.0101009) 
CMUChannel 2304 24 writes=7 cpu(u=0.812857,s=0.0479938) clk(u=2.60181,s=0.262539) 
CMUWedge 48 24 writes=7 cpu(u=0.0242857,s=0.00782461) clk(u=0.103749,s=0.0113964) 
CMPAll 1 24 writes=7 cpu(u=0.00857143,s=0.00340068) clk(u=0.0548399,s=0.0051448) 
CMPChannel 1112 24 writes=7 cpu(u=0.218571,s=0.0165369) clk(u=0.997494,s=0.0507305) 
CMPRegion 2304 24 writes=7 cpu(u=0.402857,s=0.0128571) clk(u=2.01593,s=0.0623478) 
CMPStack 1152 24 writes=7 cpu(u=0.237143,s=0.0214603) clk(u=0.999629,s=0.0175529) 
CMXAll 1 24 writes=7 cpu(u=0.0114286,s=0.00986301) clk(u=0.0732963,s=0.0243216) 
CMXChannel 2304 24 writes=7 cpu(u=0.455714,s=0.0339367) clk(u=1.96732,s=0.0373111) 
CMXQuadrant 4 24 writes=7 cpu(u=0,s=0) clk(u=0.0693811,s=0.0131628) 
CMXWedge 48 24 writes=7 cpu(u=0.0185714,s=0.00459221) clk(u=0.0904577,s=0.00249961) 
PESQie 212992 12 writes=14 cpu(u=54.025,s=0.404082) clk(u=197.443,s=0.572819) 
PESPed 6656 12 writes=14 cpu(u=2.205,s=0.0343023) clk(u=6.73569,s=0.0637253) 
PPRQie 3200 12 writes=14 cpu(u=0.818571,s=0.0208041) clk(u=2.975,s=0.0410305) 
PPRQie2 100 12 writes=14 cpu(u=0.312143,s=0.00575876) clk(u=0.565686,s=0.0339232) 
PPRPed 100 12 writes=14 cpu(u=0.0407143,s=0.0071456) clk(u=0.186225,s=0.00920814) 
</pre> 
<b><i>etc ...</i></b> <br> 
<pre> 
Time Report, hour = 208 
SVXDownTest 722432 168 writes=1 cpu(u=1277.5,s=0) clk(u=1790.53,s=0) 
SVXDh 7224 168 writes=1 cpu(u=1.01,s=0) clk(u=5.87103,s=0) 
CEMLed 960 24 writes=8 cpu(u=0.26375,s=0.0176208) clk(u=0.949002,s=0.0418844) 
CEMXef 960 24 writes=8 cpu(u=0.24125,s=0.0278669) clk(u=1.00418,s=0.0728654) 
CEMFlashPed 960 24 writes=8 cpu(u=0.2625,s=0.0226582) clk(u=1.13515,s=0.183397) 
CHALaser 768 168 writes=1 cpu(u=0.16,s=0) clk(u=0.710523,s=0) 
CHATimeLaser 768 168 writes=1 cpu(u=0.25,s=0) clk(u=0.806411,s=0) 
WHALaser 576 168 writes=1 cpu(u=0.18,s=0) clk(u=0.586404,s=0) 
PEMLaser 960 168 writes=1 cpu(u=0.24,s=0) clk(u=0.903831,s=0) 
PHALaser 864 168 writes=1 cpu(u=0.18,s=0) clk(u=0.775877,s=0) 
LSALaser 40 168 writes=1 cpu(u=0.01,s=0) clk(u=0.197393,s=0) 
CLACQie 3072 24 writes=8 cpu(u=0.805,s=0.050674) clk(u=2.93817,s=0.0787073) 
CLAPed 384 24 writes=8 cpu(u=0.14125,s=0.0157477) clk(u=0.47238,s=0.035374) 
CLCAmplCalib 96 24 writes=8 cpu(u=0.1175,s=0.00365963) clk(u=0.30898,s=0.00574343) 
CLCAmplCalib2 96 24 writes=8 cpu(u=0.03875,s=0.00610547) clk(u=0.162523,s=0.00729724) 
COTChanT0 30240 168 writes=1 cpu(u=8.02,s=0) clk(u=28.0366,s=0) 
COTCtt 30240 168 writes=1 cpu(u=8.24,s=0) clk(u=28.1971,s=0) 
COTStage0 1000 24 writes=8 cpu(u=0.3475,s=0.0160078) clk(u=1.09049,s=0.0377366) 
CMUCh 4608 24 writes=8 cpu(u=1.61875,s=0.081162) clk(u=4.78403,s=0.113517) 
CMUGlobal 1 24 writes=8 cpu(u=0.01,s=0.00267261) clk(u=0.0612178,s=0.00453936) 
CMPCh 1536 24 writes=8 cpu(u=0.47375,s=0.0160287) clk(u=1.5722,s=0.0591005) 
CMPChEl 1536 24 writes=8 cpu(u=0.34125,s=0.0223956) clk(u=1.40844,s=0.0604273) 
CMPGlobal 1 24 writes=8 cpu(u=0.02,s=0.00626783) clk(u=0.094069,s=0.0169659) 
CMXChASP 2304 24 writes=8 cpu(u=0.49625,s=0.0197247) clk(u=2.01495,s=0.0452316) 
CMXChDRV 2304 24 writes=8 cpu(u=0.57625,s=0.0212079) clk(u=2.17232,s=0.0990187) 
CMXGlobal 1 24 writes=8 cpu(u=0.00375,s=0.00182981) clk(u=0.0610932,s=0.00923629) 
CSXChAST 786 24 writes=8 cpu(u=0.15375,s=0.019815) clk(u=0.736552,s=0.0321604) 
CSXGlobal 1 24 writes=8 cpu(u=0.00625,s=0.00263052) clk(u=0.0847333,s=0.0218954) 
CMUAll 1 24 writes=8 cpu(u=0.01875,s=0.00914906) clk(u=0.067123,s=0.0128501) 
CMUChannel 2304 24 writes=8 cpu(u=0.795,s=0.0452375) clk(u=2.56375,s=0.230529) 
CMUWedge 48 24 writes=8 cpu(u=0.025,s=0.00681385) clk(u=0.10491,s=0.00993754) 
CMPAll 1 24 writes=8 cpu(u=0.0075,s=0.00313392) clk(u=0.0536856,s=0.00460261) 
CMPChannel 1112 24 writes=8 cpu(u=0.21875,s=0.0143225) clk(u=0.990152,s=0.0445432) 
CMPRegion 2304 24 writes=8 cpu(u=0.415,s=0.0164751) clk(u=2.01045,s=0.0542715) 
CMPStack 1152 24 writes=8 cpu(u=0.2375,s=0.0185886) clk(u=0.996313,s=0.0155587) 
CMXAll 1 24 writes=8 cpu(u=0.01125,s=0.00854348) clk(u=0.0699621,s=0.0213254) 
CMXChannel 2304 24 writes=8 cpu(u=0.4525,s=0.0295653) clk(u=1.98617,s=0.0374081) 
CMXQuadrant 4 24 writes=8 cpu(u=0,s=0) clk(u=0.0671111,s=0.0116231) 
CMXWedge 48 24 writes=8 cpu(u=0.01625,s=0.00460493) clk(u=0.100076,s=0.00985851) 
PESQie 212992 12 writes=17 cpu(u=54.5118,s=0.423068) clk(u=197.907,s=0.535089) 
PESPed 6656 12 writes=17 cpu(u=2.20059,s=0.028971) clk(u=6.72618,s=0.0531343) 
PPRQie 3200 12 writes=17 cpu(u=0.841765,s=0.0226585) clk(u=3.02581,s=0.0454721) 
PPRQie2 100 12 writes=17 cpu(u=0.315294,s=0.00522421) clk(u=0.567623,s=0.027871) 
PPRPed 100 12 writes=17 cpu(u=0.04,s=0.00594089) clk(u=0.185449,s=0.00784444) 
SVXDownTest 722432 168 writes=1 cpu(u=1277.5,s=0) clk(u=1790.53,s=0) 
SVXDh 7224 168 writes=1 cpu(u=1.01,s=0) clk(u=5.87103,s=0) 
CEMLed 960 24 writes=8 cpu(u=0.26375,s=0.0176208) clk(u=0.949002,s=0.0418844) 
CEMXef 960 24 writes=8 cpu(u=0.24125,s=0.0278669) clk(u=1.00418,s=0.0728654) 
CEMFlashPed 960 24 writes=8 cpu(u=0.2625,s=0.0226582) clk(u=1.13515,s=0.183397) 
CHALaser 768 168 writes=1 cpu(u=0.16,s=0) clk(u=0.710523,s=0) 
CHATimeLaser 768 168 writes=1 cpu(u=0.25,s=0) clk(u=0.806411,s=0) 
WHALaser 576 168 writes=1 cpu(u=0.18,s=0) clk(u=0.586404,s=0) 
PEMLaser 960 168 writes=1 cpu(u=0.24,s=0) clk(u=0.903831,s=0) 
PHALaser 864 168 writes=1 cpu(u=0.18,s=0) clk(u=0.775877,s=0) 
LSALaser 40 168 writes=1 cpu(u=0.01,s=0) clk(u=0.197393,s=0) 
CLACQie 3072 24 writes=8 cpu(u=0.805,s=0.050674) clk(u=2.93817,s=0.0787073) 
CLAPed 384 24 writes=8 cpu(u=0.14125,s=0.0157477) clk(u=0.47238,s=0.035374) 
CLCAmplCalib 96 24 writes=8 cpu(u=0.1175,s=0.00365963) clk(u=0.30898,s=0.00574343) 
CLCAmplCalib2 96 24 writes=8 cpu(u=0.03875,s=0.00610547) clk(u=0.162523,s=0.00729724) 
COTChanT0 30240 168 writes=1 cpu(u=8.02,s=0) clk(u=28.0366,s=0) 
COTCtt 30240 168 writes=1 cpu(u=8.24,s=0) clk(u=28.1971,s=0) 
COTStage0 1000 24 writes=8 cpu(u=0.3475,s=0.0160078) clk(u=1.09049,s=0.0377366) 
CMUCh 4608 24 writes=8 cpu(u=1.61875,s=0.081162) clk(u=4.78403,s=0.113517) 
CMUGlobal 1 24 writes=8 cpu(u=0.01,s=0.00267261) clk(u=0.0612178,s=0.00453936) 
CMPCh 1536 24 writes=8 cpu(u=0.47375,s=0.0160287) clk(u=1.5722,s=0.0591005) 
CMPChEl 1536 24 writes=8 cpu(u=0.34125,s=0.0223956) clk(u=1.40844,s=0.0604273) 
CMPGlobal 1 24 writes=8 cpu(u=0.02,s=0.00626783) clk(u=0.094069,s=0.0169659) 
CMXChASP 2304 24 writes=8 cpu(u=0.49625,s=0.0197247) clk(u=2.01495,s=0.0452316) 
CMXChDRV 2304 24 writes=8 cpu(u=0.57625,s=0.0212079) clk(u=2.17232,s=0.0990187) 
CMXGlobal 1 24 writes=8 cpu(u=0.00375,s=0.00182981) clk(u=0.0610932,s=0.00923629) 
CSXChAST 786 24 writes=8 cpu(u=0.15375,s=0.019815) clk(u=0.736552,s=0.0321604) 
CSXGlobal 1 24 writes=8 cpu(u=0.00625,s=0.00263052) clk(u=0.0847333,s=0.0218954) 
CMUAll 1 24 writes=8 cpu(u=0.01875,s=0.00914906) clk(u=0.067123,s=0.0128501) 
CMUChannel 2304 24 writes=8 cpu(u=0.795,s=0.0452375) clk(u=2.56375,s=0.230529) 
CMUWedge 48 24 writes=8 cpu(u=0.025,s=0.00681385) clk(u=0.10491,s=0.00993754) 
CMPAll 1 24 writes=8 cpu(u=0.0075,s=0.00313392) clk(u=0.0536856,s=0.00460261) 
CMPChannel 1112 24 writes=8 cpu(u=0.21875,s=0.0143225) clk(u=0.990152,s=0.0445432) 
CMPRegion 2304 24 writes=8 cpu(u=0.415,s=0.0164751) clk(u=2.01045,s=0.0542715) 
CMPStack 1152 24 writes=8 cpu(u=0.2375,s=0.0185886) clk(u=0.996313,s=0.0155587) 
CMXAll 1 24 writes=8 cpu(u=0.01125,s=0.00854348) clk(u=0.0699621,s=0.0213254) 
CMXChannel 2304 24 writes=8 cpu(u=0.4525,s=0.0295653) clk(u=1.98617,s=0.0374081) 
CMXQuadrant 4 24 writes=8 cpu(u=0,s=0) clk(u=0.0671111,s=0.0116231) 
CMXWedge 48 24 writes=8 cpu(u=0.01625,s=0.00460493) clk(u=0.100076,s=0.00985851) 
PESQie 212992 12 writes=17 cpu(u=54.5118,s=0.423068) clk(u=197.907,s=0.535089) 
PESPed 6656 12 writes=17 cpu(u=2.20059,s=0.028971) clk(u=6.72618,s=0.0531343) 
PPRQie 3200 12 writes=17 cpu(u=0.841765,s=0.0226585) clk(u=3.02581,s=0.0454721) 
PPRQie2 100 12 writes=17 cpu(u=0.315294,s=0.00522421) clk(u=0.567623,s=0.027871) 
PPRPed 100 12 writes=17 cpu(u=0.04,s=0.00594089) clk(u=0.185449,s=0.00784444) 
</pre> 
</p>  
<p> 
<font color=maroon>That is ALL up to now ...</font> 
</p> 
</body> 
</html> 
  
<!-- Author: Igor Gorelov -->

<!-- Date: Sat Apr 14 18:23:03 2001 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Multiple Extents
Segment {SYS.SOURCE$} in tablespace SYSTEM is comprised of 147 extents. Segment CALIB_PRD.PPRQIE in tablespace CALIB_DATA is comprised of 76 extents. Segment CALIB_PRD.CESQIE in tablespace CALIB_DATA is comprised of 126 extents. Segment CALIB_PRD.WHAQIE in tablespace CALIB_DATA is comprised of 490 extents. Segment CALIB_PRD.PEMQIE in tablespace CALIB_DATA is comprised of 863 extents. Segment CALIB_PRD.PHAQIE in tablespace CALIB_DATA is comprised of 793 extents. Segment CALIB_PRD.CEMQIE in tablespace CALIB_DATA is comprised of 1107 extents. Segment CALIB_PRD.CHAQIE in tablespace CALIB_DATA is comprised of 901 extents. Segment CALIB_PRD.PESQIE in tablespac...
CRITICAL
Apr 14 2001 06:19:55 PM
</pre>
<!-- Author: oem-admin (email) -->