does know timestamp field in v$session_longops does? description on documentation page says "timestamp".
i need elapsed time of operations monitor in longops , short tests less 1 second, still want know ones run longer. hoping use timestamp field capture millisecond time, can't find out if timestamp field can used that.
failing that, there other way millisecond duration of these processes in longops?
update:
having done more investigation, timestamp field appears have value of null. also, it's datatype date, not timestamp...
(using oracle 10g)
oracle maintains v$session_longops - can use dbms_application_info.set_session_longops put entries in there , update them, oracle controls how purged.
one wonders why don't create own table store timings of tests, can analyze data @ leisure? seem indicate you've got packages contain tests; throwing insert or update statement packages seems pretty zero-sum compared calls dbms_application_info.
v$session_longops predates oracle's support of timestamp datatype, that's why column date.
Comments
Post a Comment