Contenting Logo

News

Entertainment

Science & Technology

Sport

Business & Money

Life

Culture & Art

Hobbies

Sites
Lists
#tags
  1. home
    2. ›
  2. Julian Dontcheff's Database Blog

Julian Dontcheff's Database Blog

8 | Follower

Software

See All

Julian Dontcheff's Database Blog

31.10.2023

Some new PL/SQL features in Oracle Database 23c | Julian Dontcheff's Database Blog

PL/SQL stands for Procedural Language for SQL. PL/SQL is Oracle's procedural extension for SQL and is is loosely based on Ada (a variant of Pascal developed for the US Deptartment of Defense).  PL/SQL has been available in Oracle Database since version 6 (first released in 1992) while stored PL/SQL procedures/functions/packages/triggers became available with version 7.…

Julian Dontcheff's Database Blog

25.01.2024

The 5 major benefits of ECPUs in the Oracle Autonomous Database | Julian Dontcheff's Database Blog

Oracle Autonomous Database (ADB) recently introduced a more advanced ECPU billing metric and is now retiring the legacy OCPU billing metric for Autonomous Data Warehouse and Autonomous Transaction Processing in the next 12 months. Oracle recommend switching from the OCPU billing metric to the ECPU billing metric, which will not incur any downtime or service…

Julian Dontcheff's Database Blog

15.02.2024

Performance Tuning in the Oracle Autonomous Database: Creating Indexes for JSON Collections | Julian Dontcheff's Database Blog

The Oracle Database and in particular the Oracle Autonomous Database offers multiple technologies to accelerate queries and improve database performance over JSON data, including indexes, materialized views, in-memory column storage, and Exadata storage-cell pushdown. Simple Oracle Document Access (SODA) is a NoSQL query language for storing, editing and deleting JSON documents. A SODA collection is…

Julian Dontcheff's Database Blog

13.03.2024

Disaster Recovery for the Oracle Autonomous JSON Database | Julian Dontcheff's Database Blog

“You can't prepare for everything - but you can prepare for anything.” - Paul Youngjohns Backup-Based Disaster Recovery is a low-cost DR option for databases with higher RTO tolerance. As Autonomous Data Guard is currently not supported for Autonomous JSON Database workloads, the natural questions is what are the alternatives: Option 1. The backup-based Disaster…

Contenting Logo
About UsPrivacy PolicyTerms Of UseContact