PL/SQL Performance Statistics

The ttPLSQLMemoryStats built-in procedure returns statistics about PL/SQL library cache performance and activity.

The example that follows shows some sample output. Refer to ttPLSQLMemoryStats in Oracle TimesTen In-Memory Database Reference for information about this procedure.

Command> call ttplsqlmemorystats;
< Gets, 5.000000 >
< GetHits, 0.000000e+00 >
< GetHitRatio, 0.000000e+00 >
< Pins, 4.000000 >
< PinHits, 0.000000e+00 >
< PinHitRatio, 0.000000e+00 >
< Reloads, 0.000000e+00 >
< Invalidations, 0.000000e+00 >
< CurrentConnectionMemory, 0.000000e+00 >
< DeferredCleanups, 0.000000e+00 >
10 rows found.

Note:

CurrentConnectionMemory is related to the PLSQL_CONN_MEM_LIMIT connection attribute documented in PL/SQL Connection Attributes, indicating the amount of heap memory that has actually been acquired by PL/SQL.