Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 1691 invoked from network); 8 Aug 2007 10:05:19 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2007 10:05:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 44512724AF6; Wed, 8 Aug 2007 11:03:01 -0400 (EDT) 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 21717-02-2; Wed, 8 Aug 2007 11:03:01 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E07FC724844; Wed, 8 Aug 2007 11:02:57 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 08 Aug 2007 10:20:23 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F344C71ECD3 for ; Wed, 8 Aug 2007 10:20:22 -0400 (EDT) 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 09856-10 for ; Wed, 8 Aug 2007 10:20:22 -0400 (EDT) Received: from mail-ironport1.dol.gov (mail-ironport1.dol.gov [63.106.133.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0C05471D3BF for ; Wed, 8 Aug 2007 10:20:19 -0400 (EDT) X-HAT-SENDERGROUP: CES_OUTBOUND X-HAT-MAILFLOWPOLICY: $CES_OUTBOUND_DELIVERY X-HAT-SENDER_IP: 10.183.155.24 X-IronPort-AV: E=Sophos;i="4.19,236,1183348800"; d="scan'208";a="120052349" Received: from mail-external-dcn-ironport2.dol.gov ([10.183.155.24]) by mail-internal-ironport1.dol.gov with ESMTP; 08 Aug 2007 10:22:37 -0400 X-HAT-DCN-SENDERGROUP: CES_OUTBOUND X-HAT-DCN-MAILFLOWPOLICY: $CES_OUTBOUND_DELIVERY Received: from wdcdcn-exbh-01.oasam.dir.labor.gov ([10.183.137.21]) by mail-internal-dcn-ironport2.dol.gov with ESMTP; 08 Aug 2007 10:22:36 -0400 Received: from msha-arl-exmb01.msha.dir.labor.gov ([199.115.8.128]) by wdcdcn-exbh-01.oasam.dir.labor.gov with Microsoft SMTPSVC(6.0.3790.1830); Wed, 8 Aug 2007 10:22:36 -0400 Received: from MSHA-LAK-EXMB01.msha.dir.labor.gov ([10.1.3.147]) by msha-arl-exmb01.msha.dir.labor.gov with Microsoft SMTPSVC(6.0.3790.1830); Wed, 8 Aug 2007 10:22:36 -0400 Content-class: urn:content-classes:message 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 X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: RE: History on dynamic parameters Date: Wed, 8 Aug 2007 08:22:35 -0600 Message-ID: In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: History on dynamic parameters From: "Smith, Steven K - MSHA" To: , X-OriginalArrivalTime: 08 Aug 2007 14:22:36.0729 (UTC) FILETIME=[91915A90:01C7D9C7] X-archive-position: 415 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Smith.Steven@DOL.GOV Precedence: normal Reply-to: Smith.Steven@DOL.GOV 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 Jurgen All changes to parameters should be present in the alert log. Steve Smith Desk: 303-231-5499 Fax: 303-231-5696 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of jurgen_mortier@amis.com Sent: Wednesday, August 08, 2007 7:33 AM To: oracle-l@freelists.org Subject: History on dynamic parameters Hi, I'm a junior DBA and I have an Oracle 9.2.0.4.0 running on Solaris 8 which has been restarted on July 28th (by my collegue currently on FTO) to change some parameters: - shared_pool_reserved_size= from 60M to 100 M - shared_pool_size= from 600M to 1000M - undo_retention= from 1800 to 3600 Since then users report that queries are running twice as long as before. On August 2nd I tried to change back the last 2 parameters (since they were dynamic), but the CKPT process was consuming 1 complete CPU and I was forced to reboot the system on the 3rd. At that time I changed the parameters back to 600M and 1800 seconds. Since that didn't improve the response time, I started realizing that other dynamic parameters might have been changed dynamically without the init file being updated. Does anyone know of a way to find back the history of those (dynamic) parameters (accross DB restarts) ? Regards Jürgen Mortier AMI Semiconductor - "Silicon Solutions for the Real World" NOTICE: This electronic message contains information that may be confidential or privileged. The information is intended for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you received this electronic message in error, please notify the sender and delete the copy you received. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l