Re: Cancel of a long-running, latch-holding query takes long (8i) - why?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: palteheld@xxxxxxxx
- Date: Wed, 29 Jun 2005 08:51:20 -0700
querying v$session_wait while waiting might offer up some clues.
Jared
On 6/29/05, Peter Alteheld <palteheld@xxxxxxxx> 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.
>
Other related posts:
