From oracle-l-bounce@freelists.org Tue Dec 13 16:22:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jBDMMRpW030904 for ; Tue, 13 Dec 2005 16:22:27 -0600 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 jBDMMNAX030892 for ; Tue, 13 Dec 2005 16:22:23 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D3A87254B9F; Tue, 13 Dec 2005 17:22:19 -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 14360-08; Tue, 13 Dec 2005 17:22:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2448B254F11; Tue, 13 Dec 2005 17:22:19 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Dec 2005 17:22:17 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09584254DD0; Tue, 13 Dec 2005 17:22:16 -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 14360-06; Tue, 13 Dec 2005 17:22:15 -0500 (EST) Received: from sb12.jpmchase.com (mailms.chase.com [170.148.48.205]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33024254C5D; Tue, 13 Dec 2005 17:22:14 -0500 (EST) Received: from svr.bankone.net ([10.246.2.19]) by sb12.jpmchase.com (Switch-3.1.6/Switch-3.1.6) with ESMTP id jBDLrHYv016859; Tue, 13 Dec 2005 16:53:17 -0500 Received: from ([10.246.2.177]) by imj2.svr.bankone.net with ESMTP id KP-BRCGF.12730623; Tue, 13 Dec 2005 16:21:52 -0600 Subject: RE: export error for duh Gurus To: BSpears@Limitedbrands.com Cc: mark.powell@eds.com, "oracle-l" , oracle-l-bounce@freelists.org Message-ID: From: Rajesh.Rao@jpmchase.com Date: Tue, 13 Dec 2005 17:21:50 -0500 X-MIMETrack: Serialize by Router on MIUSCC008/JPMCHASE(Release 6.5.3|September 14, 2004) at 12/13/2005 05:21:53 PM MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-archive-position: 29140 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rajesh.Rao@jpmchase.com Precedence: normal Reply-To: Rajesh.Rao@jpmchase.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: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org Muh database too has been suffering from occasional similar failures. Version 9.2.0.5. Solaris 8. HAve been asked by Oracle to upgrade to the latest patchset, or to do conventional export, instead of direct. I decided to live with the occassional error. Usually, once a month. "Spears, Brian" , "oracle-l" ands.com> cc: Sent by: Subject: RE: export error for duh Gurus oracle-l-bounce@fr eelists.org 12/13/2005 05:13 PM Please respond to BSpears It's highly sensitive production db... I cannot implement new datapump right now..It's just the nature of the environment here. Yes the conventional exports with direct=y ... If it wakes me up again, I will try the direct=N Note: a rerun of the export usually is successful! So I am thinking some resource contention or something. Brian From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Powell, Mark D Sent: Tuesday, December 13, 2005 4:41 PM To: oracle-l Subject: RE: export error for duh Gurus Brian, do you get the error on conventional exports? And to be clear I take it you are using the traditional exp utility and not the new expdp utility that is the preferred utility with 10g to use for exports. -- Mark D Powell -- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Spears, Brian Sent: Tuesday, December 13, 2005 4:23 PM To: oracle-l Subject: export error for duh Gurus Has anyone got ideas or run across this intermittent export error? Randomly getting this error in the export full. Metalink does not show anything related at our version so a tar created. . . exporting table CARTON_STATUS EXP-00008: ORACLE error 8103 encountered ORA-08103: object no longer exists . . exporting table CLASS_IMPLEMENTATION 33 rows exported * oracle 10.1.0.3.0 Hpux 11.23 32bit 9000/800 * The table exists * The error occurs on different tables each time * Check for block corruption shows no problems * table creation date is months back * normal processing in the database at this time * consistent=y, direct=y full=y rows=y Brian Spears From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Yongping Yao Sent: Tuesday, December 13, 2005 1:22 AM To: sjaffarhussain@gmail.com Cc: oracle-l Subject: Re: pga_aggregate_target I think Expert Oracle: Database Arichitecture Chapter 3 (or 4 I don't have it in hand) will help you. On 12/13/05, The Human Fly wrote: Hello List, I was little confused about the settings of pga_aggregate_target parameter. I was in a assumption that when we set this parameter to a certain value, the usage of pga wont go beond this value. I have set pga as 3gb to one of my business critical database. Recently, I have found that max pga allocation was 4+ Gb. My boss askmed me, why the hell it takes more than what we have defined. I explained him saying that oracle might taken it from the OS to finish the necessary request. His immediately counter question was, then what is the use of setting pga_aggregate_target parameter? When oracle allocates and de-allocated the memory (pga) as per requirements. Is it expected behaviour that oracle takes sometime more that the value defined for pga? If so, what is the benift of setting value for pga? Thanks for your time. -- Best Regards, Syed Jaffar Hussain OCP 8i & 9i DBA, Banque Saudi Fransi, Saudi Arabia ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- http://www.freelists.org/webpage/oracle-l -- Yao Yongping Learning Oracle, UNIX/Linux... Love Reading, Classical Music, Philosophy, Economics etc. Blog: http://spaces.msn.com/members/yaoyp/ -- http://www.freelists.org/webpage/oracle-l