Re: OEM Cloud Control 13c strange Time Range for Top Activity

Kellyn,
Thank you for the links.
I checked the OMR health and the agent health, there is nothing problematic. I also did agent refresh configuration. But it didn't help. This agent has the same version as all the other agents. But no other monitored database has this messed up Top Activity view. Thank you,
Chen

On Mon, Apr 9, 2018 at 4:50 PM, Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> wrote:

> I don't want to distract you from looking at the ASH data, but there is
> one specific UI that is being effected here and it's cloud control. Could
> I recommend that we look at the performance tool that's built into EM to
> verify that's nothing to do with the collections/agent, etc.? If you're
> not comfortable with the agent verify, let me ask you to go into the EM
> main console and click on Settings on the right. Go down to Cloud
> Control...OK, I've obviously typed too much today, just check out these two
> blog posts and follow along:)
>
> www.oaktable.net/content/em12c-rel-4-oms-and-omr-health-part-ii
> dbakevlar.com/2014/12/oms-and-omr-performance-part-iii-metrics-page/
>
> Look and see if this target is listed as a problem child, (latency on
> collections, etc.)
>
> You can view the difference in target agent installation and you may find
> that you have an out of date agent installed, etc. that is causing you
> grief or metric collection intervals that are out of whack.
>
> Hope this helps,
> Kellyn
>
>
>
> [image: Kellyn Pot'Vin on about.me]
>
> *Kellyn Pot'Vin-Gorman*
> DBAKevlar Blog <http://dbakevlar.com>
> President Rocky Mtn. Oracle User Group <http://www.rmoug.org/>
> President Denver SQL Server User Group <http://denversql.org/>
> about.me/dbakevlar
>
>
> On Mon, Apr 9, 2018 at 4:13 PM, Chen Zhou <oracle.unknowns_at_gmail.com>
> wrote:
>
>> What kind of information should I look for? There are sessions "ON CPU"
>> or 'WAITING" at all hours from V$ACTIVE_SESSION_HISTORY and
>> DBA_HIST_ACTIVE_SESS_HISTORY.
>> Thank you.
>>
>> On Mon, Apr 9, 2018 at 4:54 AM, Hemant K Chitale <
>> hemantkchitale_at_gmail.com> wrote:
>>
>>> Can you query V$ACTIVE_SESSION_HISTORY or DBA_HIST_ACTIVE_SESS_HISTORY
>>> in the target DB Instance to see if there is info on active sessions in the
>>> "missing" window ? Use SAMPLE_TIME
>>>
>>>
>>>
>>> sent from my mobile phone
>>>
>>> On Wed, 4 Apr 2018, 05:20 Chen Zhou, <oracle.unknowns_at_gmail.com> wrote:
>>>
>>>> Hi,
>>>> I wonder if anyone had this problem before. One of the monitored
>>>> databases/Performance/Top Activity page opens up perfectly normal with 1
>>>> hour time range. After 15 seconds, the page is auto-refreshed, then the
>>>> time range is changed to about 4 hours. There is a 3-hour gap with no
>>>> performance data.
>>>>
>>>> This OEM monitors other databases, but only this particular database
>>>> has this problem. And it doesn't matter which browser I use. I tried to
>>>> remove the database target and re-register it and it didn't help.
>>>>
>>>>
>>>> Thank you,
>>>> Chen
>>>>
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image.png