All the local declarations of a program unit are categorized as identifiers. An identifier's declaration locates a memory on the server and keeps it busy until the program unit is executed or terminated. Redundant identifiers must be recognized within a program so as to restrict them from holding a chunk of memory for no operation.
Oracle provides a tool known as PL/Scope to monitor the activities of identifiers in a program. It is one of the new features in Oracle 11g.
The PL/Scope tool compiles and captures the information of the identifiers declared and used in a program. Once the feature is enabled, the language compiler filters out the identifier's information and stores it in a dictionary view called USER_IDENTIFIERS
. An identifier is recognized by its name, type, and usage.
Let us examine some of the key features of the PL/Scope tool:
Only unwrapped program units can use the PL/Scope tool.
The feature can be enabled by setting...