Hi Allen, Sorry for the delay -- I needed to get safe access to the Doc attachment and I didn't have that until now... Yes, the historical dropdown is there in 10gR1, but it only allows me to drill down to a 24hr period. The "Top SQL" drill down screen shows only the last 60 minutes. Thanks for checking! Rich > I'm not sure about attachments on the list either, but I've attached > screenprints of what I see in 10.2 so you can see it at least. I've > never seen 10.1, so I don't know for sure, but it could very well be a > new feature of 10.2. > > -----Original Message----- > From: Rich Jesse [mailto:rjoralist@xxxxxxxxxxxxxxxxxxxxx] > Sent: Monday, March 26, 2007 9:23 PM > To: Allen, Brandon > Cc: oracle-l@xxxxxxxxxxxxx > Subject: RE: OEM poll > > 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@xxxxxxxxxxxxx >> >> 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). > -- //www.freelists.org/webpage/oracle-l