English
English Indonesia Türkçe Deutsch Español Português Pусский Français Italiano Nederlands Polski العربية ไทย Tiếng Việt 繁體中文 简体中文 日本語 한국어
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.

253Posts 317Followers 445Following
You might like
Pinned
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Nov 15

My 20+ Oracle certifications

YuanOracle's tweet image. My 20+ Oracle certifications
0
1
4
0
128
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Nov 19

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.
0
1
5
1
367
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Nov 17

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

0
0
3
0
71
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Nov 12

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.
0
2
5
1
102
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Nov 11

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…

0
1
3
1
114
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Nov 4

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

0
1
7
1
200
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Oct 30

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,…
0
2
9
1
131
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Oct 29

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.
1
3
7
0
190
YuanOracle's profile picture.
Yuan Oracle ACE
@YuanOracle
Oct 28

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…

YuanOracle's tweet card. 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 smal…
How Representative Are Captured SQL Statements in Oracle AWR Reports?
Source: byte-way.com
0
3
5
1
173

United States Trends

You might like

Something went wrong.


Something went wrong.