BCBruno Cardosoincardoso.hashnode.dev·2d ago · 8 min readOracle APEX AI one-prompt application generationWhen version 26.1 finally came out, I remember excitedly going through the release notes. It was one of the biggest updates Oracle APEX has ever had, and more than 90 "Oracle APEX ideas" made it into 00
UAUptime Architectinuptimearchitect.hashnode.dev·2d ago · 15 min readOracle Virtual Private Database: Row-Level Security You Can't Route AroundYou wrote a view that filters each sales rep to their own region, granted the view, revoked the table, and called it row-level security. It worked — until the reporting team needed the base table, or 00
RZRameen Zafarinoracle-impact.hashnode.dev·4d ago · 4 min readSQL Query Performance Tuning: 5 Golden Rules for Slow Joins & Un-indexed TablesIs your database running slow? Are users staring at endless loading spinners in your web application? In 90% of cases, the bottleneck isn't the application code or server hardware,it’s un-optimized SQ00
UAUptime Architectinuptimearchitect.hashnode.dev·4d ago · 13 min readOracle Data Pump, Done Right: A Migration You Can Proveexpdp full=y and hope is not a migration plan. It's how you find out at 3 a.m. that the dump ran out of space, or the import invented a half-populated schema, or the "quick refresh" locked the source 00
UAUptime Architectinuptimearchitect.hashnode.dev·Sep 9 · 13 min readOracle Partition Pruning: Read One Partition, Not the Whole TableSomeone partitions the big table, the migration ticket gets closed, and everyone moves on believing the queries are now fast. Then a report that should read one month of data reads all of it, the plan00
UAUptime Architectinuptimearchitect.hashnode.dev·Sep 7 · 17 min readOracle Data Redaction: Mask at Read Time, Prove It Isn't Access ControlThe support rep sees ****-****-****-0001 on their screen and everyone relaxes. The card number is "masked," the demo looks compliant, the box gets ticked. Then someone runs an export, or a report buil00
RRRajesh Raviinrajeshravi.com·Sep 4 · 10 min readOEM 24ai HA/DR Architecture: What Happens When the Tool Watching Your Estate Goes DownOracle observability post #7 — the last post covered the OEM job system and how to turn routine DBA operations into scheduled, monitored automation. This one turns the lens on OEM itself: what happens01L
ARAndy Rinerpnova.hashnode.dev·Sep 1 · 4 min readAgentic ERP fails at the integration layer, not the model layerLast month, a mid-sized manufacturer attempted to automate their vendor reconciliation process using an autonomous AI agent. The agent ran flawlessly for 14 days, processing thousands of invoices. On 01M
UAUptime Architectinuptimearchitect.hashnode.dev·Aug 30 · 14 min readOracle Flashback: Undo at the Database LevelSomeone runs UPDATE accounts SET balance = 0 and forgets the WHERE. Commits it. A thousand balances are gone. The instinct is to reach for the backup — find last night's copy, restore it somewhere, ex00
RZRameen Zafarinoracle-impact.hashnode.dev·Aug 28 · 10 min readMulti-Region Bulk Actions in Oracle APEX: Selection, Copying, and Deletion across Cards & ReportsAdding multi-select features to tabular data is a standard UX requirement in web applications. While Interactive Grids in Oracle APEX offer native selection out of the box, Classic Reports and Cards R00
