Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 31024 invoked from network); 27 Mar 2007 00:02:22 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 27 Mar 2007 00:02:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4B9F5680F61; Tue, 27 Mar 2007 00:57:53 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32169-01; Tue, 27 Mar 2007 00:57:53 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B1B66680C29; Tue, 27 Mar 2007 00:57:52 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 27 Mar 2007 00:21:06 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 57572680F78 for ; Tue, 27 Mar 2007 00:21:06 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28574-04 for ; Tue, 27 Mar 2007 00:21:06 -0400 (EDT) Received: from smtp113.sbc.mail.mud.yahoo.com (smtp113.sbc.mail.mud.yahoo.com [68.142.198.212]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 223F8680F6E for ; Tue, 27 Mar 2007 00:21:05 -0400 (EDT) Received: (qmail 78303 invoked from network); 27 Mar 2007 04:22:34 -0000 Received: from unknown (HELO society.servebeer.com) (socpres@sbcglobal.net@70.224.199.164 with login) by smtp113.sbc.mail.mud.yahoo.com with SMTP; 27 Mar 2007 04:22:33 -0000 X-YMail-OSG: E4cjghUVM1k9OIOrRnlF1V5iVbqYnAuurh0L9wKUFbUf8gJurUVWP5evlV.owHBlxgIHoL753OTfhSgGnNKiaDe7tR5dzwUuvQz4AafJBr6J6s5Kf08- Received: from society.servebeer.com (localhost [127.0.0.1]) by society.servebeer.com (Postfix) with ESMTP id B88B9205A02F; Mon, 26 Mar 2007 23:22:32 -0500 (CDT) Received: from wort ([192.168.1.70]) (SquirrelMail authenticated user rjesse); by society.servebeer.com with HTTP; Mon, 26 Mar 2007 23:22:32 -0500 (CDT) Message-ID: <1127.192.168.1.70.1174969352.squirrel@192.168.1.70> In-Reply-To: <04DDF147ED3A0D42B48A48A18D574C45071FD8F8@NT15.oneneck.corp> References: <41327.12.17.117.251.1174938129.squirrel@12.17.117.251> <04DDF147ED3A0D42B48A48A18D574C45071FD8F8@NT15.oneneck.corp> Date: Mon, 26 Mar 2007 23:22:32 -0500 (CDT) Subject: RE: OEM poll From: "Rich Jesse" To: "Allen, Brandon" Cc: oracle-l@freelists.org User-Agent: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 47119 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: rjoralist@society.servebeer.com Precedence: normal Reply-to: rjoralist@society.servebeer.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: by amavisd-new-20030616-p10 (Debian) at avenirtech.net That would be just what I'm looking for. Alas, I don't think it's part of the 10gR1 Database Control. Thinking I probably can't attach a screenshot on the list, you'll have to take my word for it that my options for the Spot SQL tab of the Top SQL page in that dropdown are "Real Time: 15 Second Refresh", "...1 Minute...", and "...Manual...". The Period SQL link allows me to go back to The Beginning, but the granularity of the selection is 24 hours, making it impossible to pinpoint. Perhaps what you've described is a 10gR2 feature? I don't have a "Top Activity" page that I can find in 10gR2. If I can ever get R2/R3 GC installed, I'll check it out. I left work today with a new error displaying on the install, after fudging the date ahead a month to workaround the DST 2007 snafu. Maybe install/DEinstall number 7 will be my lucky one. Thanks, Brandon! Rich > You should be able to click on Historical in the View Data drop-down box > in the top-right corner of the Top Activity page and from there you can > go back as far as your AWR allows. > > Regards, > Brandon > > -----Original Message----- > From: oracle-l-bounce@freelists.org > > My off-the-top-of-my-head gripes with OEM 10gR1 *DB Control* so far: > > -- Can't see Top SQL from more than 1 hour ago via the web interface > (must manually use DBA_HIST views). -- http://www.freelists.org/webpage/oracle-l