Spring has Sprung!

A wife send her husband an SMS on a cold winter evening: “Windows frozen”.

The husband sends an answer back: “Pour some warm water over them”.

Some time later husband receives an answer from his wife: “The computer is completely and utterly broken now”.

and another one…

I changed my password to “incorrect”. So whenever I forget what it is the computer will say “Your password is incorrect”.

No apologies!

We’ve been enjoying some beautiful weather here in the UK over the long Easter weekend – but we’re due to have a break from the sunshine over the next few days.

Time to curl up indoors with the leftover chocolate eggs and some of the latest news and blogs? Have a look at some of the finest below…

Blogs of the week

1. Publishing Machine Learning API with Python Flask

Andrejus Baranovskis wrote, “Flask is fun and easy to setup, as it says on Flask website. And that’s true. This microframework for Python offers a powerful way of annotating Python function with REST endpoint. I’m using Flask to publish ML model API to be accessible by the 3rd party business applications. This example is based on XGBoost.”

2. Monitoring your Oracle APEX environment; when is a good time to do an upgrade?

Dimitri Gielis says, “Yesterday Oracle released Oracle APEX 19.1. We typically upgrade our environment within a week. The question is always, when is a good time to upgrade?”

3. Adding VLANs on an ODA

Marco Mischke says, “The Oracle Database Appliances X7-2 come only with one redundant network interface, so it is not possible to separate network traffic between distinct fault-tolerant bonded interfaces. But at least we can use VLANs on the one and only bonded interface that all the ODA X7-2 provide. If you choose to use VLANs, this choice must be taken at the point of installing the ODA. There is no easy way to change that afterwards. So if you use VLANs, you do it right from the beginning when you do the “configure-firstnet”.”

4. Want to change the future Amazon RDS performance monitoring?

Kyle Hailey writes, “Have you ever used Amazon RDS console to manage performance on an RDS database and had ideas on how to make it better?  The Amazon UX Research team for AWS is collaborating with me to recruit for an upcoming user research study with Amazon Relational Database Service (RDS) performance monitoring.”

Read the full blog for more details of this.

5. Enterprise Manager 13c – Database Usage Tracking Report Bug with FTP destination

Dirk Nachbar wrote, “Within Oracle Enterprise Manager 13c you have a nice Feature under the BI Publisher Reports to generate Database Usage Tracking Reports and to deliver them to a FTP Server, called BurstToFTP. Unfortunately if you follow the very good official step-by-step documentation on how to setup and to configure the Database Usage Tracking Report you will not be able to get your Database Usage Tracking Reports under your FTP Server :-(”

6. Don’t do it at all in the cloud or not

Ric Van Dyke begins his blog by writing, “It’s rather incredible what a simple thing like DISTINCT can do the performance.  Recently I was tasked with improving performance on a query.  It was taking over an hour to complete. Running the plan and watching SQL Monitor it was easy to see that the plan was spending the vast major of time on a SORT UNIQUE step.   It was sorting thru 1.4 Billion rows, so that is a lot of data to go thru.  But the worse part was there was the same number of rows going into the SORT UNIQUE as coming out.  Meaning, all the rows going in were already unique.”

7. git_version_control

This blog goes through:

  • What is version control?
  • Where does Git store information?
  • How can I tell what I have changed?
  • Clone a repository of rritec

8. Collaborate 2019 – Exadata SMART Monitoring – OEM 13c

Alfredo shares the following presentation:

9. OAC Remote Data Connector with Jetty

Richard Williams begins by saying, “The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. There are now 2 versions. The initial version required that a web-sever, either weblogic or tomcat, be used on premise for the tool to work.  That version is still available, and for customers already using Weblogic or Tomcat on-premise, that may still be the preferred approach.  Details on configuring that can be found in this article. For customers who don’t want to license an additional web-server, there is now a version of RDC that is standalone.  The tool is based on a Jetty Servlet Engine (more details here).”

10. Time Series Forecasting in Oracle – Part 1

Brendan Tierney writes, “Time-series analysis comprises methods for analyzing time series data in order to extract meaningful statistics and other characteristics of the data. In this blog post I’ll introduce what time-series analysis is, the different types of time-series analysis and introduce how you can do this using SQL and PL/SQL in Oracle Database. I’ll have additional blog posts giving more detailed examples of Oracle functions and how they can be used for different time-series data problems. Time-series forecasting is the use of a model to predict future values based on previously observed/historical values. It is a form of regression analysis with additions to facilitate trends, seasonal effects and various other combinations.”

This week on Twitter

Connor McDonald shared Haversine PL/SQL

Kashif Manzoor posted Accessing DB objects through Oracle Integration Cloud for a Visual Builder App


Stories from spendolini.blogspot.comsvenweller.wordpress.com and connor-mcdonald.com

Videos such as Less block sizes…More simplicity