Oracle Tips and Techniques

The Oracle Enterprise Manager 11g Grid Control is Oracle solution to manage Grid environment that allows businesses to heighten application performance and deliver unparalleled IT infrastructure reliability.

All kings of business, small, medium or large can attain measurable IT cost savings by extending the availability of computing resources, cultivating more productive and effective administrators, and achieving higher quality of service. This can all be achieved by installing Oracle Enterprise Manager 11g Grid control to manage your Oracle technology stack.
In previous versions of Oracle Enterprise Manager (before 10g), it was mostly used for Oracle database management But the latest versions introduced Oracle Enterprise Manager 11g Grid Control capabilities of managing your infrastructure by monitoring/managing
- oracle databases
- oracle database servers or hosts
- application management
- application performance monitoring
- process monitoring
- streams
- active dataguard
- database replication
- cost-effective and easy automated configuration management
- oracle provisioning

Oracle Enterprise Manager 11g Grid Control has three major components which are
- Oracle WebLogic Server
- Oracle Management Service (OMS)
- Repository Database
- Oracle Management Agent

Oracle Weblogic Server is Oracle’s replacement for Oracle Application Server which was used till Oracle Enterprise Manager 10g. but 11g introduced
Oracle Weblogic Server, a more robust and stable application server. The Main engine or software for OEM is the OMS. That is a Java application
that sits on Oracle Webologic Server. The OMS interacts with Oracle repository database, Agents on targets, and Oracle Weblogic Server and provides an efficient web browser based Grid Control environment.

Oracle Repository database is an Oracle database that stores all the configuration data and stats sent from the agents. This data is displayed on users
logic and Oracle Enterprise Manager through Grid Control.

Other functionalities that Oracle Enterprise Manager 11g Grid Control includes
- Run ADDM Report
- Run ASH Report
- Capability to chaneg system parameters
- Run SQL Advisor
- Run Segment Advisor
- Run MTTR advisor
- SQL Performance Analyzer
- Streams Performance Advisor
- SQL Advisors
- Memory Advisors
- Automatic Undo Management
- Maximum Availability Architecture (MAA) Advisor
- Segment Advisors
- Viewing, purging and archiving Alert logs
- Viewing, purging and archiving Trace files
- Blackouts
- Apply Patch
- Scheduler Central
- SQL Worksheet
- Export to Export Files
- Import from Export Files
- Import from Database
- Load Data from User Files
- Monitor Export and Import Jobs