PL/SQL Profiling

Aino Andriessen 3

How do you trace performance issues and bottlenecks in your PL/SQL applications? Since 8i the Oracle database has been equiped with the profiling tool dbms_profiler. It is quite simple to use: start the profiler, execute the code, stop the profiler. The profiler analyzes the execution of PL/SQL statements and stores […]

Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)

Lucas Jellema

Oracle SCM – the Software Configuration Manager – provides the backend source code control services for Oracle Designer. It offers among other things functionality for Version Control: Check In, Check Out, Branching and Merging and it records Check In/Out notes, Version Labels and ‘version events’. In comparison with several other […]