Logging in PL/SQL that survives ROLLBACK (and 4 mistakes to avoid)
You get a call: last night's batch failed, the transaction rolled back, and now someone asks "what happened?" You open your log table. It's empty. I…
AI & ML
⚑ Сообщить о проблемеПоследние новости AI & ML от Tech News
Use REST Describe Metadata Before a Payload Contract Drifts
An integration can keep sending syntactically valid JSON after its target contract has changed. The first visible symptom may be a rejected create,…
ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.
The pager goes off at 3 a.m.: the application is frozen. Every screen that tries to save hangs, and the ones that time out come back with ORA-00257:…
Duplicating a PDB into Another CDB
In Oracle Database 12c , it is possible to use the DUPLICATE command at the PDB level. However, there is a limitation: a new CDB must also be create…
My OCI sandbox factory now installs on a Free Tier account, with no card
Every time I showed people the thing I built — a chat that spins up Oracle Cloud sandboxes and deletes them when their time is up — the reply was th…
Где заканчивается автопилот в DR: разбор оркестрации ВМ, WORM в S3, конфликтов с СРК и задач DBA
Привет, Хабр! Разбирать вопросы после эфиров — полезная практика. В чате трансляции часто поднимают темы, с которыми инженерам приходится сталкивать…
Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool
The database is pinned at 90% CPU, the app team swears nothing changed, and AWR is topped by cursor: pin S wait on X and a parse-heavy profile. Nobo…
Oracle sends force majeure notice on its New Mexico Stargate data center
The notice would allow Oracle to delay payments should the facility miss its 2028 target to come online.
Oracle SQL: Pseudo-Columns
1. Overview & Core Concepts Definition: A pseudo-column behaves like a table column, but it is not actually stored on disk in the table. Capabil…
How to Build an Antigravity Workflow with the Oracle SQLcl MCP Server and Oracle AI Database
This article adapts the same MCP workflow pattern for Antigravity and Oracle AI Database. Companion notebook:&nbs…
Oracle PL/SQL Exception Handling
An Exception is a PL/SQL runtime error condition triggered during code execution. When an exception is raised, normal execution of the current PL/SQ…
How to read OCI bucket files in OCI Oracle Database SQL using OCI resource principals
How to read Oracle Cloud object storage bucket files using SQL in an OCI Oracle database using OCI resource principals 1. Create dynamic group While…
Oracle Java 27 Release Updates Post-Quantum Cryptography
Oracle announced the official release of Java 27, marking a significant milestone for the programming language. This version introduces critical sec…
From SQL to Conversation: Exploring Oracle Select AI
Introduction What if you could query your Oracle database without writing SQL? Oracle Select AI brings generative AI directly into the database, all…
When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More
When did a database change happen? This isn't just academic. Incremental replication must order committed changes and resume exactly without locking…
Larry Ellison cancels $7.5 billion sale of Oracle stock
Oracle had previously disclosed that Ellison planned to sell 50 million shares worth around $7.5 billion.
Oracle tries to appease Stargate data center opponents with renewables push
Renewables pledge won’t change the Oracle and OpenAI data center’s use of gas.
Open-Source Oracle Database Performance History with PostgreSQL and Grafana
Oracle databases expose a huge amount of performance information through dynamic performance views. The difficult part is not obtaining a metric at…
Oracle Cloud Infrastructure AI Foundations: A Step into the World of AI and Machine Learning
When people hear the term artificial intelligence, they often think of tools that generate text, create images, or answer questions. But artificial…
Oracle Data Redaction: Mask at Read Time, Prove It Isn't Access Control
The support rep sees ****-****-****-0001 on their screen and everyone relaxes. The card number is "masked," the demo looks compliant, the box gets t…
OCI Monitoring Alarms: Six Ways an Alarm Can Look Ready and Still Fail
A practical review of metric timing, query scope, notification delivery, suppression, and operator response While reviewing Oracle's alarm documenta…
OCI - Connecting to an OCI Always Free MySQL DB System: Installing MySQL Shell and Building a "Poor Man's VPN"
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
What will happen if Cloud database becomes too expensive ???
For most of the last fifteen years, "move it to the cloud" was the answer to almost every data infrastructure question. Storage was cheap, compute w…
My Experience Running a Homelab on Oracle Cloud’s Free VPS
It’s been a while since I wrote a blog post. Recently, I decided to get back into writing and document something I’ve been playing around with: sett…
Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.
Oracle Designer 10g is a CASE tool from the early 2000s. Support ended in 2013. At my job it is still the center of development: the repository hold…
Following ROWIDs Through an Oracle Unique Index Update
I've always been amazed by how Oracle Database handles updates to a unique column—performing set-based operations that don't violate the unique cons…
Как мы «приручали» ИИ в WMS
Недавно я реализовывал задачу автоматизации выставления счетов за оказание логистических услуг на основании данных из WMS и ТСД. В процессе разработ…
Teaching an AI to read a relational database — including Oracle APEX
A few months back I started building a tool to solve a problem that kept annoying me: when you want an AI assistant to help with an old database, yo…
Your First Oracle Autonomous Database on OCI Always Free
The single best way to keep your Oracle skills sharp without a license, a server, or a finance conversation is OCI Always Free . It gives you a real…
"The 6 Pagination Bugs That Eat Oracle Fusion REST API Integrations"
Every collection GET against an Oracle Fusion REST API is paginated whether you ask for it or not. Call GET /workers , treat the response as "all wo…