Hi everyone, Hope you’re doing good. I’m working for a client which has Oracle DB for SAP applications. Those DB’s are not using RAC, yes, I know 🙂 SAP does not support use RAC in its fullness, as cannot use services…
Hey everyone, Hope you’re doing good. Sometime ago, an old client called saying that they have migrated their Linux servers from RHEL6 to RHEL7. They have done a new installation instead upgrading OS. Because of this movement, OEM Agent was not starting…
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 wallet is a file extremally important and critical for the health and…
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 protection mode provides the highest level of data protection that is possible…
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 and fixed tables. When I asked the DBA team they said: is…
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 had only one requirement: use DBMS_SCHEDULER instead Cron. For this, first we need to create…
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 solution is to modify it adding hints to force the desired access path. Sometimes, the…
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 for datafiles on tablespaces used by application. To use TDE, the requirement is to have…
