Several system status variables provide information about usage
of MLE stored programs. The
mle_stored_procedures
,
mle_stored_functions
, and
mle_stored_programs
status
variables show, respectively, the numbers of MLE stored
procedures, MLE stored functions, and MLE stored programs which
are presently cached, across all user sessions.
Additional MLE stored program metrics can be obtained from two
status variables
mle_stored_program_bytes_max
,
which provides the size, in bytes, of the largest current MLE
stored program, and
mle_stored_program_sql_max
shows the maximum number of SQL statements executed by any MLE
stored program.