Chapter 8, Compiling and Tuning to Improve Performance

Question No.

Answer

Explanation

1

a and b

Interpreted compilation mode is preferred when a program unit is in development stage and involves SQL statement processing.

2

c and d

The Real Native compilation method removes the dependency on C compiler to generate DLL for the program unit. Instead, the native DLLs are stored in the database dictionary itself. As the DLLs are stored in the dictionary, they can be a part of the normal backup and recovery.

3

b

The PLSQL_OPTIMIZE_LEVEL value set to 3 strictly inlines all the subprograms at high priority.

4

b and c

The PLSQL_CODE_TYPE value specified during recompilation of a program overrides the current system or session settings. ...

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.

Start your free trial