The Oracle Logging Framework (OLF) is an Oracle PL/SQL based logging and debugging utility that supports "levels" similar to Log4J. The key feature of the OLF is the ability to dynamically set a logging level based on almost any combination of module, action, username, and sid and instance_id. The OLF is integrated with the Instrumentation Library for Oracle (ILO) to provide task timing and extended SQL tracing, and since the OLF requires the setting of module and action to be effective, the ILO is the best suited utility to provide that functionality.
The OLF has been moved to GitHub at https://github.com/AndyRivenes/OLF
The OLF provides the ability to support the following instrumentation categories:
- Runtime registration
- Metric collection
- Logging Levels
The Oracle Logging Framework (OLF) follows the basic Log4j logging levels and values:
- FATAL - 50000
- ERROR - 40000
- WARN - 30000
- INFO - 20000
- DEBUG - 10000
Log4j also includes an ALL and an OFF level, and the Oracle Logging Framework (OLF) includes these levels as well as a TIMED level that is used to insure that task timing is always logged. Each level is set so that ALL < DEBUG < INFO < WARN < ERROR < FATAL< TIMED < OFF. A default level of FATAL is assigned in the OLF code and can be overridden in the dynamic configuration or it can be explicitly set.
One of the biggest features of the OLF is the ability to dynamically set log levels. Whether it's for a single user, program or task you don't want to have to stop everything and reset a configuration file and then restart the application. You really want to be able to set the logging dynamically on the fly. With the OLF you can do this through the dblog_config table.
A very simple example of a logged PL/SQL block is the following:
declare l_num number; begin ilo_task.begin_task( module => 'module', action => 'action'); -- dblog.info('Before statement'); -- select 1 into l_num from dual; -- dblog.info('After statement'); -- ilo_task.end_task; exception when others then dblog.error('An error occurred'); -- ilo_task.end_all_tasks; -- RAISE; end;