Administration Database 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 h… May 30, 2023 3 min read
Administration Database 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 r… May 30, 2023 2 min read
Administration Database 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 perfor… May 30, 2023 2 min read
Administration Database 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),… May 19, 2023 2 min read
Administration Database 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 r… May 18, 2023 3 min read
Administration Database 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 Pr… Apr 12, 2023 2 min read
Administration 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 Brasi… Feb 23, 2023 5 min read
Administration Database 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 s… Feb 18, 2022 1 min read
