<!-- Title: 17:48:35  Wed Aug 29 2001 -->
<!-- Crewchief: nstanfield -->
<!-- Op1: &nbsp; -->
<!-- Op2: &nbsp; -->
<!-- Op3: &nbsp; -->
<!-- Op4: &nbsp; -->
<!-- Op5: &nbsp; -->
<!-- Op6: &nbsp; -->
<!-- Notes: -->
<pre>database activity</pre>

<!-- Date: Wed Aug 29 22:01:45 2001 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Tablespace Full
Tablespace USERTEMP_01 is 80.85% full.  745300.0 KBytes of free space remain.
WARNING
Aug 29 2001 10:00:03 PM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Aug 29 23:32:20 2001 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Tablespace Full
Tablespace USERTEMP_01 is 94.32% full.  220980.0 KBytes of free space remain.
CRITICAL
Aug 29 2001 11:30:06 PM
</pre>
<!-- Author: oem-admin (email) -->


<!-- Date: Wed Aug 29 23:55:10 2001 -->
<pre>
Target Name : cdfonprd.fnal.gov
Target Type : Database
Node Name : b0dau35.fnal.gov

Alert
The following errors are in the ALERT file : ORA-1652: unable to extend temp segment by 16384 in tablespace             USERTEMP_01.
WARNING
Aug 29 2001 11:53:12 PM
</pre>
<!-- Author: oem-admin (email) -->



<!-- Date: Thu Aug 30 08:39:40 2001 -->
<pre>Looked at users logged on between 10:01 and 11:54, 
to try to understand who used TEMP. 
 
No additional trace files.    
 
Wed Aug 29 23:52:02 CDT 2001 
Information for: cdfonprd 
 
PID            SID Serial# Username     OS Username  Machine              Program 
---------- ------- ------- ------------ ------------ -------------------- ---------------------------------------- 
4332           100       4 CDFDAQ       cdfdaq       b0dap56.fnal.gov 
13868           91      22 CDF_READER   oracle       rlc@b0dap18          triggerGui.TriggerDBMain 
7211            73     -58 CDF_READER   l3proxy      b0l3gate2 
19353           43       7 CDF_READER   syoon        fcdfsgi2 
26135           66      61 CDF_READER   cdfdaq       b0dap66.fnal.gov 
20927           48       4 CDF_READER   syoon        fcdfsgi2 
12229           45      48 CONSUMER_MON oracle       jdbcclient           JDBC-1.0-Client 
                           ITOR 
 
22114           79      17 CONSUMER_MON oracle       jdbcclient           JDBC-1.0-Client 
                           ITOR 
 
1867            12       2 DATA_HISTORY oracle       b0dau35              vppdc@b0dau35 (TNS V1-V3) 
1871            14       1 DATA_HISTORY oracle       b0dau35              vppdc@b0dau35 (TNS V1-V3) 
3565            16       6 DBREADER     oracle       b0dau35              dbsnmp@b0dau35 (TNS V1-V3) 
19721           65     112 DBREADER     toolman      b0dau35              sqlplus@b0dau35 (TNS V1-V3) 
1861             9       3 DBSNMP       oracle       b0dau35              dbsnmp@b0dau35 (TNS V1-V3) 
1863            11       1 DBSNMP       oracle       b0dau35              dbsnmp@b0dau35 (TNS V1-V3) 
15418           63     111 HMON         cdfdaq       cdfdaq@b0dap63       rc.ListenToVmeBusScan -u -q hmon/hmon 
7332            60      89 PJW          pjw          pjw@b0dap16          cdfdb.Retire 
20380           13    -124 PJW          pjw          pjw@b0dap18          triggerGui.TriggerDBMain 
6845            76     -36 PJW          oracle       pjw@b0dap18          triggerGui.TriggerDBMain 
17127           27     -14 REICHOLD     cdfdaq       cdfdaq@b0dap29       runedit.RunStatusEditor 
27170           17       8 RUN_USER     cdf_cf       b0dap30.fnal.gov        ?  @b0dap30.fnal.gov (TNS V1-V3) 
29289           33      18 RUN_USER     cdfdaq       b0dap30.fnal.gov        ?  @b0dap30.fnal.gov (TNS V1-V3) 
8536            26     120 RUN_USER     rlc          rlc@b0dau30          /cdf/code/freeware/jdk/v1_3/bin/../bin32 
                                                                          /sgi/gre 
 
8540             8      71 RUN_USER     rlc          rlc@b0dau30          /cdf/code/freeware/jdk/v1_3/bin/../bin32 
                                                                          /sgi/gre 
 
19360           57     -13 RUN_USER     patrick      patrick@b0dau30      146960 /cdf/code/freeware/jdk/v1_3/bin/. 
                                                                          ./bin32/ 
 
15410           52      99 RUN_USER     cdfdaq       cdfdaq@b0dap63       cdfdb.DatabaseMonitor 
17203           20       7 RUN_USER     cdfdaq       cdfdaq@b0dap63       cdfdb.DatabaseMonitor 
6259            59       6 RUN_USER     pjw          pjw@b0dap16          cdfdb.Retire 
16084           74    -128 RUN_USER     evbproxy     evbproxy@b0l3gate1   cdfevb/ace/EventBuilder 
13550           44    -101 RUN_USER     eddy         eddy@b0dap19         hdwusr.CardEditor 
4334           106      97 RUN_USER     cdfdaq       cdfdaq@b0dap59       rc.GUI 
9178            64     -94 RUN_USER     jsm          jsm@b0dap20          rc.GUI 
17625           55     -81 RUN_USER     jsm          jsm@b0dap20          rc.GUI 
22509          113     -15 RUN_USER     cdfdaq       cdfdaq@b0dap59       rc.GUI 
4722            92      53 RUN_USER     cdfdaq       cdfdaq@b0dap59       rc.GUI 
26324           68     119 RUN_USER     cdfdaq       cdfdaq@b0dap59       rc.GUI 
7482           115     -76 RUN_USER     jsm          jsm@b0dap20          rc.GUI 
17617           88     -45 RUN_USER     jsm          jsm@b0dap20          rc.GUI 
9162            99      46 RUN_USER     jsm          jsm@b0dap20          rc.GUI 
13532           56      20 RUN_USER     robine       robine@b0dap23       rc.GUI 
17487           95     -94 RUN_USER     robine       robine@b0dap23       rc.GUI 
15955          105    -122 RUN_USER     cdfdaq       cdfdaq@b0dap57       rc.vxmon.ScalerMonitor /cdf/code-common/ 
                                                                          cdfonlin 
 
15957          110     -87 RUN_USER     jsm          jsm@b0dap26          rc.vxmon.ScalerMonitor /cdf/code-common/ 
                                                                          cdfonlin 
 
1014            28      92 RUN_USER     cdfdaq       cdfdaq@b0dap57       rc.vxmon.VxMonSumFer /cdf/code-common/cd 
                                                                          fonline/ 
 
14905           25     -18 RUN_USER     cdfdaq       cdfdaq@b0dap63       resmgr.ResMgr resmgr 
9082           109      84 RUN_USER     cdfdaq       cdfdaq@b0dap63       resmgr.ResMgr resmgr 
18220           81     -32 RUN_USER     csl          csl@b0dap60          resusr.ResClient -ccdf_csl@fnal.gov -p 
18218           29     -35 RUN_USER     csl          csl@b0dap60          resusr.ResClient -ccdf_csl@fnal.gov -p 
8133           103       7 RUN_USER     smwang       smwang@b0dap30       runedit.RunStatusEditor 
23664           23     -20 RUN_USER     paus         paus@b0dap30         runedit.RunStatusEditor 
22605           50    -103 RUN_USER     paus         paus@b0dap30         runedit.RunStatusEditor 
2340            49     120 RUN_USER     smwang       smwang@b0dap30       runedit.RunStatusEditor 
1697            39     -49 RUN_USER     cdfdaq       cdfdaq@b0dap29       runedit.RunStatusEditor 
29410           71    -109 RUN_USER     ikado        ikado@b0dap30        runedit.RunStatusEditor 
8916           102     -68 RUN_USER     hypertxt     hypertxt@b0dau30 
8904            93      -6 RUN_USER     hypertxt     hypertxt@b0dau30 
3069            69     -18 RUN_USER     ikado        ikado@b0dap30 
25337           70       8 RUN_USER     hypertxt     hypertxt@(unknown) 
18475           67     108 RUN_USER     hypertxt     hypertxt@b0dau30 
19354           87     -51 RUN_USER     hypertxt     hypertxt@b0dau30 
8729           108     123 RUN_USER     hypertxt     hypertxt@b0dau30 
11722           40      59 RUN_USER     hypertxt     hypertxt@b0dau30 
19356           84      32 RUN_USER     hypertxt     hypertxt@b0dau30 
13127           19     103 RUN_USER     hypertxt     hypertxt@b0dau30 
26658           89      64 RUN_USER     hypertxt     hypertxt@(unknown) 
27836           75      67 RUN_USER     hypertxt     hypertxt@(unknown) 
24419           24    -117 RUN_USER     hypertxt     hypertxt@(unknown) 
19358           15     -34 RUN_USER     hypertxt     hypertxt@b0dau30 
1730             7       1              oracle       b0dau35              oracle@b0dau35 (ARC0) 
17020           30      96              oracle       b0dau35              oracle@b0dau35 (ARC1) 
17077           36      99              oracle       b0dau35              oracle@b0dau35 (ARC2) 
17718           46      80              oracle       b0dau35              oracle@b0dau35 (ARC3) 
9439            58     -35              oracle       b0dau35              oracle@b0dau35 (ARC4) 
1724             4       1              oracle       b0dau35              oracle@b0dau35 (CKPT) 
1720             2       1              oracle       b0dau35              oracle@b0dau35 (DBW0) 
1722             3       1              oracle       b0dau35              oracle@b0dau35 (LGWR) 
1718             1       1              oracle       b0dau35              oracle@b0dau35 (PMON) 
1728             6       1              oracle       b0dau35              oracle@b0dau35 (RECO) 
1726             5       1              oracle       b0dau35              oracle@b0dau35 (SMON)</pre>
<!-- Author: nstanfield -->


<!-- Date: Thu Aug 30 09:43:46 2001 -->
<pre>Syncup the views on cdfofprd with cdfonprd. crtView procedure of dbrep package was modified to create views based upon aliases  
derived from all_tab_columns. View text is derived from 
all_views as earlier.  
</pre>
<!-- Author: akumar -->


<!-- Date: Thu Aug 30 14:59:53 2001 -->
<pre>Add CALIBDB table IMUPOSITION, CMUPOSITION, CMPPOSITION,  
CMXPOSITION to replication.</pre>
<!-- Author: W.Badgett -->


<!-- Date: Fri Aug 31 15:37:14 2001 -->
<pre>Subject: Your timestamps running out of extents 
 
Hi Jack, 
 
Your TIMESTAMP table's primary key index TS_PK is running 
out of extents, currently using 108 of 120  (90%) 
 
Can you please fix? 
 
</pre>
<!-- Author: W.Badgett -->