I notice in my statspack report, under SGA Breakdown section, "shared pool library cache" shows begin value = 139M and end value = 3MB over a period of 3 days. It does not look normal to me. Could someone shed some light on possible causes of this?
Thanks,