Oracle Enterprise Manager 10g R2 Grid Control: 2005 8
Oracle Enterprise Manager 10g R2 Grid Control:... 3... 3 GRID CONTROL... 4... 4... 4... 5... 5 GRID CONTROL... 5... 5 SQL /... 6... 7 HANG ANLYSIS... 7 SGA /... 8... 9... 9 SQL DETAIL / SESSION DETAIL... 10 ASH... 12 REAL APPLICATION CLUSTERS... 13 TOPOLOGY... 13... 15 CLUSTER CACHE COHERANCY... 16... 16 Oracle Enterprise Manager 10g R2 Grid Control: 2
Oracle Enterprise Manager 10g R2 Grid Control: IT Oracle Enterprise Manager 10g Grid Control DBA Grid Control Oracle Oracle DBA Enterprise Manager Grid Control 10g Release 2 Grid Control 10g Grid Control IT Enterprise Manager 10g Grid Control Release2 IT IT IT IT IT IT Enterprise Manager 10g Grid Control IT Oracle Enterprise Manager 10g R2 Grid Control: 3
GRID CONTROL Grid Control Web Oracle Grid Control IT IT Oracle Web Grid Control Grid Control Web IT DBA Oracle DBA DBA Grid Control Grid Control Grid Control Oracle Enterprise Manager 10g R2 Grid Control: 4
Grid Control IT IT Grid Control Grid Control IT Grid Control Grid Control GRID CONTROL Enterprise Manager 10g Release 2 1 Oracle Enterprise Manager 10g R2 Grid Control: 5
Grid Control 1 SQL / DBA Enterprise Manager Grid Control SQL SQL Plus SQL Oracle Enterprise Manager 10g R2 Grid Control: 6
Enterprise Manager Grid Control Release 2 1 Oradebug API Oracle Enterprise Manager 10g R2 Grid Control: 7
SGA / Memory Access SQL SGA X$ tables Oracle Enterprise Manager 10g R2 Grid Control: 8
DBA Enterprise Manger Grid Control 10g Active Session History ASH Automatic Workload Repository AWR Automatic Database Diagnostic Monitor ADDM AWR Grid Control Grid Control Oracle Enterprise Manager 10g R2 Grid Control: 9
SQL DETAIL / SESSION DETAIL Average Active Sessions Active Sessions Working Waiting SQL SQL Detail Session Detail SQL ID SQL Details SQL 1 SQL Historical Historical SQL Tuning Advisor SQL Plan Oracle Enterprise Manager 10g R2 Grid Control: 10
SID ID SID Sessions Detail Activity 5 SQL Oracle Enterprise Manager 10g R2 Grid Control: 11
ASH Oracle DBA Enterprise Manager Grid Control Active Session History Run ASH Report 1 SQL ASH SQL Oracle Enterprise Manager 10g R2 Grid Control: 12
REAL APPLICATION CLUSTERS Enterprise Manager RAC DBA RAC Enterprise Manager Enterprise Manager RAC Enterprise Manager Enterprise Manager 1 RAC Enterprise Manager Enterprise Manager TOPOLOGY Topology ASM Topology Oracle Enterprise Manager 10g R2 Grid Control: 13
Oracle Enterprise Manager 10g R2 Grid Control: 14
Grid Control Interconnects Oracle Cluster Interconnects Interfaces by Hosts Interfaces in Use by Cluster Databases Hosts Oracle Enterprise Manager 10g R2 Grid Control: 15
CLUSTER CACHE COHERANCY Cluster Cache Coherency Global Cache Block Access Latency Global Cache Block Transfer Rate Block Access Statistics 3 Enterprise Manager Grid Control Oracle Web Oracle Release 2 Grid Control Grid Control Enterprise Manager Grid Control Oracle Enterprise Manager 10g R2 Grid Control: 16
Oracle Enterprise Manager 10g R2 Grid Control: 2005 8 : [OPTIONAL] : [OPTIONAL] Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Copyright 2005, Oracle. Oracle JD Edwards PeopleSoft Oracle Corporation