Requirement I want to have daily mail including currency exchange rate information. Solution use https://wise.com (no need to register an account) Connect to https://wise.com/tools/exchange-rate-alerts/ Input the currency exchange rate you want to know and your email address. Mail result You will receive the mail …

Read More

Purpose Checkmarx is a good tool to do code analysis, but there are 2 pain points during the flow. Checkmarx can integrate SCM like GitHub/GitLab/..., but it cannot be triggered by by a code commit, it can only schedule the job to run the scan. (If I don't commit code, I don't want to waste resources scanning the …

Read More

Purpose In previous article, we know how to integrate GitLab and Checkmarx. In this article, we want to integrate SonarQube too. When we commit code to GitLab, we want GitLab to trigger these actions automatically: GitLab sends the code to Checkmarx to scan. GitLab triggers SonarQube to scan. SonarQube integrates …

Read More

Check table size (remember to check last_analyzed_date) 1SELECT * FROM all_tables WHERE table_name LIKE 'AB%' Re-analyze table 1ANALYZE table TABLE_NAME estimate statisitics Check index-related information (it doesn't contain block information) 1SELECT * FROM all_indexes WHERE table_name LIKE 'AB%' …

Read More