Top big data analytics trends hold true as we look toward 2020

The overall importance of data and information within organizations has continued to grow. We’ve also seen the continued rise of megatrends like IoT, big data – even too much data – and of course, machine learning. That’s along with the…

Read More >

How to manage Oracle Flashback Log size

Here we will learn how to manage the size of flashback logs generated in our environment. This is useful especially when you are hitting the error “ORA-00242: maximum allowed filename records used up in control file” which can be related…

Read More >

How to migrate from Teradata to Google BigQuery

Google BigQuery is a serverless, highly scalable, low-cost enterprise data warehouse that helps data analysts become more productive. It enables extremely fast analytics on a petabyte scale. And its pay-as-you-go model makes it attractive for organizations looking to move away…

Read More >

How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error

Have you received this error on OMS 12.1.0.3? “Metric evaluation error start – Get dynamic property error,” After performing some research on MOS and a confirmation SR, it seems related to Bug 17575631 CLUSTER DB HOME PAGE ERRORS- REGIONS FETCH…

Read More >

ProxySQL Configuration File & Startup Process Explained

When learning ProxySQL, we have seen some confusion around the configuration and especially around the usage of the configuration file. In this post, we will explain how ProxySQL treats its internal configuration and its configuration file. The proxysql.cnf For the…

Read More >

How to Reduce Exadata Core Count

During preparation for a client’s datacenter migration, we decided to move services one-by-one to the datacenter / hardware in order to keep the scope of changes controlled. To accomplish this, we also needed to resize the CPU count of Exadata…

Read More >

Working with Ansible, PostgreSQL and Docker

While working on creating some of our internal training labs for PostgreSQL, I have had the pleasure of working with PostreSQL in Docker and working with it in different ways.  One of the most important ways that I worked with…

Read More >

Join Pythian for Percona Live Europe 2019 Amsterdam

Percona Live is always a great opportunity to learn from the best and brightest in the open-source database community. This time, Percona Live Europe is being held at the Hilton Amsterdam Airport Schiphol, The Netherlands from September 30 to October…

Read More >

Stop Migrating Databases to 12c!

If you are starting an upgrade plan, do it directly to Oracle Database 19c. Why? Well, let’s agree that 19c is “equivalent” to 12.2.0.3 on previous version models, and 18c would be 12.2.0.2, after the latest in the old format:…

Read More >

Three Announcements from Oracle OpenWorld You Probably Didn’t Hear

The buzz from OpenWorld this year was the permanently free Oracle Cloud offering, the new Exadata X8M (reportedly capable of 12 million I/O per second!), Oracle Autonomous Cloud at Customer, and the new Blockchain table. Here are three interesting or…

Read More >
Page 3 of 35112345...10...Last Page »