Administration Cloud DB Link from Autonomous to On-Premises: ORA-28040: No matching authentication protocol Hi all, Hope you are doing good. The Summary I'm working on a project to migrate some databases running on On-Premises IBM AIX, 19.28, RAC w… Dec 17, 2025 6 min read
Administration Database Finding Top Growing Segments #JoelKallmanDay Before we go to the subject of this blog post, let me explain why the post have the #JoelKallmanDay tag! Since 2016, Oracle Community have a… Oct 15, 2025 6 min read
Administration Database Accidentally Set ORACLE_MAINTAINED=Y — Now What? Hi all, Hope you're doing well. The Question Today, a question came up on our internal distribution list: That's a good one, isn't it? Why d… Jul 2, 2025 7 min read
Administration Database How to Reclaim Space from LOBs: A Practical Case Study Hi everyone, hope you all are doing well! At our company, we have an internal distribution list where we discuss technical issues, challenge… Jun 10, 2025 13 min read
Administration Database Effective Management of $ORACLE_HOME/.patch_storage: Cleanup and Archive Strategies Hi all, Hope you're doing good! I had a call with one of our clients, long story short, they would like to cleanup some space under $ORACLE_… Jul 16, 2024 17 min read
Administration Database Automating Bulk Data Loads into Oracle Database with Shell Script and SQL*Loader Hey everyone, Hope you're doing good! Recently, a client approached me with an urgent issue: they needed to load 456 files into an Oracle Da… Jul 9, 2024 8 min read
Administration Database How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views Hi everyone, Hope you're doing good! Ensuring high availability of your Oracle databases is crucial for maintaining optimal performance and … Jul 2, 2024 5 min read
Administration Database Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits Some weeks ago, a client called complaining about a slowness during its load in a table. The scenario it was pretty simple: They are loading… Jun 25, 2024 10 min read
