Re: Weird database hanging

From: Don Seiler <>
Date: Wed, 20 Feb 2008 09:43:44 -0600
Message-ID: <>

In mid-January we did upgrade to and applied the patch to the aforementioned bug. It has now been one full billing cycle and we haven't had a re-occurrence of the instance hanging problem. The bind_peeked_pq_mismatch query now returns no rows.

select sql_id, count(*)
from v$sql_shared_cursor
where bind_peeked_pq_mismatch='Y'

group by sql_id;

no rows selected

FYI. Hope your day is warmer than mine.



Don Seiler
-- Received on Wed Feb 20 2008 - 09:43:44 CST

Original text of this message