Learn how to trace and analyze problematic sessions using Oradebug and TKPROF in Oracle 19.25.0.0. Quick steps, real-world example, and insights to help you troubleshoot high I/O or wait events....
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....
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....
This is a blog post on how you can script your RMAN backups using Oracle External Password Store with the SYSBACKUP privilege...
Issue Unsupported named object type for bind parameter when applying RU SQL Patch in CDB...
This is a blog post on how an ORA-01102 error Drove Me Nuts trying to find the fix for it and the undocumented parameter cdb_cluster...
How I worked around the error ORA-00600 [KPDBHASHTABLEINS:DUP] when my container crashed after cloning a PDB....
This is a blog post on how I finished a GI Out Of Place Patching (OOP) from 19.6 to 19.8 after Facing cluutil: No Such File or Directory and clsrsc-740 Errors ...
This is a blog post on how I fixed TNS-12564 errors and show the importance of the LOCAL_LISTENER database parameter in a 19c DataGuard switchover....
Oracle 19c DataGuard introduced a very cool feature which is the ability to flashback your standby automatically if you flashback your primary. In this post I will show you an example of how it is done....