I have a procedure that copies the records from one table to another based on certain criteria. It is understandable that it would take a long time to execute. However, some data sets processed successfully while others didn't. I am trying to pinpoint the problem and wuold like to be able to see what is happening as the procedure is executed. Is there a way to add some lines to the procedure to get some feedback? During one run nothing happened and it ran for 3 days for a small dataset that should have completed
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.