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.