<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.xxmsonormal, li.xxmsonormal, div.xxmsonormal
{mso-style-name:x_x_msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Should I removed them from the pansophydev databases and test?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Valerie<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><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<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><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.<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><i><span style="color:black"><o:p> </o:p></span></i></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><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> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><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.<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><i><span style="color:black"><o:p> </o:p></span></i></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="MsoNormal"><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> <o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">David,</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="color:black;background:yellow">acctst, factst, samtst, and travtst</span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Then we can downgrade to normal Oracle server.</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks.</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Valerie</span><o:p></o:p></p>
<div style="border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in">
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
</div>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D;background:yellow">SQL from materialized_view for MV_C50_DECOMM</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> CREATE MATERIALIZED VIEW "ADAPPS"."MV_C50_DECOMM" ("DATE_STAMP")</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> NOCOMPRESS LOGGING</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> TABLESPACE "USERS"
</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> BUILD IMMEDIATE</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> USING INDEX
</span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> USING DEFAULT LOCAL ROLLBACK SEGMENT</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> USING ENFORCED CONSTRAINTS ENABLE QUERY REWRITE</span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">FROM adapps.c50_decomm</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">GROUP BY TO_DATE(TIME_STAMP,'DD-FMMonth-FMYYYY')</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D">;</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> STORAGE(INITIAL 65536 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> TABLESPACE "USERS" ;</span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><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><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="xxmsonormal"><span style="font-size:14.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="xxmsonormal"><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><o:p></o:p></p>
</div>
</div>
<p class="xxmsonormal"> <o:p></o:p></p>
<div>
<p class="xxmsonormal"><span style="color:black">Good Afternoon,</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><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><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">They have the same naming and password conventions that the production databases have. We</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">can discuss how to set them up whenever you like. I can even have them refresh data from the</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">production databases nightly if you would like. In that case, this could be how testing is done</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">going forward. Just a thought. Anyway, have a great weekend, and we can discuss more as we</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">move forward.</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">David Shepard</span><o:p></o:p></p>
</div>
<div>
<div>
<p class="xxmsonormal"><i><span style="color:black"> </span></i><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_divRplyFwdMsg">
<p class="xxmsonormal"><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> <o:p></o:p></p>
<div>
<p class="xxmsonormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xxmsonormal"><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><o:p></o:p></p>
</div>
<div>
<div>
<p class="xxmsonormal"><i><span style="color:black"> </span></i><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_x_divRplyFwdMsg">
<p class="xxmsonormal"><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> <o:p></o:p></p>
<div>
<p class="xxmsonormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xxmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">David,</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><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><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><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><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Additionally, did our new db server get funded and approved? What is the ETA?</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">What other information do you need from us?</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Thanks for your support!!</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-size:16.0pt;font-family:"Calibri",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Valerie</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="font-family:"Calibri",sans-serif;color:black">Pansophy Team</span><o:p></o:p></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="3" width="98%" align="center">
</div>
<div id="x_x_x_x_divRplyFwdMsg">
<p class="xxmsonormal"><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> <o:p></o:p></p>
<div>
<p class="xxmsonormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xxmsonormal"><span style="color:black">Good Morning Valerie,</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">I was wondering if we can start doing monthly database server reboots</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">during maintenance day. There doesn't appear to be anything wrong. It</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">may make things run a little better and more efficient. Also, I have</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">installed Oracle Database 18c on our development database servers.</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">Since, you don't have development databases or development servers,</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">I will not attempt to install it right now, but it should be something we</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">should do in the not to distant future. I'm not as worried about it because</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">18c is really just 12.2.0.2. You're already running Oracle Database 12.2.0.1.</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">I just wanted to put a bug in your ear about it. And let me know about</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">rebooting pansophydb tonight. Stay safe and have a great day.</span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xxmsonormal"><span style="color:black">David Sheppard</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>