Oracle OCP 12c Enhancements for the DBA
Contents
- 1 Emergency Monitoring
- 2 The ADDM Compare Period Report
- 3 Diagnosing Performance Issues Using ASH Enhancements
- 4 ADR and Network Enhancements
- 5 SQL Enhancements for Data
- 6 Oracle Data Pump Enhancements
- 7 SQL*Loader and External Table Enhancements
- 8 Partitioning Enhancements
- 9 SQL Enhancements for Storage and Course Summary
- 10 Internal Links
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