From oracle-l-bounce@freelists.org Fri Oct 21 15:56:29 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9LKuSFB016968 for ; Fri, 21 Oct 2005 15:56:28 -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 j9LKuHvX016947 for ; Fri, 21 Oct 2005 15:56:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA11420B009; Fri, 21 Oct 2005 15:54:03 -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 22058-09; Fri, 21 Oct 2005 15:54:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6C18320BBB7; Fri, 21 Oct 2005 15:54:03 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WDTQDUHmSKj4tGVnJMFG5D4NLBZ9xA9pv6UYeSQp0j49ncws60JOEkN3JjCUFaX25PwYySYYPjAWiw0hc8W55fxf4sSjGU0nVDMxP3VI0D9XP367LRU+tjyQEKirzsmwiOnqfgIIR3BS0VTpXkotBpjR6QA/gAxxWbRWmHJ9lHs= Message-ID: <52a152eb0510211351o46f7e41cxbca9577b80ee067b@mail.gmail.com> Date: Fri, 21 Oct 2005 16:51:57 -0400 From: Christo Kutrovsky To: bdbafh@gmail.com Subject: Re: 10g expdp hang/spin win32 ora-600 [504] (in testing) Cc: oracle-l In-Reply-To: <910046b40510211343l4f730991l22dee89efc0594af@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <910046b40510211207t5de37421vf8e8256b1b1594bd@mail.gmail.com> <910046b40510211343l4f730991l22dee89efc0594af@mail.gmail.com> X-archive-position: 27371 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kutrovsky.oracle@gmail.com Precedence: normal Reply-To: kutrovsky.oracle@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.2 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 I am curious as to how a failed statspack job can cause this ? And if not for production monitoring, where would you run statspack :) Christo On 10/21/05, Paul Drake wrote: > On 10/21/05, Paul Drake wrote: > > Has anyone come across a hang/spin condition with datapump exports? > > > > Standard Edition 10.1.0 patchset 2 (10.1.0.4) + 10.1.0.4 patch 5. > > w2k adv server sp4 > > quad xeon (PIII) > > > > pegged 4 cpus on single user database, single database on the server > > running an expdp.exe job (full=y). > > > > Shared servers are configured for this database due to VPN issues, but > > the expdp session is connected to a dedicated server process (thread). > > > > receiving ora-600 [504] [address] [32] [4] [row cache objects] [10] [2] [0x0] > > > > Since this is testing I'll hold off until next week to open an iTAR. > > > > A hanganalyze did not yet complete. > > The job still appears to be in progress, so its not completely fubared. > > A trace file is being generated by a backround job that appears to be > > a statspack snapshot. > > Is it just me, or is statspack in 10g not something that is meant for > > usage anymore? > > (wide open hole for soliciting signatures for Niall's post concerning ASH). > > I've seen a perfstat.statspack.snap collide with AMM causing major > > amounts of grief in 10.1.0.4 on win32 at least 3 separate times > > (disabled both now) and have seen at least 2 other posters here > > complain about shared_pool latching issues related to that > > combination. > > > > This is not how I planned to spend my afternoon. > > I had hoped to sneak out to a theater to catch DOOM (the movie) - not > > doom, return of the ora-600. > > > > thanks. > > > > Paul > > > > A failed background job executing a statspack.snap was the root cause. > > datapump exports now run fine without issue. > > The fix was brutally simple and did not require downloading a patch or > regression testing: > > SQL> @?/rdbms/admin/spdrop.sql; > > I've concluded that scheduled statspack snapshots just plain do not > belong in a production database, at least for win32 10.1.0.4, even > with statistics_level='BASIC'; and AMM not in use. > > Paul > -- > http://www.freelists.org/webpage/oracle-l > -- Christo Kutrovsky Database/System Administrator The Pythian Group -- http://www.freelists.org/webpage/oracle-l