From oracle-l-bounce@freelists.org Tue May 4 08:39:47 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i44DdMB13480 for ; Tue, 4 May 2004 08:39:32 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i44DdB613442 for ; Tue, 4 May 2004 08:39:22 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6DD0E72D6E2; Tue, 4 May 2004 08:29:53 -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 27668-22; Tue, 4 May 2004 08:29:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AAFFE72D422; Tue, 4 May 2004 08:29:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 04 May 2004 08:28:34 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E808972D623 for ; Tue, 4 May 2004 08:28:33 -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 27099-47 for ; Tue, 4 May 2004 08:28:33 -0500 (EST) Received: from brmea-mail-4.sun.com (brmea-mail-4.Sun.COM [192.18.98.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7628872D5D9 for ; Tue, 4 May 2004 08:28:33 -0500 (EST) Received: from phys-giza-1 ([129.147.4.102]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id i44DeusT005877 for ; Tue, 4 May 2004 07:40:56 -0600 (MDT) Received: from conversion-daemon.giza-mail1.Central.Sun.COM by giza-mail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 1.16 (built May 14 2003)) id <0HX600201Z1FRN@giza-mail1.Central.Sun.COM> for oracle-l@freelists.org; Tue, 04 May 2004 07:42:12 -0600 (MDT) Received: from sun.com (vpn-129-150-32-196.Central.Sun.COM [129.150.32.196]) by giza-mail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 1.16 (built May 14 2003)) with ESMTP id <0HX600DNEZEAOV@giza-mail1.Central.Sun.COM> for oracle-l@freelists.org; Tue, 04 May 2004 07:42:11 -0600 (MDT) Date: Tue, 04 May 2004 07:42:03 -0600 From: Daniel Fink Subject: Re: Overriding default max_dump_file_size To: oracle-l@freelists.org Message-id: <40979DAB.B457B880@sun.com> MIME-version: 1.0 X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Accept-Language: en References: <358728A276824E419580403633AABFD0021F6168@INDYSMAIL03.am.thmulti.com> X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4331 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Daniel.Fink@Sun.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Could you be running into a platform-specific limitation? 1073741824 could be too large, so it ignores the command and leaves the default of 5m. Daniel Fink Thomas Jeff wrote: > Any ideas why the following does not work? I don't get an error > message, but the trace > file size will always max out at the database default of 5M. > EXEC sys.dbms_system.set_int_param_in_session (&&sid, &&serial, > 'max_dump_file_size', 1073741824); > > Thanks. > > -------------------------------------------- > Jeffery D Thomas > DBA > Thomson Information Services > Thomson, Inc. > > Email: jeff.thomas@thomson.net > > Indy DBA Master Documentation available at: > http://gkmqp.tce.com/tis_dba > -------------------------------------------- > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------