Oracle® Database 11g / 12c / 18c error codes ORA-60025: Event for temp segment cleanup used for temp lobs

ORA-60025: Event for temp segment cleanup used for temp lobs

Oracle Error Code: ORA-60025

Cause: Temp LOB segments used for temporary LOBs are deleted only on session exit which may lead to large amounts of memory being held across multiple sessions.

Action: Setting this event will cause temporary LOB segments to be freed when there are no active temporary LOBs in the session. Setting this event will have a significant performance impact as it can cause temporary lob segments to be allocated and deleted many times during a session rather than once per session. Use this event only when temporary LOB segment memory use is an issue.