Oracle Enterprise Manager 11g Segment Advisor consumes significant CPU time
Oracle Enterprise Manager 11g is no doubt a very useful tool for database administrators. Whoever has used it can testify that it makes life so easier. For example the Oracle Enterprise Manager 11g Segment Advisor can give very useful information at the click of buttons. Getting these information through command line will need significant effort as well as knowledge.
But we must also be aware that it can also have significantly detrimental effect on your production database if you do not control usage.
If you maintain a database in a corporate environment it may be sometime necessary to give access to your Oracle Enterprise Manager 11g to management stuff who may not be too tech savvy or at least with Oracle technologies. What they may be looking for is just to monitor activities or trends. But if they start running different advisors then it may impact a production database.
Today I was running Segment Advisor for just two tablespaces. One of them was 125G and another 32G. While running the segment advisor from one Oracle Enterprise Manager session I monitored the impact of this activity from another session through the database instance performance tab.
The impact looks significant to me. Note that this database is a non production database and was quite (meaning no serous activity happening at the time of running).
This is how looks in Top Activity screen
Oracle Enterprise Manager 11g Grid Control
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
Recent Comments