Good question, Jim. I don't know if I have much to offer by way of advice; I also feel like there's got to be a better way to get early notice of Oracle issues.
We have explored or are exploring several different approaches: (a) hire a DBA (b) hire a a consultant (c) use other Oracle expertise at KUMC (d) run away! and try postgres. Hiring worked ok for a while, but attrition is a natural thing and finding a good fit is a challenge. We hired Burleson and had them do an Oracle health check http://www.dba-oracle.com/oracle_health_check.htm . We haven't found time to implement all of their recommendations. :-/ And we haven't managed to grant them access to do it for us. :-/ A big reason we use Oracle is that KUMC has an enterprise license. We made an arrangement with another IT group at KUMC to get some time from their DBAs. That's going pretty well recently. Meanwhile, we're keeping an eye on postgres and trying not to invest in Oracle techniques that don't port readily to postgres. -- Dan ________________________________________ From: GPC Informatics [d...@madmode.com] Sent: Tuesday, May 30, 2017 3:36 PM To: campb...@unmc.edu; Dan Connolly Subject: [gpc-informatics] #601: Advice on Oracle/SQL Server maintenance protocols #601: Advice on Oracle/SQL Server maintenance protocols ---------------------------+----------------------- Reporter: campbell | Owner: dconnolly Type: design-issue | Status: new Priority: minor | Milestone: Component: dev-tools | Keywords: Blocked By: | Blocking: ---------------------------+----------------------- We have our i2b2 platforms on Oracle. Our support shop has little experience with maintaining production environments for the identified and deidentified platforms. Last week we experienced prolonged downtime due to file count overruns in Oracle that could have been prevented had we monitoring and management routines in place. Can any of our colleagues across GPC give us advice on Oracle maintenance procedures we should be establishing as part of our operating procedures? Jim -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/601> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev