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_at_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