This preface contains:
The following are changes in Oracle Database 2 Day + Performance Tuning Guide for Oracle Database 12c Release 1 (12.1.0.2).
The following features are new in this release:
Manageability support for In-Memory Column Store
The new Oracle Database In-Memory Column Store (IM column store) feature accelerates database performance of analytics, data warehousing, and online transaction processing (OLTP) applications.
SQL Monitor report, ASH report, and AWR report now show statistics for various in-memory operations.
In-memory statistics in SQL Monitor report: Activity % in Time and Wait Statistics panel, Activity column in Plan Statistics table, and Activity tab in SQL Monitor report show CPU consumed by SQL commands while executing in-memory query operations.
SQL Monitor report now supports Adaptive plans. The Execution plan shows Resolving or Resolved icon depending upon the current status of that plan. The Plan Statistics tab contains a drop down list to show current plan, final plan, and full plan. It also contains Plan Note button, which when clicked, shows the notes that are generated in the explain plan for the SQL statement.
In-memory statistics in ASH report: ASH report header table shows the size of in-memory pool under In Memory Area column. Top Events, Top SQL, and Activity Over Time sections show CPU consumption by various in-memory operations.
In-memory statistics in AWR report: AWR report contains a new section - In-Memory Segments Statistics - that shows in-memory segment consumption based on various attributes, such as, scans, DB block changes, populate CUs, and repopulate CUs. Time Model Statistics section shows statistics related to in-memory CPU usage and Instance Activity Statistics section shows statistics related to in-memory activities.
The following are additional changes in the release:
Changes in ASH Analytics page
In the Average Active Sessions chart on ASH analytics page, you can now click on CPU wait class to see its breakdown by CPU usage based on various in-memory operations as well as total CPU used for operations other than in-memory operations.
See "Determining the Cause of Spikes in Database Activity" for more information.
The following are changes in Oracle Database 2 Day + Performance Tuning Guide for Oracle Database 12c Release 1 (12.1.0.1).
The following features are new in this release:
Real-time database operations monitoring
Real-Time database operations monitoring tracks and reports on active and recently completed database operations. You can monitor details of the execution of a single SQL or PL/SQL statement. You can also monitor the progress of long-running operations such as a batch job, or extract, transform, and load (ETL) processing.
See "Monitoring Real-Time Database Operations" for information on this feature.
Oracle Enterprise Manager Database Control is no longer supported by Oracle. See Oracle Database Upgrade Guide for a complete list of desupported features in this release.
The following are additional changes in the release:
Oracle Enterprise Manager Cloud Control
In previous releases of Oracle Database, you used Oracle Enterprise Manager Database Control (Database Control) to manage database performance tuning from a graphical user interface. In this release, you can use the Oracle Enterprise Manager Cloud Control (Cloud Control) graphical user interface. Cloud Control provides more functionality than Database Control. The procedures in this guide use Cloud Control.
You must install Cloud Control separately from Oracle Database.
ASH Analytics page
Cloud Control has the ASH Analytics page, which graphically displays recent Active Session History information.
See "Determining the Cause of Spikes in Database Activity" for more information.
Real-Time ADDM
Cloud Control has the Real-Time ADDM page, from which you can run automatic database diagnostic monitoring in real time to diagnose problems with a slow or hung database.
See "Diagnosing Serious Performance Problems in Real Time" for more information.