Y. Frolov 
The file manager was just the beginning. What started as a practical sync problem has been deliberately shaped into a controlled environment for testing AI-assisted software engineering — before that system touches a single line of production code. The Problem That Started It Every engineer who manages deployments manually knows the friction: two directories that … Read more
Step 3 of the Series: Building DevRag: A Deterministic Runtime for AI Development Milestones 1 and 2 built the core guarantees: tasks can be reliably parsed and written, state transitions are enforced by a state machine, no invalid state can be persisted. But none of that is accessible to anything external. The task files live … Read more
ORA-06564 says “does not exist” — but the object usually does. The real failure is visibility: privilege boundaries, PDB namespace isolation, Data Pump migration gaps, or legacy scripts that assume pre-12c global directory scope. This article traces five distinct root causes behind the same error message and maps how directory object behavior changed across Oracle 11g through 23ai.
ORA-29400 covers four completely different failure modes — missing files, corrupted CSVs, disk exhaustion, and permission mismatches — behind one generic error code. This article traces each root cause through real production incidents in multi-tier architectures where Oracle External Tables depend on files from upstream services, and shows why the database is almost never where the problem actually started.
Why the CBO Decides Whether Your CTE Materializes — and Why That Decision Breaks in Production The WITH clause looks like a contract: define a named subquery once, reference it multiple times, let Oracle do the rest. The problem is that Oracle never signed that contract. The Cost-Based Optimizer treats your CTE as a suggestion, … Read more
In AI development orchestrators, most teams place the model at the center of the system. DevRag does the opposite: first, a strict, deterministic runtime is created that fully manages state, auditing, and all changes, and only then are AI agents added.
This key architectural decision helps avoid critical issues with consistency, debugging, and compliance in production systems.
Series: Building IntelliJ Plugins for Complex XML Systems There is a class of problem that appears constantly in large configuration-driven systems: the structure you see is not the structure that matters. You see a tree of XML files. The system behaves as a graph of interdependent entities. The IDE knows nothing about that graph — … Read more
UTC hourly bucket timezone offset mismatch causes SQL queries to return zero rows while the UI shows hits. A deep dive into why half-hour timezones like IST break hourly aggregation and how to fix your filters.
When Oracle JVM breaks, it rarely announces itself clearly. You get cascading invalid package errors, PL/SQL wrappers that suddenly fail to compile, or Java stored procedures returning cryptic ORA-29549 and ORA-29553 errors. This guide covers the full recovery sequence — from verifying prerequisites through reinstalling the JVM itself to restoring all dependent objects and validating the result. Written against Oracle … Read more
Oracle JVM is one of those components that silently breaks and stays broken until something downstream explodes at the worst possible moment. This post walks through every diagnostic layer — from registry presence checks down to memory pool analysis — so you can triage a JVM issue in minutes rather than hours. All queries run … Read more