Gathering Dictionary Statistics Runs Very Long Time. Why?
Hey everyone, Hope you’re doing good. We have a client that has a database used for a SAP BI solution (BW – Business Warehouse), which had stale statistics for dictionary…
How to Create a Job using DBMS_SCHEDULER to execute a Shell Script every Thursday at 9:00 am
Hey everyone, Hope you’re doing good. I was working for a client which would like to schedule a schell script every Thursday at 9:00 am to remove old traces. Client…
How to Create a SQL Patch for a Query from the AWR views
Hey everyone, Hope you’re doing good! In most applications, application code is static and cannot be modified by users. If there is a performance issue with application SQL, one potential…
How to Change TDE Wallet Password
Hey everyone, Hope you’re doing good. In the last two years I worked for a client where we have activated TDE (Transparent Data Encryption), where we have enabled the encryption…
ORA-01565 ORA-01034 ORA-00205 Linux-x86_64 Error: 13: Permission denied when starting DB Instance
Hey everyone, Hope you’re all doing good. A few days ago, I received a call from a client regarding an issue during a RAC instance startup running on 19.17 version.…
How to copy SQL Patches, SQL Profiles and SQL Baselines between environments
Hey Everyone, Hope you’re fine. This is a simple and short post, but extremely useful. I was in a migration project and client used PreProd environment for stress test, code…
Sequence value JUMPING after some “error”
Hey everyone, Hope you’re doing well. This week it happened a “good” discussion in a WhatsApp Group for a DBA Brazilian Community (DBA Brasil). One colleague was facing an “inexplicable”…
Resolving OEM Alert Issues regarding Tablespaces
Hi all, Hope you’re doing good. A client called me a few days ago regarding an issue with their OEM environment. A huge database got some tablespace space exhausted and…
