Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



Enterprise Manager

How to define a Reference Collection for SQL Response Time

Hi, I'm working on a Grid Control with database On the database page we have this nice little graph showing two bars with Latest Collection and Reference Collection.  Clicking either one of these in the legenda brings me to the "SQL Response Time Latest Collection" page. Showing some tables. One of these is named "General".  In the "General" table there is a column "Reference Collection" (Are you still following me??).  How to define the period that is covered in this Reference collection? If I click the button "Reset Reference Collection" is clears the reference data obviously, and seems to take a new 300 second period. Starting immediately as new reference. But I'd like to collect all day, let's say from 9 AM till 5 PM, so that makes a 8*60*60=28800 second reference period. Is this possible? How? Do I overkill or blow up the system if I do this???  Thx

Select target database and go to the bottom screen. Select "Metric Baselines", most likely  Metric Baselines are currently disabled for this database instance.  Solution re-enable Enabling metric baselines causes a small set of instance performance metrics to be persisted to the Automatic Workload Repository. Click the Enable Metric Baselines button to enable this feature now.  George

Related Links

Creating a user within OEM to monitor user activity
AD4J Console application is stopping after every now and then
Steps to migrate OMR from single node to RAC
Settinggs for Generic Alert Log Metric, OEM GC 10204
2 agents per host
Backup job fails with error
Scheduled backup job is failing
standby db rolling upgrade for EM Grid?
How to use em2go mobile OEM application
Which other Useful Reports(Scheduled) Can i fetch from OEM grid Control?
media creation?
Grid Control not able to Discover WebSphere 6.1.x
OMS won't start
Installing GC R5 on SLES 10
Can multistep job be set up to run job B after job A completes?
EM doesn't connect with database