From oracle-l-bounce@freelists.org Thu Aug 19 14:09:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i7JJ9F410816 for ; Thu, 19 Aug 2004 14:09:15 -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 i7JJ9FI10811 for ; Thu, 19 Aug 2004 14:09:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8B8072C9BE; Thu, 19 Aug 2004 14:14:02 -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 11805-30; Thu, 19 Aug 2004 14:14:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B27C72C355; Thu, 19 Aug 2004 14:14:02 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 19 Aug 2004 14:12:33 -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 A8C3872C835 for ; Thu, 19 Aug 2004 14:12:32 -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 11422-21 for ; Thu, 19 Aug 2004 14:12:32 -0500 (EST) Received: from mta6.srv.hcvlny.cv.net (mta6.srv.hcvlny.cv.net [167.206.5.72]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5B67372C4A8 for ; Thu, 19 Aug 2004 14:12:32 -0500 (EST) Received: from oolsrv8.srv.hcvlny.cv.net (oolsrv8.srv.hcvlny.cv.net [167.206.5.23]) by mta6.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.25 (built Mar 3 2004)) with ESMTP id <0I2P0042HK13EI@mta6.srv.hcvlny.cv.net> for oracle-l@freelists.org; Thu, 19 Aug 2004 15:12:39 -0400 (EDT) Received: from optonline.net (localhost [127.0.0.1]) by mstr8.srv.hcvlny.cv.net (iPlanet Messaging Server 5.2 HotFix 1.25 (built Mar 3 2004)) with ESMTP id <0I2P002JKK13SS@mstr8.srv.hcvlny.cv.net> for oracle-l@freelists.org; Thu, 19 Aug 2004 15:12:39 -0400 (EDT) Received: from [167.206.5.139] (Forwarded-For: [205.139.237.24]) by mstr8.srv.hcvlny.cv.net (mshttpd); Thu, 19 Aug 2004 15:12:39 -0400 Date: Thu, 19 Aug 2004 15:12:39 -0400 From: jaysingh1@optonline.net Subject: AWR snapshots are not taken automatically To: oracle-l@freelists.org Message-id: <694e42690e86.690e86694e42@optonline.net> MIME-version: 1.0 X-Mailer: iPlanet Messenger Express 5.2 HotFix 1.25 (built Mar 3 2004) Content-type: text/plain; charset=us-ascii Content-language: en Content-Transfer-Encoding: 8bit Content-disposition: inline X-Accept-Language: en Priority: normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 7910 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jaysingh1@optonline.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi All, Windows XP pro, Oracle 10.1.0.2. AWR snapshots are not taken automatically. Is there any init parameter, i need to set? select snap_interval, retention from dba_hist_wr_control; SNAP_INTERVAL RETENTION ------------------- ------------------- +00000 01:00:00.0 +00007 00:00:00.0 Manual snapshot works fine. execute dbms_workload_repository.create_snapshot Thanks Jay ---------------------------------------------------------------- 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 -----------------------------------------------------------------