Implementing Incremental Forever Strategy for Oracle Database Backups
When databases get ever larger and larger, backing them up using traditional RMAN backupsets will quickly get unfeasible. Completing a backup requires too much time... Read More
Explain the Explain Plan – Interpreting Execution Plans for SQL Statements
The plan for a SQL statement can seem complicated and hard to understand. Determining if the plan you are got is the best plan can... Read More
PL/SQL: Still the Best Data Access Language Ever Invented
Another year goes by, and most likely, another data access framework has been invented. It will claim to be the fastest, smartest way to talk... Read More
Introduction to Machine Learning – From DBAs to Data Scientists
This session will focus on basics of what Machine Learning is , different types of Machine Learning and Neural Networks , supervised and unsupervised machine... Read More
Long Live Multimedia with REST and Oracle APEX!
Part of the Oracle database since Oracle8, Oracle have discontinued Oracle Multimedia as of Oracle 19c. This leaves existing customers with a dilemma, either keep... Read More
Using Oracle Flashback Data Archive to Track and Store Transactional Changes
Flashback Data Archive (FDA) provides the ability to track and store transactional changes to a table over its lifetime. FDA provides a mechanism for tracking... Read More
An Autonomous Singularity Approaches: Force Multipliers for Overwhelmed DBAs
Autonomous Database Services have expanded well beyond their original scope of heavy analytical workloads (ADW) and hybrid transaction processing / reporting workloads (ATP) to include... Read More
Oracle Visual Builder – A Crash Course
Oracle Visual Builder is a new platform that simplify the development of mobile and web apps with the latest industry standards tech stack – JavaScript/HTML/REST.... Read More
Plan Stability: What Are the Pitfalls and Is It What You Think It Is?
Database administrators sometimes need to control or change SQL execution plans. If application code can be modified, then DBAs or database architects might ask application... Read More
Oracle Database Infrastructure as Code with Ansible
Wikipedia defines infrastructure as code as “the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or... Read More