oracle 9 on solaris 8 - exception reporting

From: kerravon <>
Date: Wed, 23 Apr 2008 15:53:00 -0700 (PDT)
Message-ID: <>

We have an insert/update transaction that normally takes 0.2 seconds but
sometimes takes as long as 16 seconds. The granularity of statspack is 30
minutes and that is too long to see if there was anything causing delays.

Is there a way of getting Oracle to report a reason why any query takes
more than 1 second?

Thanks. Paul. Received on Wed Apr 23 2008 - 17:53:00 CDT

Original text of this message