THANKS for all the great input. Problem solved! :)
On Fri, Jan 15, 2016 at 12:40 PM, Sayan Malakshinov <xt.and.r@xxxxxxxxx>
wrote:
Unfortunately any query to sys.x$dbgalertext always reads from all
log*.xml files, even if we specify only one file: select * from
sys.x$dbgalertext
where partition = :N
Therefore, it takes a lot of time if we have big LONGP_POLICY