RE: How to modify a metric collection interval in Grid Control?

Alright.  I modified the database.xmlp file again and changed the interval to 5 
minutes for TABLESPACE ALLOCATIONS and it is gathering tablespace data every 5 
minutes.

The ALL METRICS page still says "Every 7 Days" so I guess this is a static 
element stored somewhere for "ALL Metrics" and doesn't update based on the 
actual rate of the collection.

Anyway, succesfully gathering tablespace data now more than every 7 days.  Yay!



Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
 

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Taylor, Chris David
Sent: Wednesday, November 04, 2009 8:53 AM
To: 'rjoralist@xxxxxxxxxxxxxxxxxxxxx'; 'oracle-l@xxxxxxxxxxxxx'
Cc: 'Howard Latham'
Subject: RE: How to modify a metric collection interval in Grid Control?

 
I think I found it.

It's not stored in the db at all it seems.

It uses xml files in the $AGENT_HOME/sysman/admin/default_collection.

I found the "database.xmlp" file which defined the 7 Day interval for 
Tablespace Allocation.

Here's the entry in the file:

<!--
  ======================================================================
  == Category: Tablespace Allocation
  == DB Versions: pre-8 to 10gR1
  == Fetchlet: SQL
  ======================================================================
  -->
  <CollectionItem NAME="tbspAllocation">
    <ValidIf>
        <CategoryProp NAME="VersionCategory" 
CHOICES="pre8;8i;8iR2;9i;9iR2;10gR1;10gR2;10gR203;11gR1"/>
    </ValidIf>

    <Schedule>
      <IntervalSchedule INTERVAL="7" TIME_UNIT="Day"/>
    </Schedule>

    <MetricColl NAME="tbspAllocation" />
  </CollectionItem>

ALTHOUGH, I updated this to "1" day, and reloaded the agent, Grid Control is 
still showing "7" days under All Metrics for this target.

It appears I'm still missing something.


Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
 

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Rich Jesse
Sent: Wednesday, November 04, 2009 8:36 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Re: How to modify a metric collection interval in Grid Control?

Hey Chris,

> Is there a way to modify the collection interval for a metric in Grid 
> Control?
>
> I have a Database Target and I goto "ALL METRICS".  Under this menu I 
> see "TABLESPACE ALLOCATION" that has both "Allocated Space" and "Used Space".
> The collection interval is set to "Every 7 Days".  How can I modify 
> this collection interval to be less than 7 days?

Actually, you'd be looking for the "Metric and Policy Settings" link to change 
that, but of course I don't see it there on 10.2.0.3.0.

One workaround would be to create your own metric, but that seems a bit silly, 
plus you wouldn't have any of the history transferred to your new metric.

If you get an answer from Oracle, can you post it please?

GL!

Rich


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




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




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


Other related posts: