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…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
- игры
AI
News
Tech
agents
ai
api
architecture
automation
backend
beginners
career
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
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,…
Oracle показала, что у технологической ИИ-революции могут закончиться деньги
Искусственный интеллект обещал изменить мировую экономику. Но пока компании рассказывают о революции производительности, инвесторы начинают задавать…
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…
История миграции CDRs в чарджинг системах
Около 5 лет назад я участвовал в миграции OCS с Oracle на Apache Ignite и обновлении стека самого чарджинга. Это была огром…
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…
ora2pg молча выбросил процедуру целиком, и это не самое обидное
ora2pg переносит схему с Oracle на PostgreSQL, и в целом переносит хорошо. Интересное начинается там, где он чего-то не осилил: он не падает и не ру…
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…
Ещё раз о статистике (где живёт статистика Oracle)
Эта статья предназначена для технических специалистов, работающих с Oracle: администраторов баз данных, инженеров производительности, разработчиков…
Об одном различии работы оптимизатора Postgres и Oracle
При переносе большой системы разработанной под одну СУБД на другую неизбежно возникают различные "нюансы", то что эффективно работало в одной СУБД,…