Follow the information in the following URL to enabling sql trace.

http://radio-weblogs.com/0118231/stories/2005/06/22/verifyingEffectivenessOfViewObjectFetchSizeUsingSqlTrace.html

In order to easily identify the trace file you can set the trace file identifier as follows in ur AM..

getDBTransaction().executeCommand("ALTER SESSION SET tracefile_identifier = mysqltrace");