When investigating why an Oracle job is taking a long time to execute, normally the DBA will identify the DML instructions or select queries running longer and different approaches might be used to improve the performance, e.g., create new indexes,…

Background I ran into a situation where we needed to restore just one dropped (and recreated) pluggable database (PDB) in an Oracle 19c Container Database (CDB), but we did not have any backups for CDB$ROOT, PDB$SEED, etc. Our only backup…

I have recently received a requirement to provide a daily automatic AWR report, and it should be delivered to the DBA team’s inbox. It looks like an interesting requirement, so I completed this using my test database first, having the…

Introduction Google recently released a Kubernetes operator for Oracle, El Carro. The project includes good examples of how it works on GCP and on your local computer (using minikube). Given it is a portable implementation, we wanted to give it…

This is Part One in a five-part series that covers the details around deploying a high available setup of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure resources exclusively.   Overview This series will show how you can use Oracle…

EM CLI (Enterprise Manager Command Line Interface) allows users to access Enterprise Manager functionality from the operating system instead of from a browser. Why would you use EM CLI instead of a browser? It’s more efficient to execute commands from…

No, it’s not the PlayStation Network! Linux Process Snapper — pSnapper, or psn — is an open source tool written by Tanel Poder. Tanel provides a number of great examples on how to use psn and even a few videos…

qOverview When creating a new pluggable database, or PDB, you can optionally include the CREATE_FILE_DEST clause. Here’s an example: create pluggable database PDB1 admin user admin identified by “************” create_file_dest = ‘+DATA_DG’;   The value provided can be an ASM…

Our mission at Pythian is to help you Love Your Data. Because security is a crucial part of managing your data, we’re pleased to tell you about the identity management (IdM) solution we’ve developed to make it easier for Oracle…

Cost is a crucial part of selecting a cloud service provider. It’s important to understand the capabilities of different providers to maintain control of your costs. This blog post assumes the reader is familiar with OCI CLI (Command Line Interface)….