Shell Script to create weekly backups for TDE Wallet
Hey everyone, Hope you’re doing good. As already discussed in the blog, every environment which uses TDE (Transparent Data Encryption), a wallet is needed to store the encryption key. The…
Why my Data Guard Physical Standby always had Apply Lag greater than 30 minutes?
Hey everyone, Hope you’re doing good. I had a call with a client some days ago, they have a Data Guard Physical Standby running in protection mode Maximum Performance. This…
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…
