Duration: 5 days
This Oracle Database 12c: New Features for Administrators training class teaches the major major new features of the Oracle 12c database of interest to database and other enterprise administrators.
The primary target audiences for this textbook is database administrators, storage administrators, system administrators, implementation specialists, and data center support engineers.
• Learn about enhancements to the administration framework of the database, including the Enterprise Manager Cloud Control, Enterprise Manager Database Express and SQL Developer database administration capabilities.
• Learn enhancements to the security framework of the database, including unified auditing, fine-grained super administrator privileges, data redaction and privilege analysis.
• Learn to expand performance options such as in-memory columnar storage, the in-memory database option and big table caching.
• Learn performance monitoring enhancements, such as database operation monitoring, emergency monitoring, and real-time ADDM.
• Learn database consolidation using consolidated databases (cDBs) consisting of dozens or even hundreds of pluggable databases (pDBs).
• Learn advanced database storage options such as advanced compression, enhanced columnar compression and online movement of objects.
• Learn advanced compression techniques for tables and indexes.
• Learn about columnar vs. row-oriented database storage and the use of hybrid columnar compression.
• Learn heat map tracking of segment access to measure hot, warm and cold areas of the database that could be targeted for optimization.
• Learn iLM data management and support for that framework with available features of the Oracle database.
• Learn automatic data optimization and policies that automatically implement the ILM concepts of row-level compression tiering, segment-level compression tiering and segment-level storage tiering.
• Learn to implement custom ILM storage management policies.
• Learn about in-memory storage of database objects, including big table caching, full database caching and in-memory column stores.
• Learn to archive inactive data inside the database while not degrading performance while limiting added storage costs.
• Learn to introduce temporal validity into a table and perform flashback query operations using temporal validity criteria.
• Learn about data redaction that allows data privacy policies to be dynamically enforced during queries.
Method of Delivery
• Onsite/Live class instructions or Online web conference
• Open discussion
• Case studies