Ran into a DB creation failure (DBAAS-60022) while provisioning an Oracle 23ai DB on ExaCC (Image 25.1.3). After digging through logs and a bit of head-scratching, the root cause turned out to be a Java version mismatch — DBCA was compiled with Java 11, but...
Understanding Oracle's data consistency mechanisms is key to ensuring reliable database operations. Even after a commit, changes may not be immediately written to the datafiles due to Oracle’s DBWn process. Instead, Oracle relies on the Online Redo Log to recover committed transactions in the event...
Learn the fundamentals of Oracle Database architecture in this beginner-friendly guide. Discover how Oracle instances work, including essential memory structures like SGA, PGA, UGA, and key background processes such as PMON, SMON, DBW, and LGWR. Perfect for new DBAs, developers, and anyone starting their journey...
New to Oracle? This Back-To-Basics guide breaks down the Oracle Database Server architecture—explaining the physical and logical components, key files, and how the instance works. Perfect for aspiring DBAs looking to build a solid foundation....
In this post we will look at the Online Redo Log which consists of physical files that store redo records, capturing changes made to the database. These records are crucial for the recovery process, as they facilitate "roll forward" of committed changes and "roll back"...
In this back-to-basics we go into what a database instance is. We view key components like the System Global Area (SGA) and background processes such as PMON and DBWn that ensure efficient memory management and data integrity. Understanding instances is crucial for database performance and...
Confused about Oracle Undo Records and their role in database management? This guide breaks it down, explaining how undo data supports read consistency and transaction rollback. Whether you're a DBA or a developer, mastering undo records is key to maintaining data integrity and performance....
A small blog post on what I will be looking forward at OCW 24 around Multicloud...
Oracle Exadata Exascale was released, in this blog post I want to answer two questions : What is it and What are the benefits of it....
Unlock the power of Oracle OCI, Terraform, and Infrastructure as Code with this blog series. In this third entry from beginner basics to advanced techniques, we discuss the CIS Foundations Landing Zone, how to use complex data types and for Expressions, and how they are...