Dunno how a zip file attachment got past the mail server, but I will find out. In the meantime, please *DO NOT* send attachments to this list. This single attachment generated 100 Meg of email. Jared oracle-l-bounce@xxxxxxxxxxxxx wrote on 06/17/2004 11:19:04 AM: > Hi , > Thanks much for your time and taking a look into this . I attched > the trace file for your reference . From the trace file I have > prepared the following resource profile . > > > Wait > > Total(secs) > > db file sequential read > > 8.7 > > direct path read > > 0 > > direct path write > > 0 > > file open > > 0.08 > > latch free > > 2.84 > > log file sync