I had a puzzling issue pop up this morning. The first time a session executes a java stored procedure, it takes an extremely long time to return. Every execution thereafter, within the same session, would return very quickly. For example, I executed a procedure to zip a 1 MB text file, and it took 84.6 seconds. I ran it again and it only took 0.14 seconds. I can accept that something might take a little longer the first time it's executed, but I've never seen it perform this poorly. A trace shows that all of the time is spent executing. So far Google hasn't been much help. Any ideas? Windows Server 2003 Oracle 10.2.0.2 Standard Edition JAccelerator is installed. --------------- Jason Heinrich Oracle Database Administrator Pensacola Christian College (850) 478-8496 x2509 jheinrich@xxxxxxxx -- //www.freelists.org/webpage/oracle-l