Re: Cancel of a long-running, latch-holding query takes long (8i) - why?

querying v$session_wait while waiting might offer up some clues.

Jared

On 6/29/05, Peter Alteheld <palteheld_at_yahoo.de> wrote:
>
> Hi List,
> we had a cancelled query that held 'cache buffer chain' latches on some
> objects and took a lot of cpu consumption. The time for the cancel operation
> takes in our production db (8.1.7) about an hour, on a dev db (8.1.7) 30
> min and on an upgraded db (10.1.0.2 <http://10.1.0.2>) only some seconds.
> While we are not able to upgrade production very soon, I am trying to figure
> out a solution for 8i.
>

--
http://www.freelists.org/webpage/oracle-l