Movatterモバイル変換

Several system status variables provide information about usage of MLE stored programs. Themle_stored_procedures,mle_stored_functions, andmle_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 variablesmle_stored_program_bytes_max, which provides the size, in bytes, of the largest current MLE stored program, andmle_stored_program_sql_max shows the maximum number of SQL statements executed by any MLE stored program.