ASM (24) Oracle RAC (12) PostgreSQL (18) exadata (11) oracle (93)

 ASM (24)

ASM Bytes Read and Smart Scan
ASM Rebalance: Why is the avg By/Read equal to 1MB while the allocation unit is 4MB?
A closer look at ASM rebalance, Part III: Disks have been added and dropped (at the same time)
A closer look at ASM rebalance, Part II: Disks have been dropped
A closer look at ASM rebalance, Part I: Disks have been added
Are ASM rebalance and preferred read working together?
Simulate and Visualize the impact of the ASM preferred feature on the read IOPS and throughput
ASM performance metrics visualization: Use cases
Graphing ASM performance metrics
ASM free and usable space in case of Imbalanced Diskgroup
Main pages for exadata_metrics.pl and asm_metrics.pl
ASM metrics are a gold mine. Welcome to asm_metrics.pl, a new utility to extract and to manipulate them in real time
Find out the most physical IO consumers through ASM in real time
Flex ASM 12c (12.1): be careful to “invisible” I/O !
ASM I/O Statistics Utility V2
Flex ASM 12c (12.1) and Extended Rac: be careful to "unpreferred" read !
Build your own Flex ASM 12c lab using Virtual Box
Retrieve and visualize ASM Disk Group Usage per database with R
ASM Preferred Read: Collect performance metrics thanks to my amsiostat utility and SLOB 2
ASM I/O Statistics Utility: Update for Exadata
Exadata: Storage Cells IO performance metrics and IO distribution with DB servers
ASM Preferred Read: Collect performance metrics
ASM I/O Statistics Utility
ASM Asynchronous or Synchronous I/O

 Oracle RAC (12)

In-Memory Instance distribution with RAC databases: Impact of the parallel_instance_group parameter
FAN callouts for In-Memory Instance distribution with RAC, PDB and preferred/available service
In-Memory Instance distribution with RAC and Multitenant Environment
In-Memory Instance distribution with RAC databases: I want at least one instance that contains all the data
Watch out for optimizer_adaptive_features as It may have a huge negative impact
Issue installing the 11gR2 database software after the 12.1.0.2 clusterware setup
Modify the Private Network Information in Oracle Clusterware with HAIP in place
RAC Attack at Oracle OpenWorld 2013: Don't be afraid !
Flex ASM 12c (12.1) and Extended Rac: be careful to "unpreferred" read !
TAF is not working on Rac One Node in case of node failure ? Well it depends
Rac One Node : Create preferred node
Rac One Node : Avoid automatic database relocation

 PostgreSQL (18)

Postgres 17 highlight: Logical replication slots synchronization
"Rusting" a new Postgres C extension that records subtransactions counters
Postgres 16 highlight: Logical decoding on standby
PostgreSQL direct path insert: Introduction
Compare a PostgreSQL block from memory and from file
Report long recovery conflict wait times with PostgreSQL 14
Flipping a bit one by one in a PostgreSQL block looking for a checksum
Retrieve PostgreSQL variable-length storage information thanks to pageinspect
Get toast chunk_id from the user table tuples or from the toast index thanks to pageinspect
Sampling pg_stat_statements based on the active sessions and their associated queryid
Active Session History in PostgreSQL: blocker and wait chain
PostgreSQL Active Session History extension testing with Docker
PostgreSQL Active Session History extension is now publicly available
PostgreSQL Active Session History (ash): welcome to the pg_active_session_history view (part of the pgsentinel extension)
Measure the impact of DRBD on your PostgreSQL database thanks to pgio (the SLOB method for PostgreSQL)
Visualize PostgreSQL index file with pgdfv
Welcome to pgdfv: PostgreSQL data file visualizer
SystemTap for PostgreSQL Toolkit

 exadata (11)

Exadata cell metrics: Join the metrics and their descriptions on the fly
Extract Exadata cells historical metrics in CSV format
exadata_metrics.pl: New feature to collect real-time metrics extracted from cumulative metrics
Exadata Cell metrics: collectionTime attribute, something that matters
Exadata real-time metrics extracted from cumulative metrics: Part II
Exadata: Storage Cells IO performance metrics and IO distribution with DB servers
Exadata : Direct path read and smart scan
Real-Time Wait Events and Statistics related to Exadata : Part II
Real-Time segments statistics
Real-Time Wait Events and Statistics related to Exadata
Exadata real-time metrics extracted from cumulative metrics

 oracle (93)

demystifying and wrapping the oracle cloud APIs with Python
SystemTap and Oracle RDBMS: I/O and Network Traffic
SystemTap and Oracle RDBMS: Page Faults
New member of the OakTable Network
SystemTap and Oracle RDBMS: Time in Various States, VFS I/O and Block I/O
SystemTap and Oracle RDBMS: Aggregate by database
Running 12.1.0.2 Oracle Database on Docker
Push oracle audit data into Elasticsearch and analyze/visualize it with Kibana
Graphing Exadata cells metrics with Telegraf, InfluxDB and Grafana
Oracle Unified Directory and user security: quick demo
Push the oracle alert.log and listener.log into Elasticsearch and analyze/visualize their content with Kibana
Graphing Oracle performance metrics with Telegraf, InfluxDB and Grafana
Monitor the dNFS activity as of 11.2.0.4
Hyper-threading: measure its impact during SLOB runs thanks to numactl and turbostat
Exadata cell metrics: Join the metrics and their descriptions on the fly
Extract Exadata cells historical metrics in CSV format
12c Application Continuity with Data Guard in action
Direct Path Read and "enq: KO - fast object checkpoint"
ASM Bytes Read and Smart Scan
In-Memory Instance distribution with RAC databases: Impact of the parallel_instance_group parameter
binding (with processor_group_name) versus caging: Facts, Observations and Customer cases.
processor_group_name and SGA distribution across NUMA nodes
Modify on the fly the cgroup properties linked to the processor_group_name parameter
cpu binding (processor_group_name) vs Instance caging comparison during LIO pressure
Measure the impact of remote versus local NUMA node access thanks to processor_group_name
FAN callouts for In-Memory Instance distribution with RAC, PDB and preferred/available service
In-Memory Instance distribution with RAC and Multitenant Environment
In-Memory Instance distribution with RAC databases: I want at least one instance that contains all the data
Watch out for optimizer_adaptive_features as It may have a huge negative impact
Issue installing the 11gR2 database software after the 12.1.0.2 clusterware setup
ASM Rebalance: Why is the avg By/Read equal to 1MB while the allocation unit is 4MB?
A closer look at ASM rebalance, Part III: Disks have been added and dropped (at the same time)
A closer look at ASM rebalance, Part II: Disks have been dropped
A closer look at ASM rebalance, Part I: Disks have been added
Are ASM rebalance and preferred read working together?
Simulate and Visualize the impact of the ASM preferred feature on the read IOPS and throughput
ASM performance metrics visualization: Use cases
Graphing ASM performance metrics
Visualize the IO source thanks to Tableau and AWR
db_io*metrics family
Report database physical IO activity per database function (LGWR, DBWR, Smart Scan...) and IO type in real time
Report database physical IO activity per IO type and oracle files type in real time
Welcome to db_io_metrics, a new utility to display database physical IO metrics in real time
SLOB Logical I/O testing: Check if your benchmark delivers the maximum
ASM free and usable space in case of Imbalanced Diskgroup
Modify the Private Network Information in Oracle Clusterware with HAIP in place
Recovering after the loss of Redo Log files thanks to the file descriptor
Main pages for exadata_metrics.pl and asm_metrics.pl
exadata_metrics.pl: New feature to collect real-time metrics extracted from cumulative metrics
ASM metrics are a gold mine. Welcome to asm_metrics.pl, a new utility to extract and to manipulate them in real time
Flush a single SQL statement and capture a 10053 trace for it
RAC Attack at Oracle OpenWorld 2013: Don't be afraid !
Exadata Cell metrics: collectionTime attribute, something that matters
Find out the most physical IO consumers through ASM in real time
Book Review: Oracle Data Guard 11gR2 Administration Beginner's Guide
Flex ASM 12c (12.1): be careful to “invisible” I/O !
ASM I/O Statistics Utility V2
Flex ASM 12c (12.1) and Extended Rac: be careful to "unpreferred" read !
Build your own Flex ASM 12c lab using Virtual Box
Monitor the database activity in real time with R
Retrieve and visualize system statistics in real time with R
Retrieve and visualize in real time wait events metrics with R
Retrieve and visualize ASM Disk Group Usage per database with R
TAF is not working on Rac One Node in case of node failure ? Well it depends
ASM Preferred Read: Collect performance metrics thanks to my amsiostat utility and SLOB 2
Diagnose Adaptive Cursor Sharing (ACS) per execution for non monitored sql
Diagnose Adaptive Cursor Sharing (ACS) per execution in 11.2
Bind variable peeking: Retrieve peeked and passed values per execution in oracle 11.2
Drill down to sql_id execution details in ASH
Retrieve and visualize system statistics metrics from AWR with R
Retrieve and visualize wait events metrics from AWR with R
Link huge PGA or TEMP consumption to sql_id over a period of time
ASM I/O Statistics Utility: Update for Exadata
Exadata real-time metrics extracted from cumulative metrics: Part II
Exadata: Storage Cells IO performance metrics and IO distribution with DB servers
ASM Preferred Read: Collect performance metrics
ASM I/O Statistics Utility
Real-Time database utilities grouped into a single script
Exadata : Direct path read and smart scan
ASM Asynchronous or Synchronous I/O
Perl Scripts Shared Directory
Real-Time Wait Events and Statistics related to Exadata : Part II
Real-Time library cache monitoring
Rac One Node : Create preferred node
Rac One Node : Avoid automatic database relocation
Real-Time enqueue statistics
Real-Time SGA component monitoring
Real-Time segments statistics
Real-Time Wait Events and Statistics related to Exadata
Real-Time CPU utilization per oracle database
Exadata real-time metrics extracted from cumulative metrics
Measure oracle real-time I/O performance
Link sql_id and oracle stats