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

Configure Target - connection failed
public reports: just one public area for all public reports?
SNMP on Standard Edition RAC, do I need to pay for a license
RAC 11g listener isssue on Hp-unix 11.31 unable to connect host
monitor alert log with grid control
Question re editing OEM RMAN script
error installing 11gr1 oem agent on AIX 6.1
agent 10g vs oms 11g
WebLogic tier: Do you choose a Typical or Custom install?
Define Notifications Rule for a specific users
SUDO on Grid Control Not Working/Cannot Set Default Credentials to Use SUDO
Grid Control reliance on Flash
JDK version for Grid Control: newer updates ok?
How to avoid OCM reinstall through OPatch when using EM Harvester?
Grid Control 11g Installation Unable to find Weblogic Server
Monitoring ADF Application using EM ?