YuanOracle's profile picture. Oracle ACE, 20+ Oracle certifications. Sharing AWR, ASH and SQL tuning insights.

Yuan Oracle ACE

@YuanOracle

Oracle ACE, 20+ Oracle certifications. Sharing AWR, ASH and SQL tuning insights.

Pinned

My 20+ Oracle certifications

YuanOracle's tweet image. My 20+ Oracle certifications

When host CPU is saturated but Oracle Instance CPU is only 12.3%, it usually means Oracle is not the real CPU consumer. After checking, we found multiple Oracle instances running on this same AIX host.

YuanOracle's tweet image. When host CPU is saturated but Oracle Instance CPU is only 12.3%, it usually means Oracle is not the real CPU consumer.
After checking, we found multiple Oracle instances running on this same AIX host.

AI seems poised to replace every human job, but it's merely "micro-intelligent"—narrow and task-specific. In the IT world, architects will be the last holdouts. Globally? Philosophers will outlast us all. Do you agree? #AI #FutureOfWork


Non-cached sequence was run 119,001 times, dragged down performance.

YuanOracle's tweet image. Non-cached sequence was run 119,001 times, dragged down performance.
YuanOracle's tweet image. Non-cached sequence was run 119,001 times, dragged down performance.

Due to the tech decoupling between the US and China giants, we're seeing a "de-Americanization" push in China's IT industry. In databases, this has sparked over 200 homegrown options—most mimic Oracle's AWR reports, but they're only truly useful in the top SQL section. They lag…


Can AI parse Oracle AWR reports? Yes, but beware: AI can confidently hallucinate nonsense, tricking newbies into bad decisions. Always verify outputs with your expertise. #Oracle #OracleACE #AWR


Many people find the RAC section in an Oracle AWR report arcane. In reality, if the gc-related wait events take only a small portion of the Top Events, you don’t even need to dig into the RAC section. This example shows exactly that. But if gc wait events are non-negligible,…

YuanOracle's tweet image. Many people find the RAC section in an Oracle AWR report arcane.
In reality, if the gc-related wait events take only a small portion of the Top Events, you don’t even need to dig into the RAC section.
This example shows exactly that.
But if gc wait events are non-negligible,…

Why two quotes in the command? Outer quotes keep the whole string intact for bash. Inner quotes tell RMAN that the connect string + role is one token. → First level = bash, second level = RMAN.

YuanOracle's tweet image. Why two quotes in the command?
Outer quotes keep the whole string intact for bash.
Inner quotes tell RMAN that the connect string + role is one token.
→ First level = bash, second level = RMAN.

How Representative Are Captured SQL Statements in Oracle AWR Reports? Before analyzing the Top SQL in the SQL Statistics section of an Oracle AWR report, first determine how well these SQL statements represent the overall workload. If the captured portion is too small, any…


Loading...

Something went wrong.


Something went wrong.