demos

Various demonstration scripts

Wiki

The wiki lists all published reports from demonstrations.

Demonstrations

Filesystem Performance

Investigates the effects of O_SYNC and blocksize on I/O response time. Final report published here.

Filesystem Performance Sync

In progress. Will expand on the demonstration in Filesystem Performance by considering O_DIRECT and filesystem types.

High CPU and CDB Resource Plans

Demonstrates the effect of using CDB resource plans under 100% CPU load. Final report published here. The associated blog post is here.

Resource Manager Thruput

In progress. Investigates whether the use of Oracle Resource Manager plans improves the throughput under 100% CPU load. Preliminary reports have been published on Wiki page.

Select With Update

Investigates the use of SELECT ... FOR UPDATE SKIP LOCKED in processing a staging table with many concurrent clients. Published final report here.

Will follow up comments with an expanded demonstration.

V$SESSION Returning No Rows

Demonstrated the case of the V$SESSION view returning no rows. Final report published here.

Demonstration of Loading Database Bookshelf into XE Database

Demonstration of Loading Database Bookshelf into XE Database