Adding DML Parallelization to Oracle Jobs

code on screen laptop

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,…

Read More >

Restoring a Dropped Oracle PDB Without a CDB Backup

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…

Read More >

Automatic Generation of Daily AWR Report

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…

Read More >

Using El Carro Operator on AWS

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…

Read More >

Part One: Deploying High Available Applications in Oracle Cloud Infrastructure: Preparing Your Environment

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…

Read More >

How to Use EM CLI to Verify Data Guard Configurations

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…

Read More >

Two Cases of Troubleshooting with psn

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…

Read More >

Understanding the Implications of Creating a New PDB Using CREATE_FILE_DEST

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…

Read More >

Pythian’s New Single Sign-on (SSO) Solution for Oracle E-Business Suite (EBS)—Part One

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…

Read More >

Oracle Cloud Infrastructure (OCI) Costs—Part One: Budgets and Forecasting

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)….

Read More >
Page 5 of 33« First Page...34567...10...Last Page »