Monitoring SQL statements

To extend monitoring capabilities of OCL-based applications there is an additional tool called DB Monitor.

OCL uses DB Monitor tool to trace SQL activity in your applications. You may gather the following information in real time and use it while debugging:

·

Connection open/close events.

·

Actual SQL and PL/SQL statements passed to the server.

·

Parameter values passed to and from the server.

·

Error and other messages generated by the server.

·

Exact timing information for every monitoring event.

To make use of monitoring in OCL applications call OraMonitor::start static function. Then launch DB Monitor tool and it displays all the information on SQL activity in your applications.

---

OCL | Using OCL | Index