Fundamentos del lenguaje PL/SQL.--Estrcuturas de control.--Control de transacciones.--Creación de tipos.--SQL vs PL/SQL.--Cursores.--Subprogramas.--Paquetes.--Paquetes determinados.--Disparadores o triggers.--Tratamiento de errores.--Cursores avanzados.--Objetos.--Entornos de ejecución PL/SQL Meeting OEM repository database requirementsChapter 2: Installation of OEM 12c; Introduction; Installing Enterprise Manager System with Simple configuration option; Installing Enterprise Manager System with Advanced configuration option; Understanding Advanced Installer options; Installing Oracle Management Agent using the RPM file; Installing Oracle Management Agent using the agentDeploy.sh script; Chapter 3: Upgrade to OEM 12c; Introduction; Performing pre-upgrade tasks; Upgrading using the 1-system upgrade approach (on the same host). Upgrading using the 2-system upgrade approach (on a different host)Chapter 4: Configuring OEM 12c; Introduction; Prerequisites for configuring automatic discovery; Adding host targets manually; Configuring Administration Groups; Chapter 5: Managing Oracle Database Using OEM 12c; Introduction; Configuring a database target; Provisioning Oracle Database software; Chapter 6: Managing Database Performance Using OEM 12c; Introduction; Using the Real-Time Automatic Database Diagnostics Monitor (ADDM) feature; Using the Compare Period Automatic; Database Diagnostics Monitor (ADDM) feature. Comparing period reportsChapter 7: Middleware Management Using OEM 12c; Introduction; Integrating BI Publisher with Enterprise Manager 12c; Implementing BI Publisher Security Model; Managing and monitoring Oracle GoldenGate; Setting up JVM Diagnostics (JVMD) Manager in Cloud Control; Discovering and managing Weblogic Server Target; Deploying JVMD Agents on Weblogic Target nodes; Chapter 8: Incident and Problem Management Using an iDevice (iPhone, iPod Touch, or iPad); Introduction; Setting up OEM12c on an iDevice; Using Incident management on an iDevice; Using proble management on an iDevice.
As a Packt Cookbook, you can expect this book to be full of useful and practical recipes to common and important tasks faced by professional database administrators. This book is for Oracle Database, Middleware, System, and Infrastructure Administrators. A basic understanding of Oracle Enterprise Manager is needed, as well as being comfortable using command line environments.