Are you an engineer obsessed with P99 percentiles and high-performance, low-latency applications? Come share your most interesting approaches for solv...

Here’s a little PL/SQL function create_partition_high_value_func.sql that allows you to write SQL queries against data dictionary for partition maintenance automation and examination operations, by…

YouTube video by SQL and Database explained!

The Oxide Computer Company and friends; home of the Oxide and Friends podcast. | 4928 members

: Oxide says AMD’s Turin EPYCs are coming, switch revamp under review, more open hardware in the works

Here are two scripts for showing GV$SYSMETRIC_HISTORY contents in a simple tabular way: vstat.sql - show up to one hour of current history at 1-minute granularity from memory awr/dstat.sql - show…

SQL has evolved. Beyond the relational model. Discover it now.

Hey hey! We recently tripped over a ZFS data corruption bug–introduced over 18 years ago! Bryan and Adam discuss with members of the Oxide team as well as Matt Ahrens, the co-inventor of ZFS.In add...

Here’s part 3 of my xb.sql & xbi.sql article series that I started writing back in 2019 :-) Part 1 - Show and format execution plans by querying V$SQL_PLAN data directly Part 2 - Show plan line level…