Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: OEM poll

RE: OEM poll

From: Rich Jesse <>
Date: Sun, 1 Apr 2007 23:42:25 -0500 (CDT)
Message-ID: <41382.>

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!


> 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 []
> Sent: Monday, March 26, 2007 9:23 PM
> To: Allen, Brandon
> Cc:
> 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:
>> 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).

Received on Sun Apr 01 2007 - 23:42:25 CDT

Original text of this message