Introduction A set of reporting and analytic queries against a large, frequently scanned table were taking longer than expected, with a large share of the response time going into repeated buffer cache…
Read MoreStop scrolling through raw JSON lines. Master command-line log querying using jq pipelines to diagnose errors, isolate slow queries, and monitor replication events instantly. Starting in version 4.4, MongoDB moved…
Read MoreIntroduction: Transparent Data Encryption (TDE) has been part of the Oracle DBA toolkit for years – encrypt the datafiles, manage a wallet, move on. But once a database moves to OCI,…
Read MoreIntroduction: Migrating Oracle E-Business Suite from on-prem to OCI is often sold as a lift and shift and technically, a lot of it is. The application code, patching model, AD…
Read MoreIntroduction/ Issue: Occasionally an item is assigned to the wrong category name in the inventory catalog, or a category needs to be renamed after go-live. There was no simple, supported…
Read MoreIntroduction/ Issue: Our finance operations team had no easy way to see how AR invoices were being created across the day. When a customer complained about a delayed invoice, or…
Read MoreIntroduction/ Issue: One of the most common challenges organizations face when migrating databases to Azure is selecting the appropriate Azure SQL Database service tier. Many teams either overprovision resources, leading…
Read MoreIntroduction/ Issue: Database snapshots and backups are often mistaken for the same feature because both capture the state of a database at a specific point in time. However, they serve…
Read MoreIntroduction During a recent Oracle E-Business Suite (EBS) maintenance activity, we needed to re-enable a custom concurrent program that had been disabled for a long time. Although the concurrent program…
Read MoreIntroduction When attempting to open a plugged-in pluggable database (PDB) that contains encrypted tablespaces, the following error is raised: “TEST(5):ALTER PLUGGABLE DATABASE OPEN” detects that an encrypted tablespace has been restored but…
Read More