-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Actions Expresses Priorities
Managing large volumes of Adhoc database export files across environments can quickly become a storage nightmare. As part of my… READ MORE
I connected to a local Oracle database, explored schemas and tables, inspected the HR.EMPLOYEES table (columns and indexes), examined a… READ MORE
From Traditional DBA -> Cloud DBA –> Vibe DBA(AI DBA): Next Evolution Begins, for years, the role of the Database… READ MORE
Case-insensitive search is one of those features that Oracle users often underestimate — until they migrate from SQL Server or… READ MORE
Recently, I encountered a scenario with an Oracle ExaCS database where automatic and manual backups consistently failed. [STATE -> Failure[ACTION… READ MORE
Recently, at a customer site running Oracle 18c (12.2.0.2), we observed a baffling behavior: certain queries that worked fine when… READ MORE
Overview This guide provides a script to configure the Oracle environment for both Container Databases (CDB) and Non-Container Databases (Non-CDB)… READ MORE
Are You Missing Your PDBs After ExaCS Patching or OCPU Scaling? Picture this: you’ve just finished patching your shiny Oracle… READ MORE
LOBs (Large Objects) are often the silent space hogs in Oracle databases — especially when poorly managed or not regularly… READ MORE
The default retention period in EM Cloud Control for closed alerts is 180 days, You can modify this from inside… READ MORE
In Oracle Enterprise Manager (OEM), database administrators often need to monitor and manage user accounts. These accounts can accumulate over… READ MORE
When working with databases, efficiency is key to ensuring fast and reliable data retrieval. In Oracle databases, the choice of… READ MORE
If your customers shared across different Oracle container databases and you want to charge them based on they Utilizations then… READ MORE
Overview Relocating a Pluggable Database (PDB) allows database administrators to migrate databases across different availability domains (ADs), regions, or container… READ MORE
When dealing with complex Oracle queries, the optimizer sometimes prefers a full table scan, which may not be optimal for… READ MORE
Oracle 19.18 Query Fetching Issues: Unlocking Complete Results with Optimizer Hints In Oracle 19.18, a seemingly well-optimized query involving multiple… READ MORE
Just upload your Oracle AWR Report to chatGPT for analysis! Oracle’s Automatic Workload Repository (AWR) report is a powerful tool… READ MORE
When Full Table Scans Are Better Than Indexes in Oracle It’s a common assumption that using indexes will always result… READ MORE
AI is making everything easier to Oracle DBAs. Most of DBAs are familiar about shrink or reclaiming scape where balancing… READ MORE
“I asked my database for a joke, but it returned a NULL value. Guess it doesn’t have a sense of humor.”
~ Gpt
A passionate baseball fan blog celebrating America’s favorite pastime.
DBADEEDS 