I had a problem with finding a problematic SQL for a session connected to a shared server belonging to a 9.2.0.5 Oracle database. I scp-ed (secure version of the ancient "rcp" program) all *s00*.trc files to my box with 10.2 database and trcsess produced one large trace file that I was able to format with 10.2 tkprof. The big news here is that 10g facilities will work seamlessly with 9i stuff. Now, I have some developers to kill...... -- Mladen Gogala http://www.mgogala.com -- //www.freelists.org/webpage/oracle-l