Slow query to V$ views after DBRU Patching
One of our clients patched its EBS database 19.13 to DBRU 19.17 and faced an issue with one of the...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management | Sql
Leverage Snowflake Tagging to Empower Governance
As the amount of data organizations collects grows, managing that data becomes increasingly...
How to deploy a Cockroach DB Cluster in GCP – Part I
CockroachDB is a distributed SQL Database that has been gaining popularity in the last years...
Slow Query in eBS AutoConfig with DB 19c
We recently completed a few e eBS R12.2 database upgrade installations and noticed an issue with a...
Oracle Scheduler Job is Not Running as Expected After Bouncing Databases
One of our clients had issues with their scheduler jobs in DEV and PROD databases and all scheduler...
SQL Server Distributed Availability Group with Forwarder in Microsoft Azure
Architecture diagram To create a distributed availability group, you need two availability groups...
Google Recognizes Pythian’s Outstanding Data Management Work in 2020 with Inaugural Award
Love your data. It’s far more than our tagline here at Pythian—it’s truly in our DNA. That’s why...
Data preparation with dbt and BigQuery
Raw incoming data needs to go through a series of data preparation steps before it can be used for...
How To Rename Interval Partition with More Meaningful Name
When using interval partitioning, the database automatically creates partitions for a specified...
DML by Unique Index Supposedly Affecting Many Rows
This blog post is based on a real customer case, and illustrates how v$sql reports execution...
