More on ORA-Error

(We marked visited pages blue)

Oracle Solution for Error ora-60025

Solution for Oracle Error ORA-60025

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

What triggered the Error:

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.

What should we do to fix it:

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.


Leave a comment or a question in the comment area bellow if you fell like


Be a sport and

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x