sql statements missing in continued tracefile

Hi,

i have a little problem with tracing. database is 10.2.0.2 with rac option.
inserts issued by a continuously running process running sometimes too long, more than 3000ms. unfortunately this occures very randomly and infrequently and statspack/awr or fixed views didn't catch the problem because they show only cumulated values or simply nothing. i tried to pin down the problem by tracing with dbms_monitor, 10046 and oradebug in level12. when tracing the sesion for the very first time i see all the sql text in the tracefile. after stopping it and starting it again (because the tracefiles tend to be very huge and the problem occurs only from 10:00-17:00) all sql statements are missing and tkprof/trca/etc. show 0 user statements. this is bad and i'm looking for way to bring the sql text back in order to analyze the traces.

any ideas?

regards,
-ap Received on Tue Nov 28 2006 - 15:24:39 CST