<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: "Times New Roman", Times, serif; font-size: 12pt; color: rgb(0, 0, 0);">
I think I should remove them in adappstst and test them. Adapps, I assume is your production data.</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:"Times New Roman",Times,serif; font-size:12pt; color:rgb(0,0,0); font-style:italic">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Sent:</b> Thursday, May 14, 2020 10:14 AM<br>
<b>To:</b> David Sheppard <sheppard@jlab.org><br>
<b>Cc:</b> pansophy <pansophy@jlab.org><br>
<b>Subject:</b> RE: Database Stuff</font>
<div> </div>
</div>
<div lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">The materialized views were done for uploading data acquisition. It only creates a datestamp for the files that were uploaded. The code utilizing them is not being used, or offered
to be used, so I think it is safe to remove them and re-create views when needed.</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Should I removed them from the pansophydev databases and test?</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Valerie</span></p>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif"> David Sheppard <sheppard@jlab.org>
<br>
<b>Sent:</b> Thursday, May 14, 2020 10:12 AM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Cc:</b> Bobby Lawrence <robertl@jlab.org>; pansophy <pansophy@jlab.org>; E. Anne McEwen <mcewen@jlab.org>; Tony Reilly <areilly@jlab.org><br>
<b>Subject:</b> Re: Database Stuff</span></p>
</div>
</div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">Also, as far as materialized views are concerned, I'm not sure what was behind the decision to use them in the first place. If they are converted to views, I'm not sure whether or not your code would break. You can try it and see what
happens. We will be having maintenance on the evening of May 19th, so current 12.2.0.1 databases will be patched and the server will be rebooted.</span></p>
</div>
<div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<i><span style="color:black"> </span></i></p>
</div>
<div class="x_MsoNormal" align="center" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Sent:</b> Thursday, May 14, 2020 10:07 AM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Cc:</b> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>>; pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> Re: Database Stuff</span> </p>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
</div>
</div>
<div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">Those databases were 18c databases. Do you really want to test them? I had removed them because there wasn't any data in them.</span></p>
</div>
<div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<i><span style="color:black"> </span></i></p>
</div>
<div class="x_MsoNormal" align="center" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_divRplyFwdMsg">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Sent:</b> Thursday, May 14, 2020 10:01 AM<br>
<b>To:</b> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Cc:</b> Bobby Lawrence <<a href="mailto:robertl@jlab.org">robertl@jlab.org</a>>; pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> RE: Database Stuff</span> </p>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
</div>
</div>
<div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">David,</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">I cannot attach the databases below to our pansophydev server in the ColdFusion administrator.</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black; background:yellow">acctst, factst, samtst, and travtst</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">What am I missing? I wanted to test them before we release our production server.</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Also, Mike asked a question about converting our current materialized views inti just views. Is this possible?</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Then we can downgrade to normal Oracle server.</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Will you be rebooting our database servers on the 19<sup>th</sup>? Will the coldfusion servers also be rebooted?</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Thanks.</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">Valerie</span></p>
<div style="border:none; border-bottom:double windowtext 2.25pt; padding:0in 0in 1.0pt 0in">
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
</div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D; background:yellow">SQL from materialized_view for MV_C50_DECOMM</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> CREATE MATERIALIZED VIEW "ADAPPS"."MV_C50_DECOMM" ("DATE_STAMP")</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> NOCOMPRESS LOGGING</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> TABLESPACE "USERS"
</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> BUILD IMMEDIATE</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> USING INDEX
</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> REFRESH FORCE ON DEMAND START WITH sysdate+0 NEXT sysdate + 1</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> USING DEFAULT LOCAL ROLLBACK SEGMENT</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> USING ENFORCED CONSTRAINTS ENABLE QUERY REWRITE</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> AS SELECT TO_DATE(TIME_STAMP,'DD-FMMonth-FMYYYY') AS DATE_STAMP</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">FROM adapps.c50_decomm</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">GROUP BY TO_DATE(TIME_STAMP,'DD-FMMonth-FMYYYY')</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D">;</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> CREATE UNIQUE INDEX "ADAPPS"."I_SNAP$_MV_C50_DECOMM" ON "ADAPPS"."MV_C50_DECOMM" (SYS_OP_MAP_NONNULL("DATE_STAMP"))
</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> STORAGE(INITIAL 65536 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> TABLESPACE "USERS" ;</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> COMMENT ON MATERIALIZED VIEW "ADAPPS"."MV_C50_DECOMM" IS 'snapshot table for snapshot ADAPPS.MV_C50_DECOMM';</span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:14.0pt; font-family:"Calibri",sans-serif; color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif"> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>>
<br>
<b>Sent:</b> Friday, April 24, 2020 3:56 PM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Cc:</b> pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> Re: Database Stuff</span></p>
</div>
</div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">Good Afternoon,</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">I have set up a test database environment. The databases
<span style="background:yellow">are acctst, factst, samtst, and travtst</span>.</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">They have the same naming and password conventions that the production databases have. We</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">can discuss how to set them up whenever you like. I can even have them refresh data from the</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">production databases nightly if you would like. In that case, this could be how testing is done</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">going forward. Just a thought. Anyway, have a great weekend, and we can discuss more as we</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">move forward.</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">David Shepard</span></p>
</div>
<div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<i><span style="color:black"> </span></i></p>
</div>
<div class="x_MsoNormal" align="center" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_x_divRplyFwdMsg">
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Sent:</b> Tuesday, April 21, 2020 10:48 AM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Cc:</b> pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> Re: Database Stuff</span> </p>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
</div>
</div>
<div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">ok. Thank you. I will do my best to set up some sort of test environment for you. You only have test schemas, not test databases. I will try to create some test databases with version 18c. Then, we can navigate how you can test using
them.</span></p>
</div>
<div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<i><span style="color:black"> </span></i></p>
</div>
<div class="x_MsoNormal" align="center" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_x_x_divRplyFwdMsg">
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Sent:</b> Tuesday, April 21, 2020 10:31 AM<br>
<b>To:</b> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Cc:</b> pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>>; E. Anne McEwen <<a href="mailto:mcewen@jlab.org">mcewen@jlab.org</a>>; Tony Reilly <<a href="mailto:areilly@jlab.org">areilly@jlab.org</a>><br>
<b>Subject:</b> Re: Database Stuff</span> </p>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
</div>
</div>
<div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">David,</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:16.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Yes, please reboot our db server tonight. And yes let's setup a monthly reboot to keep things running smoothly.</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:16.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Also, Yes to upgrading our database server. Let us know how much time you need and possible dates. Will there be a need for us to test before going to production? We will also have to let users know
before we do the switch.</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:16.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Additionally, did our new db server get funded and approved? What is the ETA?</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:16.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">What other information do you need from us?</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Thanks for your support!!</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-size:16.0pt; font-family:"Calibri",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Valerie</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="font-family:"Calibri",sans-serif; color:black">Pansophy Team</span></p>
</div>
<div class="x_MsoNormal" align="center" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_x_x_x_divRplyFwdMsg">
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> David Sheppard <<a href="mailto:sheppard@jlab.org">sheppard@jlab.org</a>><br>
<b>Sent:</b> Tuesday, April 21, 2020 10:20 AM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> Database Stuff</span> </p>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
</p>
</div>
</div>
<div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">Good Morning Valerie,</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">I was wondering if we can start doing monthly database server reboots</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">during maintenance day. There doesn't appear to be anything wrong. It</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">may make things run a little better and more efficient. Also, I have</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">installed Oracle Database 18c on our development database servers.</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">Since, you don't have development databases or development servers,</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">I will not attempt to install it right now, but it should be something we</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">should do in the not to distant future. I'm not as worried about it because</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">18c is really just 12.2.0.2. You're already running Oracle Database 12.2.0.1.</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">I just wanted to put a bug in your ear about it. And let me know about</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">rebooting pansophydb tonight. Stay safe and have a great day.</span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black"> </span></p>
</div>
<div>
<p class="x_xxmsonormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;">
<span style="color:black">David Sheppard</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>