Oracle OCP 12c Enhancements for the DBA

From Minor Miracle Software
Jump to: navigation, search

Emergency Monitoring

  • Memory Access Mode - Lightweight connection. No queries, but you can access the instance. 12c has emergency monitoring and ADDM active by default.

Automatic Database Diagnostics Monitor (ADDM) - Real-time,


The ADDM Compare Period Report

ASH - Active Session History

Diagnosing Performance Issues Using ASH Enhancements

ADR and Network Enhancements

Automatic Diagnostic Repository

V$DIAG_INFO


SQL Enhancements for Data

  • Extended column is 32k. But must be installed and upgraded.

old port 1521.

Oracle Data Pump Enhancements

SQL*Loader and External Table Enhancements

Partitioning Enhancements

SQL Enhancements for Storage and Course Summary

Internal Links

Parent Article: Oracle Database