http://netvouz.com/MondoTofu/tag/event?feed=rss MondoTofu's bookmarks tagged "event" on Netvouz http://apunhiran.blogspot.com/2011/05/impdp-stuck-with-wait-event-wait-for.html IMPDP Stuck with wait event - "wait for unread message on broadcast channel" Oracle > Utilities MondoTofu Fri, 01 May 2015 01:08:14 GMT http://www.oracle-base.com/articles/misc/sql-trace-10046-trcsess-and-tkprof.php SQL trace, 10046, trcsess and tkprof in Oracle The quickest way to capture the SQL being processed by a session is to switch on SQL trace or set the 10046 event for a representative period of time. The resulting trace files can be read in their raw state or translated using the tkprof utility. Trace files are found in v$diag_info view Oracle > Optimization MondoTofu Thu, 28 Aug 2014 13:59:45 GMT