mark Recently, I wanted to do some performance of my code. The following is what I’ve used to get some performance timing. The following is the code I’ve used. Run the code with the following: As we can see, the code took 8.3 seconds to run and the following is a breakdown of each module which … Read more
Here is some code to help identify what has been applied and what is missing. Archivelog gap Log Gap Check Get Archive Logs from Backup Stop and Start Apply Services
How to identify lockers This article will explain about locks on rows and on objects in ORACLE. Locks on rows can cause performance problems or even impede a transaction from finishing, when there are processes running for long time we need to validate that they are not waiting on a row(s). When there is a … Read more
I’m used to working in a UNIX environment and when I was asked to build a database and manage on Windows, I was faced with some new challenges. One of them is searching through the Alert log and without standard UNIX grep I wanted to write something that could perform the same function. Also show … Read more