Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Packages

PROCEDURE DBMS_SYSTEM.KSDDDT

This procedure writes a date and time stamp to the trace file

Argument Name Type In/Out Default?
None

For example the command

    EXECUTE dbms_system.ksdddt;

generated the following line in the trace file

    *** 2003-01-26 18:06:05.000

Note that the trace file must be flushed either implicitly by filling the buffer with additional trace, or explicitly using DBMS_SYSTEM.KSDFLS, before the output from this procedure appears in the trace file.