From oracle-l-bounce@freelists.org Fri Oct 7 05:12:47 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j97ACWxt014016 for ; Fri, 7 Oct 2005 05:12:42 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j97ACEvX013916 for ; Fri, 7 Oct 2005 05:12:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A948E1F6DA8; Fri, 7 Oct 2005 05:11:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15114-02; Fri, 7 Oct 2005 05:11:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F8941F6CEA; Fri, 7 Oct 2005 05:11:12 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=BgMFak8Cj6IgxZa6qEWDsUZjf3rXxTelpX8VmV0xbOYhU9RBV0wQZAvIBukSyZaJruGEyRtyMjsQtJV/MOaAQo7Iy9f+8OGs/6LQZ9Pv38hDAZK98MoVp1MW3YCZSzARtmTInl+KSQSzkFWWp+EYQy+H6O0S1ZHf/VjlNOoWPmg= Message-ID: <962cf44b0510070309s4f458200q53c2c662cc036a92@mail.gmail.com> Date: Fri, 7 Oct 2005 18:09:18 +0800 From: zhu chao To: Oracle-L Freelists Subject: analyze a BIG IOT table caused other session blocked with library cache lock MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4105_32980574.1128679758014" X-archive-position: 26521 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zhuchao@gmail.com Precedence: normal Reply-To: zhuchao@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, NORMAL_HTTP_TO_IP autolearn=no version=2.63 ------=_Part_4105_32980574.1128679758014 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi, all, We have a case, when analyze a big and busy IOT table, it took around 2 hours (analylze table xxx estimate statistics sample 5 percent), and later other sessions were blocked with library cache ping wait event. The analyze session is still running and that session was waitfinf for db file sequential read. Can't find other thing special. Oralce version is 9.2.0.5 and OS is solaris 8. Anyone hav= e experience like that? -- Regards Zhu Chao www.cnoug.org ------=_Part_4105_32980574.1128679758014 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
hi, all,
    We have a case, when analyze a big and busy IO= T table, it took around 2 hours (analylze table xxx estimate statistics sam= ple 5 percent), and later other sessions were blocked with library cache pi= ng wait event. The analyze session is still running and that session was wa= itfinf for db file sequential read.  Can't find other thing special.
   Oralce version is 9.2.0.5 = and OS is solaris 8. Anyone have experience like that?
--
Regards
Zhu Chao
www.cnoug.= org
 
------=_Part_4105_32980574.1128679758014-- -- http://www.freelists.org/webpage/oracle-l