Oracle Database Migrated to Cloud Starts Experiencing "log file sync" Waits
A client was moving an Oracle 11.2.0.4 database from their data center to one of the major cloud...
A client was moving an Oracle 11.2.0.4 database from their data center to one of the major cloud...
A client asked us to verify why an INSERT AS SELECT statement, which was part of a scheduled ETL...
Recently I was working on a client request where a CDB along with a subset of its PDBs had to be...
This blog post is about a scenario where a combination of a logon trigger performing DML operations...
This is a blog post about an issue that can occur during a database upgrade and produces a...
This post is about a Statspack anomaly I discovered while analyzing execution trends of a...
This blog post is based on a real customer case, and illustrates how v$sql reports execution...
In this post I'll describe a problem which occurs when creating and using a database service name...
In this post, I'll present the statspack_top_sqls.sql script, which returns SQL performance...
There are various ways that we can approach the analysis of a past database performance problem....