(Mike.Dietrich) This is a short “Black Friday” blog post. And just if you are tired already of hunting supposed-to-be-bargain-buys, you may need something to relax – and watch this Video: Best Practices to Upgrade to Oracle Database 19c.
Tag: Oracle
Archive Backups are not Deleted from Standby Database
(Liron Amitzi) In an environment I’ve upgraded lately from 11.2 to 18c I found out that some backups are not getting deleted from the standby database. The environment has a single instance primary database (with GI+ASM) and a single instance standby database (with GI+ASM) and we run backups on the
srvctl config all
(mdinh) Learned something new today and not sure if it’s new feature.
Oracle patches – some basics and good-to-know information
(Martin Berger) Oracle Patches can occur very complicated and confusing. Most of the time they are zip files with strange and sometimes inconsistent naming convention.
Changing PDB/CDB spfile parameters
(brendantierney) When working with a Oracle database hosted on the Oracle cloud (not an Autonomous DB), I recently had the need to change/increase the number of processes for the database. After a bit of researching it looked liked I just had to make the change to the SPFILE and that would be it.
Microprocess Considerations
(Jan Kettenis) In this article I discuss some considerations when applying the Microprocess Architecture, and how those can impact the design of the process.
Machine Learning with SQL
(Andrej Baranovskij) Python (and soon JavaScript with TensorFlow.js) is a dominant language for Machine Learning. What about SQL? There is a way to build/run Machine Learning models in SQL. There could be a benefit to run model training close to the database, where data stays.
Introduction to Oracle Machine Learning – SQL Notebooks on top of Oracle Cloud Always Free Autonomous Data Warehouse
(Lucas Jellema) One of the relatively new features available with Oracle Autonomous Data Warehouse is Oracle Machine Learning Notebook. The description on Oracle’s tutorial site states: “An Oracle Machine Learning notebook is a web-based interface for data analysis, data discovery, and data visualiz
How to resize a btrfs root partition on Oracle Linux
(Gerald) Resizing a root partition (/) of a running Oracle Linux isn’t hard but the information out there on the web is limited. In my situation, I was given access to an already installed Oracle Linux environment that wasn’t using all the available space of the disk.
Convert Groupby Result on Pandas Data Frame into a Data Frame using …. to_frame()
(Lucas Jellema) It is such a small thing. That you can look for in the docs, no Stackoverflow and in many blog articles. After I have used groupby on a Data Frame, instead of getting a Series result, I would like to turn the result into a new Data Frame [to continue my manipulation, querying, visual