Hi,
I am new on diagnosing issues.
Recently we had an issue in which we are still unsure what was the 1st stone that locked things out.
But I was told to try to find a way - from apex side - to see what could have been an issue, or a way to detect an issue. Thus, I met wwv_flow_activity_log . (10 years working with APEX, and never had the need or even glanced at this table).
But I am failing to understand how it is being generated.
I mean, there could be an initial record that then gets updated to reflect elapsed time... or maybe after all is done and finished, then it logs the record in the table?
What I was able to relate, is how the elapse time got insanely huge when we were facing the lockout in one of the DB objects, even when people was trying to log into the application...
Can anyone guide me to understand this table better? Or has any experience dealing with it and might be able to hint me on things to look at?
Thanks a lot.