Oracle just released a patch which allows you to use the database flash cache on Oracle Enterprise Linux even if you don’t have exadata storage. …
View More Using the Oracle 11GR2 database flash cache
Category: performance
Oracle Manageability Monitor Process (MMON) Background Process
Oracle Manageability Monitor Process (MMON) Background Process. Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis…
View More Oracle Manageability Monitor Process (MMON) Background Process
What is the usecase of dev shm
/dev/shm is a temporary file storage filesystem (see tmpfs) that uses RAM for the storage. It can function as shared memory that facilitates IPC. It is a…
View More What is the usecase of dev shm
How much memory is truly used by my Oracle instance?
There are many posts about the amount of memory that is taken by the Oracle database executables and the database SGA and PGA. The reason…
View More How much memory is truly used by my Oracle instance?
How to trace SQL sessions to identify Oracle Database bottlenecks
Want your database to run faster? While common tuning techniques can prove quite helpful in resolving many performance issues, they donโt show the details of all the…
View More How to trace SQL sessions to identify Oracle Database bottlenecks
Oracle COMPATIBLE VS OPTIMIZER_FEATURES_ENABLE
COMPATIBLE PARAMETER Understanding the COMPATIBLE Initialization ParameterIn Oracle Database 19c, when the COMPATIBLE initialization parameter is not set in your parameter file, the COMPATIBLE parameter…
View More Oracle COMPATIBLE VS OPTIMIZER_FEATURES_ENABLE
MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET
The memory structures that must be managed are the system global area (SGA) and the instance program global area (instance PGA). Oracle Database supports various…
View More MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET
Oracle SQL profile and baselines
This post highlights the differences between SQL profile and baselines in Oracleยฎ and explains how it works when tuning a query. Optimizer, profile, and baseline…
View More Oracle SQL profile and baselines
Materialized View Strategies Using PostgreSQL
Queries returning aggregate, summary, and computed data are frequently used in application development. Sometimes these queries are not fast enough. Caching query results using Memcached…
View More Materialized View Strategies Using PostgreSQL
Performance Tuning Queries in PostgreSQL
Database performance tuning: developers usually either love it or loathe it. I happen to be one that enjoys it and want to share some of…
View More Performance Tuning Queries in PostgreSQL