Oracle B12255-01 - Manual (Page 100)

mod_plsql
7-30 Oracle HTTP Server Administrator’s Guide
PlsqlBeforeProcedure Specifies the procedure to be invoked before calling the
requested procedure. This enables you to put a hook point before the requested
procedure is called. This is useful in doing SQL*Traces/SQL Profiles while
debugging a problem with the requested procedure. This is also useful when you
want to ensure that a specific call be made before running every procedure.
Notes:
■
For all purposes, except for debugging purposes, this parameter should be
omitted. You could use this parameter to start SQL Trace/SQL Profiling.
■
In older versions of the product, this parameter was called before_proc.
PlsqlBindBucketLengths Specifies the rounding size to use while binding the
number of elements in a collection bind. While executing PL/SQL statements, the
Oracle database maintains a cache of PL/SQL statements in the shared SQL area,
and attempts to reuse the cached statement if the same statement is executed
again. Oracle's matching criteria requires that the statement texts be identical,
and that the bind variable data types match. Unfortunately, the type match for
strings is sensitive to the exact byte size specified, and for collection bindings is
also sensitive to the number of elements in the collection. Since mod_plsql binds
statements dynamically, the odds of hitting the shared cache are low, and it may
fill up with near-duplicates and lead to contention for the latch on the shared area.
This parameter reduces that effect by bucketing bind lengths to the nearest
level.
All numbers specified should be in ascending order. After the last specified size,
subsequent bucket sizes will be assumed to be twice the last one.
Category Value
Syntax PlsqlBeforeProcedure string
Default None
Example PlsqlBeforeProcedure portal.mypkg.mybeforeproc