The Legacy Obituaries

Notices of desupport & departureOracle Database → AzureTuesday, 29 September 2026The Coroner’s ReportsAbout this paper

The Coroner’s Reports

18 questions · 4 witnesses · graded blind · frozen 2026-09-27

Every answer the migration agent gave in its evaluation, with every query it ran. Nothing to install.

How to read this

  • No tools. The model alone, answering from memory.
  • Keyword search. BM25 over the same 446 documents: top 8 passages pasted in, one pass, references not followed.
  • Sanity Context · GROQ. The agent with the GROQ endpoint: schema, joins, Portable Text.
  • GROQ + Knowledge Base. The agent with both endpoints.
  • Answers were shuffled and relabelled before an independent model graded them against a fixed rubric; citations were checked by script. Verdict: reached the expected conclusion. Grounded: no claim beyond retrieved evidence. Cited: cited every required publisher.
  • Models: the two Sanity conditions ran on the smaller model; the two baselines ran on the larger model. Grader: the larger model. The DEV posts name both models.

Totals

No tools10/18verdicts · grounded 0/18 · cited 11/16
Keyword search14/18verdicts · grounded 16/18 · cited 4/16
Sanity Context · GROQ17/18verdicts · grounded 18/18 · cited 12/16
GROQ + Knowledge Base17/18verdicts · grounded 18/18 · cited 12/16

The cases

#QuestionNo toolsKeyword searchSanity Context · GROQGROQ + Knowledge Base
q01We are on Oracle 19c and use DBMS_JOB for nightly batches. Moving to Azure SQL Managed Instance — what happens to those jobs? version-scope✗✗✓✗✓✗✓✓✓✓✓✓
q02How should an unconstrained NUMBER column be mapped when migrating to Azure SQL Database versus Azure Database for PostgreSQL? dispute✗✗✓✓✓✗✓✓✓✓✓✓
q03Is Oracle Streams still an option for replicating to Azure? fact✓✗✓✓✗✗✓✓✓✓✓✓
q04Our app relies on empty string being NULL in VARCHAR2 columns. Which Azure targets keep that behaviour? fact✓✗✗✗✓✗✗✓✗✗✓✓
q05What is the maximum IOPS of a Premium SSD v2 disk for an Oracle VM on Azure? refusal✗✗·✓✓·✓✓·✓✓·
q06We still run a non-CDB 19c database. Does that matter for the Azure move? version-scope✓✗✓✓✓✓✓✓✓✓✓✓
q07How do we replace fast-refresh materialized views when moving to Azure Database for PostgreSQL? howto✓✗✓✓✓✗✓✓✓✓✓✓
q08Which Oracle auditing method survives into 26ai and what does Azure SQL offer instead? fact✗✗✓✓✓✗✓✓✓✓✓✓
q09Can we keep using PRAGMA AUTONOMOUS_TRANSACTION logic after moving to Azure SQL Managed Instance? fact✓✗✗✓✗✗✓✓✓✓✓✗
q10We plan to move to Oracle 23ai on Azure VMs and use the new SQL BOOLEAN type. Anything to watch in a later hop to Azure SQL? version-scope✓✗✓✓✓✗✓✓✗✓✓✗
q11Does Azure SQL Database (not Managed Instance) support database links / cross-database queries like Oracle? fact✓✗✓✓✓✓✓✓✓✓✓✓
q12What replaces the original exp utility in Oracle 26ai and what does that mean for our export-based migration scripts? fact✗✗✓✓✓✓✓✓✓✓✓✓
q13Some posts say DBMS_JOB was removed in 19c. True? dispute✓✗✗✓✓✓✓✓✓✓✓✗
q14Our VARCHAR2(100) columns hold multibyte text. Anything to watch on Azure SQL? fact✓✗✗✓✓✗✓✓✗✓✓✓
q15What is the recommended path for moving Oracle Advanced Queuing workloads to Azure? howto✗✗✗✗✓✗✓✓✗✓✓✗
q16How many Azure regions offer Oracle Database@Azure today? refusal✗✗·✓✓·✓✓·✓✓·
q17Is ROWID usable after migration to Azure SQL? fact✓✗✓✓✓✗✓✓✓✓✓✓
q18We are on Oracle 12.2 and use Oracle Multimedia for images. What are our options on Azure? version-scope✗✗✓✗✓✗✓✓✓✓✓✓

Cases q04 and q13 were re-run after a fix; open them to see both runs. Each cell: verdict · grounded · cited. Hover for the grader’s note. Raw runs: agent/eval.

Added after the freeze

How-to questions written after the frozen run to test the Knowledge Base on the prose it holds. Same conditions and models; not counted in the totals above.

#QuestionNo toolsKeyword searchSanity Context · GROQGROQ + Knowledge Base
q19We're moving a 19c Enterprise Edition database from IBM AIX to Oracle Database@Azure (Exadata) with a 2-hour outage window. Which migration method should we use, and in what order should we rule the options out? howto✗✗✗✗✓✗✓✓✗✓✓✓
q20Our Azure standby is in sync and the on-premises primary is healthy. For the cutover, should we do a Data Guard switchover or a failover, and what do we check first? howto✓✗✗✓✓✓✓✓✓✓✓✓