#oracle

Project Cost Capitalization in Oracle Fusion: From Project Costing to Fixed Assets Project...

Let's create small project that how we can call the OIC Integrations-MCP in Postman The below...

ORA-00257 isn't a crash — it's the archiver refusing to lose your redo. What 'connect internal only' actually means, why it's almost always a full Fast Recovery Area (ORA-19809) and not a database fault, how to read V$RECOVERY_FILE_DEST / V$RECOVERY_AREA_USAGE / V$ARCHIVE_DEST, the right fix (RMAN backup + delete, not rm), and a lab that forces ORA-00257 on a tiny FRA then clears it.

ORA-01555 is not a bug in your query — it's read consistency working: a long query needs undo that heavy DML overwrote. What snapshot-too-old actually is, why undo_retention is only a target until you add RETENTION GUARANTEE (and the ORA-30036 trade-off), the fetch-across-commit anti-pattern, and a lab that forces the error on a tiny undo tablespace then makes the same query complete.

In Oracle Database 12c, it is possible to use the DUPLICATE command at the PDB level. However, there...

In a container database environment, one PDB can sometimes generate a huge amount of redo in a short...

A major PostgreSQL version upgrade is not only a matter of installing the new server. The migration...

Last week, I published an article about Oracle Deep Data Security (Deep Sec) in Oracle AI Database...

In this release, the memory lifecycle becomes more explicit: memories can be created, connected,...

SET DEFINE OFF Purpose: Controls whether SQL*Plus and SQL Developer interpret the ampersand...

1. SQL Statement Classifications SQL statements are categorized based on their functional...

Native JSON ↔ Stringified JSON: OIC's Data Translate Action we recently tried a project...