RE: OEM poll

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_at_society.servebeer.com]
> Sent: Monday, March 26, 2007 9:23 PM
> To: Allen, Brandon
> Cc: oracle-l_at_freelists.org
> 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_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