Can anyone recommend a software package, or developer tool set, out there
that contains a set of utility packages that will allow developers to log
the process of the pl/sql they are running. The requirement actually calls
for being able to change a trace level in the code while the code is running
(I don't know how feasible this is since I can not impact performance). The
intention is to insert utility.fnc_name() lines into the code, we do not
want to have to baby sit a 48 hour process.
In general I need:
general logging functionality
Error handling
Pagging of support if errors occur or a job seems to be hung.
Ability to trace procedures and have the trace level change on the fly
Tracking statistics of a running job. ie this much CPU, oracle stats, and #
of records committed.
If you think that this is something that needs to be written in house then
let me know that too.
Please send reply to bobchaytor_at_hotmail.com