We received tons of questions from our recent Oracle Enterprise Manager 12c Online Forum, we wanted to continue to provide answers to the most popular ones. In this installment, we'll cover questions from the DBA and developer track.
Q. What kind of testing do you recommend for upgrading from Oracle Database 11gR1 to 11gR2?
A. Oracle Real Application Testing using Database Replay and SQL Performance Analyzer's capabilities are recommended for any Oracle Database upgrade. Check out these resources for more details: Oracle Real Application Testing datasheet and OTN for details on upgrading your database.
Q. Can I manage Oracle Exadata and traditional Oracle Databases from the same console?
A. Yes, you can manage Oracle Exadata and single instance and/or RAC databases from the same Oracle Enterprise Manager Cloud Control console, as well as WebLogic and many other targets. Check out this demo to see how.
Q. I thought Active Session History (ASH) was intended for real-time?
A. ASH can be use for both real-time and historical analysis. It is a black box that records session activities and helps to analyze across several performance dimensions. Click here to see a quick demo.
Q. What is the difference between Oracle Enterprise Manager 12c and Oracle Database Control?
A. Database Control is a subset which runs off a single database. Oracle Enterprise Manager 12c is a central repository which allows administrators to manage and monitor from a single console.
Q. How does Real-Time Automatic Database Diagnostics Monitor (ADDM) work – the database is hung right?
A. Real-Time ADDM, included in the Oracle Diagnostic Pack for Oracle Database, uses 2 different modes of connection to the database. A normal connection and a diagnostic mode that is a lock less, latch less connection which allows only few actions. Using the diagnostic mode connection Real-Time ADDM performs a hang analysis and determines any blockers in the systems. Check out this demo to see how Real-Time ADDM works.
Q. Can we achieve all the new functionality in Oracle Enterprise Manager 12c using terminal?
A. No. Features like ASH Analytics, Real-Time ADDM and Compare Period ADDM are only available using Oracle Enterprise Manager 12c's console.
Q. Is Real-Time ADDM available only in Oracle Enterprise Manager 12c?
A. Yes, Real-Time ADDM is a new feature in Oracle Enterprise Manager 12c.
Q. Can you explain the difference between Oracle Database 11g Monitor in Memory Access Mode vs. Real-Time ADDM direct access to SGA?
A. Real-Time ADDM does not use Memory attach mode. We use a proprietary connection method which connects using a lock less, latch less connection bypassing the SQL Access layer.
Q. Is there any limit on the number of days on which ASH can be used for analysis?
A. The in memory ASH data is typically available for 1 hour or till the point the memory buffer is flushed to disk. You can find out ASH retention by using: select min(sample_time), max(sample_time) from sys.WRH$_ACTIVE_SESSION_HISTORY;
From more Oracle Database Management product information check out these resources: