Logreader does not release memory even if queries are deleted.
Last updated on MAY 14, 2012
Applies to:Siebel CRM - Version 220.127.116.11  and later
Information in this document applies to any platform.
According to Siebel System Monitoring and Diagnostics Guide, "The LFA saves the results of each query to memory or saves it to a text file". Therefore the command "delete query-name" on the logreader should release the same amount of memory used by the particular query.
Even "delete query-name" is processed and the output is no longer accessible, memory used by the logreader is only slightly decreased (few hundreds of KB.) If a customer runs many queries in different query names, memory usage by the logreader continues to increase until it reaches memory limit.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms