Добрый день.
Растет место занимаемое объектом hssk hofpa/3.
За 100 дней до 200 МБ. Т.к БД 32bit - жалко места.
Решает вопрос - рестарт БД.
Понять что за объект не могу. Гугл не в теме.
?

select * from v$version
BANNEROracle Database 11g Enterprise Edition Release 11.1.0.7.0 - ProductionPL/SQL Release 11.1.0.7.0 - ProductionCORETNS for 32-bit Windows: Version 11.1.0.7.0 - ProductionNLSRTL Version 11.1.0.7.0 - Production


SELECT
POOL, NAME, BYTES/1000/1000 MB
FROM SYS.V_$SGASTAT
order by BYTES desc

POOLNAMEMBshared pool hssk hofpa/3 246.619108 buffer_cache 213.909504shared pool sql area 181.036848shared pool free memory 129.246244shared pool CCursor 56.990032


SELECT
NAME, BYTES/1000/1000 MB
FROM SYS.V_$SGAINFO
order by BYTES desc

NAMEMBMaximum SGA Size 836.99712Shared Pool Size 608.17408Buffer Cache Size 213.909504Startup overhead in Shared Pool 104.8576Redo Buffers 5.173248Large Pool Size 4.194304Java Pool Size 4.194304Granule Size 4.194304Fixed SGA Size 1.350472Free SGA Memory Available 0Shared IO Pool Size 0Streams Pool Size 0