G-8510: Always use dbms_application_info to track program process transiently.
Minor
Efficiency, Reliability
Unsupported in db* CODECOP Validators
We cannot know where the use of dbms_application_info
is sensible. Algorithms to detect wrong, missing and right usages of this pattern are virtually impossible to implement without understanding the context.
Reason
This technique allows us to view progress of a process without having to persistently write log data in either a table or a file. The information is accessible through the v$session
view.
Example (bad)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
|
Example (good)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
|