Database, Logging, PL/SQL, SQL

How to enable tracing in Oracle DB? How to read trace files?

There are many ways to enable tracing in Oracle DB, some are legacy and deprecated. One of latest and recommended method for 11gR2 – use of DBMS_MONITOR (find out more about it in Oracle reference) package. To enable whole instance tracing: execute dbms_monitor.database_trace_enable(waits => true, binds => true,  instance_name => ‘instance_name’); To disable whole instance tracing:  execute dbms_monitor.database_trace_disable(instance_name => ‘instance_name’);…

Continue Reading
Logging, OSB, Weblogic

How to filter OSB logging and redirect log records to any desirable destination?

The best practice to accomplish this task is to use Weblogic server startup class. In this class we should take Weblogic server “Logger” object and use it to attach additional appender. This appender can be implemented to redirect log messages to any destination You prefer. Log4j supports dozen of standard destinations, providing built in appenders like JDBCAppender, JMSAppender, FileAppender and many…

Continue Reading