Tuesday, July 16, 2024

Automating Archive Log Cleanup in DBCS Standby Databases: A Step-by-Step Guide


In Oracle Cloud Infrastructure (OCI) Database Cloud Service (DBCS), the ability to use crontab or similar utilities to schedule jobs for the oracle user is restricted by default due to security and operational best practices. Here's why this restriction exists and alternative approaches you can use:

Prioritized Transactions in Oracle 26ai: Comparing Traditional Locking and Priority-Based Processing

Introduction In my previous blog post , we explored how Oracle 26ai completely eliminates lock contention for numeric attributes using Lock-...