Blog | Pythian (41)

Oracle E-Business Suite

EBS DBA: R12.1.2 Another Step for Automated Vanilla EBS Cloning

As many of you know a cloning is one of the most DBA time consuming operations. For the first few times an Apps DBA ...

Oracle

What's in your Exadata Smart Flash Cache?

One of the exclusive Exadata features is the Smart Flash Cache (

Oracle

Updating ASMLIB Driver Using "update-driver"

It is a controversial question whether to use ASMLIB for managing disks for an ASM instance, but I don't want to ...

Oracle

Secrets of Oracle's Automatic Degree of Parallelism

Background:

Automatic degree of parallelism, or Auto DOP, is a new feature in 11gR2 that promises to help ...

Oracle

Oracle Database Appliance: Storage Performance -- Part 1

Today I want to show what kind of IO performance we can get from Oracle Database Appliance (ODA). In this part, I ...

MySQL

Why are your indexes larger than your actual data?

It’s a common but startling sight for any DBA: you look at your database statistics and realize your indexes are ...

MySQL

InnoDB error: Total number of locks exceeds the lock table size

Recently, one of our customers had a problem with one of their replication slaves where a sql statement gave an ...

Microsoft SQL Server

Using UNPIVOT with CDC Functions to get Updated Columns List

Microsoft introduced Change Data Capture (CDC) technology in SQL Server 2008. This technology ...

MySQL

How and why tmp_table_size and max_heap_table_size are bounded.

Overview

In some cases, MySQL creates internal temporary tables while processing queries. On the base of the ...

Oracle E-Business Suite

EBS DBA: WF Mailer Override Address and Cloning: How to

I just recently faced an issue regarding how to automate the Workflow Mailer override address for ...

Oracle

Physical Disk, Cell Disk, Grid Disk, and ASM Disk in Exadata

Exadata is the Ferrari of the technology world. It’s ...

Oracle

DBA_SCHEDULER_RUNNING_JOBS, where have you been?!

Backstory

...

Oracle

Emergency Recovery or RMAN DUPLICATE Rerun Just Works!

Working as a DBA often means facing high-pressure ...

Oracle

Unofficial Oracle Database Appliance FAQ

Introduction

I’ve started putting together ...

Oracle

Data Pump Monitoring

During database maintenance, one of the most critical ...

MySQL

How I Find MySQL Fragmentation

Background

Sarah Novotny recently posted ...

Oracle

Chopt Utility

Introduction

There is a new tool came with ...

Oracle

CheckSystemSpace ignorance

Context

Every installation is unique. It can ...

MySQL

Rounding Errors in MYSQL with DECIMAL Type

It

Oracle

AWR Extract and Load

Introduction

In preparing my presentation for ...

Oracle

Swappiness

Swappiness, as the name suggests, affects the swapping ...

Redo Transport Compression

I was co-presenting recently at Sydney Oracle ...

MySQL

Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Recently I faced an interesting challenge: modify over ...

Oracle

Exadata smart scans and the flash cache

Context

One of the key features of Exadata V2 ...

Oracle

RDBMS Online Patching

If you support Oracle RDBMS 11.2.0.2 and want to zero ...

ORA-00214 and Control File Mismatch

One of the many reasons a clean Oracle database shutdown should always be a ‘must have’ ...

Oracle

Comparing Oracle Database Appliance and Exadata

Introduction

Oracle Database Appliance (ODA) ...

Oracle

Viewing RMAN jobs status and output

Checking RMAN backup status via database views

Yesterday I was ...

Oracle

Encryption RMAN Backup

There are 2 configurable items related with RMAN ...

MySQL

How to Run a Streaming Backup with innobackupex

On many of our clients, we have a need to run

Featured News

Pythian Recognized as a Top AI & Data Consulting Firm for 2026

Pythian Marketing Published : May 21, 2026 1 min read

Pythian wins Silver in the UKOUG Data Integration Partner of the Year Awards 2026

Pythian Recognized as Silver Winner in UKOUG Data Integration Partner of the Year Awards 2026

Pythian Marketing Published : May 21, 2026 1 min read

Pythian Leaders Recognized on CRN’s 2026 Women of the Channel List

Pythian News Published : May 5, 2026 1 min read

Pythian and Three of Its Leaders Named Finalists for the 2025 CRN Women of the Year Awards

Pythian News Published : Sep 24, 2025 2 min read

Pythian India Earns “Great Place to Work” Certification for Fourth Consecutive Year

Pythian News Published : Oct 8, 2025 3 min read

Pythian’s Vanessa Simmons and Donna Williston Again Named to CRN’s 2025 Women of the Channel List

Pythian News Published : May 12, 2025 1 min read

Pythian Positioned as Oracle Database @ Google Cloud Leader with Acquisition of Rittman Mead

Pythian News Published : Apr 21, 2025 3 min read

Pythian Doubles Down on AI-Readiness, Expanding AI Practice with Valuable Services and Expertise

Pythian News Published : Apr 15, 2025 2 min read

Pythian Launches Agentspace QuickStart

Pythian News Published : Apr 8, 2025 3 min read

Pythian Wins 2025 Google Cloud Databases Partner of the Year for North America

Pythian News Published : Apr 4, 2025 3 min read

Pythian and GigaOm Announce AI Partnership

Pythian News Published : Apr 1, 2025 2 min read

Pythian Named Top Employer in Canada's National Capital Region for 2025

Pythian News Published : Mar 7, 2025 2 min read

Pythian Welcomes Shawn Gandhi as Senior Vice President, Customer Engineering, and Country Managing Director for Canada

Pythian News Published : Jan 23, 2025 1 min read

Pythian Announces New Oracle Database@Google Cloud Migration Services

Pythian News Published : Sep 5, 2024 2 min read

Pythian India Earns “Great Place to Work” Certification for Third Consecutive Year

Pythian News Published : Aug 12, 2024 1 min read

Pythian Recognized on CRN’s 2024 Solution Provider 500 List and DBTA’s 100 Companies That Matter Most in Data for 2024

Pythian News Published : Jun 25, 2024 2 min read

Pythian Welcomes Brooks Borcherding as Chief Executive Officer

Pythian News Published : Jun 11, 2024 2 min read

Pythian’s Vanessa Simmons and Donna Williston Honored by CRN on 2024 Women of the Channel Lists

Pythian News Published : May 13, 2024 2 min read

Pythian Recognized as a Top Employer in Canada’s National Capital Region in 2024

Pythian Marketing Published : Feb 20, 2024 2 min read