Practice exercise
- Which component of the PL/SQL hierarchical profiler uploads the result of profiling into database tables?
- The Profiler component
- The Analyzer component
- The shared library component
- The Data collector component
- The
plshprof
utility is a SQL utility to generate a HTML profiler report from profiler tables in the database.- True
- False
- Suppose that you are using Oracle 11g Release 2 express edition and you issue the following command:
ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL' / Session altered. ALTER FUNCTION FUNC COMPILE PLSQL_DEBUG=TRUE / Function altered.
Determine the output of the following
SELECT
statementSELECT * FROM USER_ERRRORS /
- No output
PLW-06015: parameter PLSQL_DEBUG is deprecated; use PLSQL_OPTIMIZE_LEVEL = 1
PLW-06013: deprecated ...
Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.