Tag: Oracle 12c

Big Savings on Oracle REDO Via Temp UNDO

oracle redo

Reduce the REDO generation in your Oracle database by setting one parameter.

Read More >

Oracle Service Bus (OSB) 12c LDAP Authorization – HTTP 401 (Unauthorized)

Oracle Service Bus 12.2 and onwards is available to download on Oracle Support. As you might expect, the new version brings some changes for middleware admins and new features to developers when configuring an installation from scratch. Among them, on…

Read More >

How to Make Oracle Use the Correct Index

Learn a simple method to make Oracle use the index required for a SQL Query.

Read More >

Recreate Redo / Standby Logs in a DG Broker Environment

While increasing the redo log file size for my production environment, I came across a requirement I’d like to share with you. The process should be quite straightforward as we can add / drop redo log files online. However, since…

Read More >

Resolving Error ORA-28353: Failed to Open Wallet

Full disclosure: this is a post I've had in draft mode for almost one and a half years. I noticed the original error after applying the October 2018 bundle patch (BP) for While I realize most clients are no... Read More >

While Upgrading from GI 12c to 19c, +asm1(19c) Cannot Detect +asm2(12c)

A few weeks ago, I was working on a GI upgrade from 12.2 to 19.6. After running the upgrade on Node 1, an issue occurred where +asm1(19c) could not detect +asm2(12c). The information below describes the actions I performed to... Read More >

How to fix InfiniBand Error: Cable is present on Port “X” but it is polling for peer port

Facing an InfiniBand error? Let me guess: Ports 03, 05, 06, 08, 09 and 12 are alerting? You have a Quarter Rack? Have recently installed Exadata plugin to version or higher? Don’t panic! This is probably related to Bug 15937297:…

Read More >

Redo volume optimization in 12c R2

I was using SLOB to compare the throughput between 12.1 and 12.2 databases, and was surprised to see that the average redo size per transaction was ~18.5KB on 12cR2, and ~339KB on 12cR1. Understanding this difference was important for the…

Read More >

Debugging CBQT OR expansion with 10053 trace

I had been working with a client to add a little bit of functionality to an analytical view that we had been running queries against for a while. The functionality was easy to implement but during testing we found that…

Read More >

Oracle parallel query hints – part 1: PQ_DISTRIBUTE

One of the most powerful features of the Oracle database is its ability to leverage multiple cores spread across many RAC servers to execute a single query. Oracle’s optimizer tries its best to execute queries in the most efficient manner,…

Read More >
Page 1 of 3123