Yuan Oracle ACE
@YuanOracle
Followers
322
Following
601
Media
105
Statuses
261
Oracle ACE, 20+ Oracle certifications. Sharing AWR, ASH and SQL tuning insights.
Joined March 2019
While stating that most IT professionals read CPU metrics wrong is a bold claim, it is not an exaggeration. https://t.co/CY0snG0zbe
#Oracle #OracleACE #CPU
0
0
1
How can a system be 90% idle yet still be starving for CPU? https://t.co/CZdURazTCe via @YouTube #OracleACE #Oracle #MySQL
0
1
4
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
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
Oracle AWR Case Study: An Atypcal “buffer busy wait" https://t.co/WKauSWXWPr via @YouTube #Oracle #OracleACE #AWR
0
2
6
Script: Evaluating Storage Performance by AWR Snapshot Raw Data https://t.co/Ecs5ZHrifM
#Oracle #OracleACE #OracleAWR
byte-way.com
As a DBA, having a clear understanding of your storage performance is essential to correctly judge overall database behavior. However, in many enterprises, DBAs do not have OS-level access, so they…
0
2
3
Non-cached sequence was run 119,001 times, dragged down performance.
0
2
5
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
Oracle AWR Case Study: Diagnosing 'enq: TX - row lock contention' https://t.co/5l4iipbqAM
#Oracle #OracleACE #AWR
byte-way.com
In a busy and healthy database environment, it is unavoidable that multiple sessions will attempt to modify the same row or set of rows simultaneously. This leads to situations where one session mu…
0
0
3
Oracle AWR Case Study: Slow Standby Database Dragging Down the Primary https://t.co/SM5DnAiJfn via @YouTube #Oracle #OracleACE #AWR
0
1
5
How Oracle Calculates the Number of Sessions in the AWR Report https://t.co/ooGwZIx5GZ
#Oracle #OracleACE #AWR
byte-way.com
At the top of every Oracle AWR report, there’s an important metric called “Sessions”, which represents the number of sessions at the time each snapshot (Snap ID) is being taken. T…
0
1
6
Oracle AWR Case Study: Slow Standby Database Dragging down the Primary https://t.co/LUIP3rowNa
#Oracle #OracleACE #AWR
byte-way.com
One of my clients from a hospital recently complained about slow performance in their Oracle database and sent me the AWR report for analysis. In this post, I’ll walk through my investigation and t…
0
1
4
Oracle AWR Case Study: Pinpointing When the Execution Plan Flip Occurred https://t.co/FhklMEIqBc via @YouTube #Oracle #OracleACE #AWR
0
2
6
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
Interpreting "SQL ordered by Physical Reads (UnOptimized)" https://t.co/7byxDapgkc
#Oracle #OracleACE #AWR
byte-way.com
In the “SQL Statistics” section of an Oracle AWR report, the list titled “SQL ordered by Physical Reads (UnOptimized)” presents the top SQLs in term of unoptimzied read requ…
0
0
7
0
1
12