This article details a troubleshooting experience involving an Oracle library cache lock issue caused by the method used to enable a Unified Audit Policy for new users.

This article tackles a unique challenge for Oracle DBAs: creating SQL Plan Baselines for workloads that run exclusively on read-only Active Standby Databases. While this scenario is officially unsupported, as standby databases do not typically allow write operations, this post explores a practical workaround. It details two distinct, repeatable methods designed to overcome this limitation, allowing DBAs to manage SQL performance directly on their standby environments.