Search

Med-o-Mash
Med-o-Mash @medmash_ ·
Oracle Database Buffer Pool Parameters -- DB_CACHE_SIZE: set the DEFAULT buffer cache pool size. DB_KEEP_CACHE_SIZE: set the KEEP pool size DB_RECYCLE_CACHE_SIZE: set the RECYCLE pool size DB_FLASH_CACHE_SIZE: set the size of flash cache #OracleDB #DatabaseTuning #DBA
1
7
Yuan Oracle ACE
Yuan Oracle ACE @YuanOracle ·
The query below presents execution patterns of 5 top SQL statements, grouped by the day of the week for the last week. byte-way.com/2025/05/26/sql… #Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba #OracleDatabase #OracleASH
SQL Statements Execution Patterns

The query below presents execution patterns of 5 top SQL statements, grouped by the day of the week for the last week. SELECT TRIM(TO_CHAR(sample_time, ‘DAY’)) AS sample_day, SUM(CASE W…

From byte-way.com
1
108
Yuan Oracle ACE
Yuan Oracle ACE @YuanOracle ·
Mapping Child SQL to Parent PL/SQL in Oracle AWR Reports byte-way.com/2025/05/22/map… #Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba #OracleDatabase #OracleASH
Mapping Child SQL to Parent PL/SQL in Oracle AWR Reports

In the “SQL statistics” section of an Oracle AWR report, both SQL and PL/SQL are listed. This results in the double-counting SQL statements executed within PL/SQL blocks. For example, a resource-in…

From byte-way.com
3
109
Yuan Oracle ACE
Yuan Oracle ACE @YuanOracle ·
Understanding ASH Data Retention in Oracle Database byte-way.com/2025/05/21/und… #Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba #OracleDatabase #OracleASH
Understanding ASH Data Retention in Oracle Database

Oracle’s Active Session History (ASH) is a powerful performance diagnostic tool that enables real-time and historical analysis of session-level activity. However, one common question DBAs and perfo…

From byte-way.com
1
55
Yuan Oracle ACE
Yuan Oracle ACE @YuanOracle ·
How to Avoid Unlicensed Use of AWR/ASH in Oracle byte-way.com/2025/05/20/how… #Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba #OracleDatabase #OracleASH
How to Avoid Unlicensed Use of AWR/ASH in Oracle

Without an Oracle Diagnostics Pack license, using AWR and ASH is illegal, even with an Enterprise Edition license. To ensure compliance with Oracle’s licensing requirements and prevent avoid uninte…

From byte-way.com
46
Yuan Oracle ACE
Yuan Oracle ACE @YuanOracle ·
Controlling AWR and ASH Access with CONTROL_MANAGEMENT_PACK_ACCESS byte-way.com/2025/05/20/con… #Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba #OracleDatabase #OracleASH
Controlling AWR and ASH Access with CONTROL_MANAGEMENT_PACK_ACCESS

It’s important to recognize that a license for Oracle Database Enterprise Edition does not automatically grant access to Automatic Workload Repository (AWR) and Active Session History (ASH). These …

From byte-way.com
38
Yuan Oracle ACE
Yuan Oracle ACE @YuanOracle ·
(Part 2/3) Identifying Transient Performance Issues via SQL Runtime Deduction from ASH Data Identifying Culprit SQLs for Transient Slowdowns #Oracle #OracleAWR, #DatabaseTuning, #OracleDBA #OracleACE #Database #DatabasePerformance #databasedba #dba #OracleDatabase #OracleASH Identifying Transient Performance Issues via SQL Runtime Deduction from ASH Data (Part 2/3) – Yuan Yao, An Oracle ACE's Blog byte-way.com/2025/05/14/ide…
Identifying Transient Performance Issues via SQL Runtime Deduction from ASH Data (Part 2/3)

Deducing individual runtime of specific SQL statements using ASH Identifying culprit SQL for transient slowdowns. Finding outlier executions for a specific SQL Identifying Culprit SQL for Transient…

From byte-way.com
2
84