Lesson 1

Welcome to Database Administration Features.
This course introduces you to the object-oriented paradigm within the context of Oracle, then focuses on the SQL and PL/SQL commands for creating, modifying, and manipulating data within objects such as object tables and related object tables. This course also covers

1. nested tables,
2. varrays,
3. LOBs,
4. object types, and
5. objects embedded

within relational tables. You will learn the steps necessary to create and use methods written in PL/SQL to manipulate data within objects. This is the first course in the five-part Oracle New Features Certification Series.
Taken in conjunction with the other courses within this website, this course will prepare you to pass the Oracle Features for Administrators certification exam.
Along the way, you will work on a series of course projects and exercises that will give you a chance to put your new skills to use in the context of actual business scenarios.

1. Simplified and improved automatic memory management^[1]. You can now set a single initialization parameter (MEMORY_TARGET) to indicate the total amount of memory that is to be allocated to the database (the SGA and instance PGA). The system then automatically and dynamically tunes all SGA and PGA components for optimal performance. You can still designate minimum sizes individually for the SGA and instance PGA.
2. New fault diagnosability infrastructure to prevent, detect, diagnose, and help resolve critical database errors
   The goals of the fault diagnosability infrastructure are preventing and detecting problems (critical errors) proactively, limiting damage and interruptions after a problem is detected, reducing problem diagnostic time, reducing problem resolution time, and simplifying customer interaction with Oracle Support. The framework includes technologies such as health checks that run when a critical error occurs; proactive in-memory tracing for many database components to permit first-failure data capture; an Incident Packaging Service that packages all diagnostic data for a problem into a zip file for transmission to Oracle Support; and Enterprise Manager Support Workbench, which provides a graphical environment for investigating, reporting, and resolving problems. Also included is integration with the new SQL Repair Advisor, for diagnosing and repairing SQL-related problems, the SQL Test Case Builder, which gathers all required schema and environment information to enable a SQL problem to be reproduced on another Oracle database, and the Data Recovery Advisor, which helps diagnose, evaluate the impact of, and repair data corruptions and other data failures.

[1]automatic memory management: With automatic memory management, the Oracle instance dynamically tunes all memory components to optimize performance as the workload changes.