GigaOm x Pythian: Realities and Risks of Enterprise AI
In a recent interview on the Business Disruptions in Tech podcast, Howard Holton and ...
Oracle E-Business Suite has been certified with Oracle Database 19c for over a year now. We've been seeing an uptick in ...
Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...
Background Oracle Database connectivity using multi-factor (MFA) or two-factor (2FA) authentication is rather simple to ...
Testing oracle grid infrastructure upgrades Editor’s Note: Because our bloggers have lots of useful tips, every now and ...

Introduction Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring ...
Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...
A couple of weeks ago a client of mine had a situation where a Data Guard (DG) ...
-->A couple of weeks ago a client of mine had a situation where a Data Guard (DG) switchover that should have taken five ...
The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, ...
-->The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, and got the following error: ...

Because incremental repairs can significantly reduce the time and IO cost of performing a repair, they can seem like a ...

Working with consulting clients is rewarding, interesting, and challenging. In discussion with some of my colleagues, ...
Editor's Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...
Here at Pythian we get a lot of exposure to new technologies and implementation strategies via the work we do ...
When working with clients on database migration, there are a range of options we help them assess and evaluate. These ...
In this post I'll describe a problem which occurs when creating and using a database service name which starts with the ...
I wanted to export 11.2 database schema and import it into a 19c database; creating the database in archive mode to ...
Heart disease covers a range of different conditions that could affect your heart. It is one of the most complex ...
The other day I was given the task of converting a single instance Oracle ...
-->The other day I was given the task of converting a single instance Oracle Enterprise Manager Management Service (OMS) ...
This past weekend I was doing a production grid infrastructure (GI) out-of-place ...
-->This past weekend I was doing a production grid infrastructure (GI) out-of-place patching (OOP) from 19.6 to 19.8 for a ...
In these challenging and ever-changing times, most organizations would welcome the opportunity to reduce overhead, ...

There are plenty of database migration options out there, and we love working with clients to help them assess and ...
While increasing the redo log file size for my production environment, I came across a requirement I’d like to share ...
Select vs Assign It isn’t unusual to see PL/SQL that contains select columns into variables from some_table This is ...
Introduction When the “wrong” index is used for a SQL query, it’s sometimes a struggle to coerce Oracle to use the ...
Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...
Managing diagnostic data across multiple systems with ADRCI Reviewing recurrent issues for database systems is ...
Simplifying log management with purgeLogs With a total of 33 directories for GI (Grid Infrastructure) and DB (database) ...
Editor’s Note: Because our bloggers have lots of useful tips, every now and then we bring forward a popular post from ...
DBCC CHECKIDENT example DBCC CHECKIDENT is used to check or change the value of an identity column in the specified ...
Context Oracle Service Bus 12.2 and onwards is available to download on Oracle Support. As you might expect, the new ...
I’m glad to get back to blog writing and, after a bit of a break, I’m starting with a brief post. We DBAs have probably ...