From oracle-l-bounce@freelists.org Wed Feb 2 00:49:05 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j126n56B004617 for ; Wed, 2 Feb 2005 00:49:05 -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 j126n3em004610 for ; Wed, 2 Feb 2005 00:49:03 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE4264F380; Wed, 2 Feb 2005 00:48:08 -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 01014-07; Wed, 2 Feb 2005 00:48:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5EC164F5EB; Wed, 2 Feb 2005 00:48:08 -0500 (EST) Message-ID: <960A9B249C99994AA3C7FCA016A0DA89063605@ussccem08.corp.hds.com> From: John Kanagaraj To: "'bdbafh@gmail.com'" , Oracle-L Subject: RE: ASH droppings in bdump - 10.1.0.3 / win32 Date: Tue, 1 Feb 2005 21:46:20 -0800 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 15649 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@hds.com Precedence: normal Reply-To: john.kanagaraj@hds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Paul, >so would turning off active session history. At the risk of offending the "Hidden parameter" police, you can use one of the following parameters (_ash_enable seems to be the one): select nam.ksppinm NAME, nam.ksppdesc DESCRIPTION, ksppstvl VALUE, ksppstdf IS_DEF from x$ksppi nam, x$ksppsv val where nam.indx = val.indx and (ksppinm like '\_ash%' escape '\' or ksppinm like '\_active%' escape '\') order by 1; NAME DESCRIPTION _active_standby_fast_reconfiguration if TRUE optimize dlm reconfiguration for active/standby OPS _ash_disk_filter_ratio Ratio of the number of in-memory samples to the number of samples actually written to disk _ash_disk_write_enable To enable or disable Active Session History flushing _ash_dummy_test_param Oracle internal dummy ASH parameter used ONLY for testing! _ash_eflush_trigger The percentage above which if the in-memory ASH is full the emergency flusher will be triggered _ash_enable To enable or disable Active Session sampling and flushing _ash_sample_all To enable or disable sampling every connected session including ones waiting for idle waits _ash_sampling_interval Time interval between two successive Active Session samples in millisecs _ash_size To set the size of the in-memory Active Session History buffers Hth, John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) Fear connects you to the Negative, but Faith connects you to the Positive! I Jn 4:18 ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-l