Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 28712 invoked from network); 8 Aug 2007 12:08:52 -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 12:08:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 761A0724CDE; Wed, 8 Aug 2007 13:06:33 -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 20140-01-2; Wed, 8 Aug 2007 13:06:33 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DEE33724F14; Wed, 8 Aug 2007 13:06:32 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 08 Aug 2007 12:23:57 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 78E2E720B01 for ; Wed, 8 Aug 2007 12:23:57 -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 10208-07 for ; Wed, 8 Aug 2007 12:23:57 -0400 (EDT) Received: from mx03.mailboxcop.com (mx03.mailboxcop.com [206.125.223.73]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E5787720CB2 for ; Wed, 8 Aug 2007 12:23:52 -0400 (EDT) Received: from secure9.apollohosting.com (secure9.apollohosting.com [206.125.217.251]) by mx03.mailboxcop.com (8.13.1/8.13.1) with ESMTP id l78GQ2pH011557 for ; Wed, 8 Aug 2007 11:26:03 -0500 Received: (qmail 930 invoked from network); 8 Aug 2007 11:19:51 -0500 Received: from unknown (HELO ?172.20.10.81?) (tim@12.109.229.8) by associatedcontrolsinc.com with ESMTPA; 8 Aug 2007 16:19:50 -0000 Message-ID: <46B9ECDE.5080203@evdbt.com> Date: Wed, 08 Aug 2007 10:18:38 -0600 From: Tim Gorman Organization: Evergreen Database Technologies, Inc. User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: dannorris@dannorris.com CC: andrew.kerber@gmail.com, jurgen_mortier@amis.com, oracle-l@freelists.org Subject: Re: History on dynamic parameters References: <332024.86039.qm@web35402.mail.mud.yahoo.com> In-Reply-To: <332024.86039.qm@web35402.mail.mud.yahoo.com> Content-Type: text/html; charset=ISO-8859-1 X-Bayes-Prob: 0.0001 (Score 0) X-Spam-Score: 0.60 () [Hold at 6.00] HTML_MESSAGE,J_CHICKENPOX_34,MIME_HTML_ONLY X-CanItPRO-Stream: outgoing (inherits from default) X-Canit-Stats-ID: Bayes signature not available X-Scanned-By: CanIt (www . roaringpenguin . com) on 192.168.15.5 X-archive-position: 421 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: tim@evdbt.com Precedence: normal Reply-to: tim@evdbt.com 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 The table is STATS$PARAMETER and there is a SQL*Plus script named "sp_parm_changes.sql" at http://www.EvDBT.com/tools.htm to display this information...

Dan Norris wrote:

If you're taking statspack snapshots, you can also find the non-default parameters captured in the statspack repository. I don't remember the exact table in the STATS$ tables, but it shouldn't be that hard to find if you're really desperate (and you're taking regularly-scheduled snapshots).

Dan

----- Original Message ----
From: Andrew Kerber <andrew.kerber@gmail.com>
To: jurgen_mortier@amis.com
Cc: oracle-l@freelists.org
Sent: Wednesday, August 8, 2007 8:43:04 AM
Subject: Re: History on dynamic parameters

There should be a record of the changes in the alert log if you can find the entries from that far back.

On 8/8/07, jurgen_mortier@amis.com <jurgen_mortier@amis.com> wrote:
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

--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

-- http://www.freelists.org/webpage/oracle-l