한국어
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, holder of more than 20 Oracle certification, author of the book MySQL 8.0 Operations and Optimization, blog: http://byte-way.com

Yuan Oracle ACE♠️

@YuanOracle

Oracle ACE, holder of more than 20 Oracle certification, author of the book MySQL 8.0 Operations and Optimization, blog: http://byte-way.com

195게시물 299팔로워 445팔로우 중
내가 좋아할 만한 콘텐츠
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
24 시간

China set the start date of its rare earth export controls to December 1, likely to gain leverage ahead of the APEC summit in South Korea. Trump, however, “mistakenly” claimed China’s ban begins November 1, a month earlier—clearly to apply early pressure before talks.

YuanOracle's tweet image. China set the start date of its rare earth export controls to December 1, likely to gain leverage ahead of the APEC summit in South Korea. Trump, however, “mistakenly” claimed China’s ban begins November 1, a month earlier—clearly to apply early pressure before talks.
YuanOracle's tweet image. China set the start date of its rare earth export controls to December 1, likely to gain leverage ahead of the APEC summit in South Korea. Trump, however, “mistakenly” claimed China’s ban begins November 1, a month earlier—clearly to apply early pressure before talks.
0
0
0
1
80
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 10. 10.

In Oracle AWR report, the Wait Classes by Total Wait Time section shows %DB time = 122.2%. The extra ~22%? That’s background events. Check the Time Model Statistics: background elapsed time ÷ DB time ≈ 22% — perfectly matches the gap. Neat validation, right? 🔍 #Oracle…

YuanOracle's tweet image. In Oracle AWR report, the Wait Classes by Total Wait Time section shows %DB time = 122.2%. The extra ~22%? That’s background events. Check the Time Model Statistics: background elapsed time ÷ DB time ≈ 22% — perfectly matches the gap. Neat validation, right? 🔍 #Oracle…
YuanOracle's tweet image. In Oracle AWR report, the Wait Classes by Total Wait Time section shows %DB time = 122.2%. The extra ~22%? That’s background events. Check the Time Model Statistics: background elapsed time ÷ DB time ≈ 22% — perfectly matches the gap. Neat validation, right? 🔍 #Oracle…
0
1
4
1
92
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 10. 8.

Misconfigured control_file_record_keep_time=365 bloated the control file → RMAN vs LGWR contention on control file → log file sync spiked → RAC flooded with gc waits. #oracle #oracleace #oracleaw

YuanOracle's tweet image. Misconfigured control_file_record_keep_time=365 bloated the control file → RMAN vs LGWR contention on control file → log file sync spiked → RAC flooded with gc waits. #oracle #oracleace #oracleaw
YuanOracle's tweet image. Misconfigured control_file_record_keep_time=365 bloated the control file → RMAN vs LGWR contention on control file → log file sync spiked → RAC flooded with gc waits. #oracle #oracleace #oracleaw
0
2
6
1
101
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 10. 1.

Ever seen a database look insanely busy? This one was only a bug—triggered by a DB link doing nonstop exports right across the AWR snapshot window. #oracle #OracleACE #oracleawr

YuanOracle's tweet image. Ever seen a database look insanely busy? This one was only a bug—triggered by a DB link doing nonstop exports right across the AWR snapshot window. #oracle #OracleACE #oracleawr
0
1
4
1
190
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 9. 29.

Seeing a high "Rollbacks" value in an AWR Load Profile? Don’t panic—many are just superfluous. Connection pool resets, framework cleanups, or error-handling scripts often trigger rollbacks that inflate counters without real undo work. For true rollback impact, check "rollback…

YuanOracle's tweet image. Seeing a high "Rollbacks" value in an AWR Load Profile? Don’t panic—many are just superfluous. Connection pool resets, framework cleanups, or error-handling scripts often trigger rollbacks that inflate counters without real undo work. For true rollback impact, check "rollback…
0
0
2
0
62
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 9. 26.

parses 136/s + executes 226/s = 362, but user calls hit 4,133/s. The gap (≈3,771) comes from fetches—big result sets exceed arraysize, forcing multiple fetches. SQL*Net roundtrips confirm (≈3,968/s). #oracle #oracleace #awr

YuanOracle's tweet image. parses 136/s + executes 226/s = 362, but user calls hit 4,133/s. The gap (≈3,771) comes from fetches—big result sets exceed arraysize, forcing multiple fetches. SQL*Net roundtrips confirm (≈3,968/s). #oracle #oracleace #awr
0
2
3
2
128
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 9. 25.

Oracle AWR report tutorial series #oracle #OracleACE #awr

YuanOracle's tweet image. Oracle AWR report tutorial series #oracle #OracleACE #awr
0
0
3
1
55
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 9. 24.

Oracle AWR report tutorial series, the session count is a point-in-time measurement #oracle #oracleACE #awr

YuanOracle's tweet image. Oracle AWR report tutorial series, the session count is a point-in-time measurement #oracle #oracleACE #awr
YuanOracle's tweet image. Oracle AWR report tutorial series, the session count is a point-in-time measurement #oracle #oracleACE #awr
0
1
2
1
94
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 9. 23.

The reason execute plus parse is way higher than user calls is that the application is calling many PL/SQL procedures. One call to a PL/SQL procedure can trigger lots of parses, executes, and fetches under the hood. You can actually back this up by looking at the “recursive…

YuanOracle's tweet image. The reason execute plus parse is way higher than user calls is that the application is calling many PL/SQL procedures. One call to a PL/SQL procedure can trigger lots of parses, executes, and fetches under the hood. You can actually back this up by looking at the “recursive…
0
0
3
0
56
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 9. 22.

How to read Oracle AWR report--DB Time #Oracle #AWR #DBA

YuanOracle's tweet image. How to read Oracle AWR report--DB Time #Oracle #AWR #DBA
0
1
4
0
153
YuanOracle's profile picture.
Yuan Oracle ACE♠️
@YuanOracle
. 9. 22.

the simplest way to log into MySQL without typing a password #MySQL

0
0
0
0
54

United States 트렌드

내가 좋아할 만한 콘텐츠

Something went wrong.


Something went wrong.