perl.exe consuming sharable memory in 9.2 database
The CBO is using a view to resolve the query but I'm not sure if that's the reason for excessive use of memory or could it be Perl?
SQL ordered by Sharable Memory for DB: SCVLPD Instance: scvlpd1 Snaps: 45742 -
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b) Executions % Total Hash Value
-------------------------- ------------ ------- ------------
37,046,627 238 8.5 1317592350
Module: perl.exe