Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 20918 invoked from network); 18 Dec 2007 11:33:38 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 18 Dec 2007 11:33:38 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA8D67DB176; Tue, 18 Dec 2007 12:33:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27667-02; Tue, 18 Dec 2007 12:33:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 44CA47DB17B; Tue, 18 Dec 2007 12:33:37 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 18 Dec 2007 11:46:12 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9DA447D9AD3 for ; Tue, 18 Dec 2007 11:46:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21111-04 for ; Tue, 18 Dec 2007 11:46:12 -0500 (EST) Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.176]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 65B347D9A87 for ; Tue, 18 Dec 2007 11:46:11 -0500 (EST) Received: by el-out-1112.google.com with SMTP id y26so650200ele.18 for ; Tue, 18 Dec 2007 08:46:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=GrLMGLGleFpfsKKV9pe6jVwrLGijpwnQgyZ1vbTaawY=; b=nbKlmyYtqZKXvmYkZQAXIaMQ4cNLS0SpdYTEuQiVKwW7uC1YbpLXbqKuwkbCjZX+upOxIobpXwCJVCq0BKRF4zzSYP4Rv1c3cS0dQzp0dSJPjZFX2lJwwBUjECEkqEUDClDNRwv99yJPgVIyfz6jEyrk7vss6Qhfb2LcRTsg1ts= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=nyrkSC4MEvbNEqhEx3W6mvMoJe4ARv27hrl5VpiIAikWU55KzJR0+FBZsmTOQ/+lp5qIPpImf/gsZurBJriiXQ/2/AE1QtNCsCHhrFFWo1qIq2EUiP+DByIlgemgBujk14wqMTaltUZhJIpZTdQ+ZVX4yIkoa5m5RL3CKzKZubI= Received: by 10.142.187.2 with SMTP id k2mr37830wff.51.1197996370577; Tue, 18 Dec 2007 08:46:10 -0800 (PST) Received: by 10.142.211.17 with HTTP; Tue, 18 Dec 2007 08:46:10 -0800 (PST) Message-ID: Date: Tue, 18 Dec 2007 10:46:10 -0600 From: "Andrew Kerber" To: oracle-l Subject: selects on the data dictionary hang MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_16039_30865921.1197996370607" X-archive-position: 3993 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: andrew.kerber@gmail.com Precedence: normal Reply-to: andrew.kerber@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_16039_30865921.1197996370607 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline We are running into something strange. We have queries on the data dictionary hanging, while other queries appear to run correctly. We are in Oracle 10gR2 on AIX. It appears that Patrol is doing something that manages to hang itself and any other query or update on the data dictionary, such as statspack snapshots and statistics jobs. We end up having to kill patrol and the other jobs to get things working again. Has anyone else seen this or have an idea what is going on? -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' ------=_Part_16039_30865921.1197996370607 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline We are running into something strange.  We have queries on the data dictionary hanging, while other queries appear to run correctly.  We are in Oracle 10gR2 on AIX.  It appears that Patrol is doing something that manages to hang itself and any other query or update on the data dictionary, such as statspack snapshots and statistics jobs.  We end up having to kill patrol and the other jobs to get things working again.  Has anyone else seen this or have an idea what is going on?

--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.' ------=_Part_16039_30865921.1197996370607-- -- http://www.freelists.org/webpage/oracle-l