Basic idea of tracing & how it can be set up, here is an approach I would like to share.
Please note:
All entries here are experiences in oracle which some or other times are partial
representation of the many/diverse solutions. Please refer to oracle documentation
before implementing it