As you develop larger and larger PL/SQL applications, it becomes more difficult to
isolate performance problems. PL/SQL provides a Profiler API to profile run-time
behavior and to help you identify performance bottlenecks. PL/SQL also provides a
Trace API for tracing the execution of programs on the server. You can use Trace to
isolate performance problems. PL/SQL provides a Profiler API to profile run-time
behavior and to help you identify performance bottlenecks. PL/SQL also provides a
Trace API for tracing the execution of programs on the server. You can use Trace to
trace the execution by subprogram or exception.
当你开发越来越大的PL/SQL应用程序时,它变得更艰难对于避免性能的问题。PS提供
一个查看应用程序接口对于程序在运行时候的行为并且帮你确认性能的瓶颈。PS也提供
一个跟踪API对于在服务器上执行程序的日志。你可以使用日志去跟踪子程序或者异常
的跟踪。