
ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest
ChatGPT is the hottest topic in the tech world right now. One story even says that ChatGPT has passed Google’s Level 3 programming interview. I …ChatGPT Won’t Replace…
Keep reading
Problematic Statistics of the Application Objects in your Oracle Database
One of the often asked questions is to find out the status of the statistics of the application owned schemas. In this article, I will list the SQL…
Keep reading
Oracle Automated DB Maintenance Tasks
This is a short article on how to manage the automated Oracle database maintenance tasks. Make sure the needed rights are in place by running the check: Typical…
Keep reading
Achieving Data Sovereignty with Oracle Sharding (Part 1)
Oracle Sharding meets data sovereignty requirements and supports applications that require low latency and high availability. — Read on blogs.oracle.com/database/post/achieving-data-sovereignty-with-oracle-sharding-part-1
Keep reading
Run Liquibase updates for a specific schema with SQLcl
Have a new version of your application schema to deploy? Let’s demonstrate how to run Liquibase updates for a specific schema. I have a changeSet for…Run Liquibase updates…
Keep readingHigh Availability Framework and Query Fault Tolerance for Hybrid Distributed Database Systems | Proceedings of the 31st ACM International Conference on Information & Knowledge Management
High Availability Framework and Query Fault Tolerance for Hybrid Distributed Database Systems | Proceedings of the 31st ACM International Conference on Information & Knowledge Management — Read on…
Keep readingResources management across database world – part I
Consolidation and resources optimization – we could we can meet them almost anywhere. Databases are there too. Everything is fine when available …Resources management across database world –…
Keep reading
List of the Oracle Database 23c New Features
On October 18th 2022, Oracle announced the new long term release of 23c Beta. Here is a compiled list of the new features I am aware of: OLTP…
Keep readingTop Six Oracle GoldenGate Announcements at Cloud World 2022
Innovative new capabilities, significant cost savings and a major leap forward in simplicity and usability for all GoldenGate developers! — Read on blogs.oracle.com/database/post/goldengate-announcements-at-cloud-world-2022
Keep readingOracle Announces MySQL HeatWave Lakehouse with 17X Faster Query Performance vs. Snowflake and 6X Faster than Redshift on 400 TB Workload
Oracle today announced MySQL HeatWave Lakehouse, enabling customers to process and query hundreds of terabytes of data in object store in a variety of file formats, such as…
Keep reading
SSB Schema creation on Oracle DB by using Autonomous and SQL Developer
Creating the empty SSB database objects on Oracle
Keep reading
Announcing Oracle GoldenGate Free
Oracle GoldenGate Free is the same powerful Oracle GoldenGate that enterprises rely on worldwide, packaged for simple download, ease-of-use, and a fully-fe — Read on blogs.oracle.com/dataintegration/post/oracle-goldengate-free
Keep readingOracle Database 23c Beta Program
Applications have opened for participation in the forthcoming Oracle Database 23c beta program — Read on blogs.oracle.com/database/post/oracle-database-23c-beta-program
Keep reading
Comparing Oracle Databases: Initialization Parameters
A method for comparing the Oracle init parameters of several PDB’s
Keep reading

TUE Post: Use Oracle SQL Developer to move data between databases
Use INSERT hint with SQL Developer
Keep reading
Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans
Very nicely explained by sqlmaria / Maria Colgan in the YouTube clip below. Clear and clean. I repost this as a reference and will add more later, if…
Keep readingResearching the Performance Puzzle | Ardent Performance Computing
The PostgreSQL Performance Puzzle was, perhaps, too easy – it didn’t take long for someone to guess the correct answer! But I didn’t see much discussion about why…
Keep readingTuesday Post: Database schemas compare
One of the questions that arise during the development process is if the database schéma I work on is an unaltered image of production. How do I know…
Keep readingLoading…
Something went wrong. Please refresh the page and/or try again.