Pythian Blog: Technical Track | Database

Recent stories

Why your Cassandra cluster scales poorly

Apache Cassandra promises linear scalability and workload distribution, among many other features—and rightly so. ...

by Mario Tavares

13 min read

Interesting variations in outcome when cloning a CDB with a subset of PDBs in Oracle

Recently I was working on a client request where a CDB along with a subset of its PDBs had to be cloned to a new server ...

by Jure Bratina

11 min read

Oracle E-Business Suite

Slow Query in eBS AutoConfig with DB 19c

We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a particular SQL ...

by Timur Akhmadeev

11 min read

More stories

Security

Datascape Episode 55: The State of Database Security in 2022

Iscsiadm

Bugs with iscsi-initiator-utils*-6.2.0.878-5

Oracle

How to Clean up Trace and Audit Files for Multiple Homes

Oracle

Creating a Read-Only Account on Database with VPD or Label Security

Oracle

Five Best Practices for Setting Dispatchers on Shared Connections

Oracle

Select vs Assign – How To Assign PL/SQL Variables

Oracle

Automating Oracle Patching With an Ansible Module

Oracle

Oracle Database and 2FA Using Cisco Duo

Oracle

How to Run DBSAT 2.2.0 on Oracle Cloud PDB using Wallet

SQL Server

How to fix dbupgrade script issue when upgrading Oracle Database Standard Edition

SQL Server

How to Fix: The Selected Subscriber does not satisfy the minimum version compatibility

Oracle

How to remove grid 12.2 after an 18c upgrade

SQL Server

How to retrieve growth history for oracle tablespaces

SQL Server

Getting started with Oracle Database Backup Service in 2018

Oracle

Lightweight transactions in Cassandra

Oracle

Oracle Database 18c schema only accounts

Oracle

Automation, PowerShell and Word Templates - let the technician do tech

Oracle

Customizing pt-stalk to capture the diagnostics data you really need

DBA Lounge

Duplicate indexes in MySQL

Automation

Converting Hortonworks Sandbox to run on Hyper-V

Technical Track

Changes to DBCA patch application behaviour causes PDB cloning to fail

Oracle

Oracle upgrade failures due to METHOD_OPT and XDBCONFIG

MySQL

My First Experience Running SLOB - ORION vs SLOB - 2:0