User Defined Types and Large Objects (LOBs) Your new table can include one or more columns defined with user-defined types. User-defined types enable a single column in a single row to contain multiple values. The multiple values can be represented as arrays, nested tables, or objects, where an o...
Using Data Recovery Advisor The recovery process begins when you either suspect or discover a failure. You can discover failures in many ways, including error messages, alerts, trace files, and health checks. You can then use Data Recovery Advi...
Validating Backups and Testing Your Backup Strategy As part of your backup strategy, you should periodically check whether your backups are intact and can be used to meet your recoverability objectives. You can validate your backups in the following ways: ■ Select specific backup sets or image c...
Validating Backups for Restore Operations You can test whether a sufficient set of backups exists that can be used to restore the specified database files. After you specify which tablespaces to restore and, possibly, a time as of which to restore them, RMAN selects a set of backups that contain ...
Validating Compiling Invalid Schema Objects As a database administrator (DBA), you may be asked to revalidate schema objects that have become invalid. Schema objects (such as triggers, procedures, or views) might be invalidated when changes are made to objects on which they depend. For example, ...
Viewing a Summary of ADDM Performance Findings ADDM analysis results consist of a description of each finding and a recommended action. You can view a summary of findings and their impacts on the system. To view a summary of ADDM performance...
Viewing a Summary of Current ADDM Findings Current ADDM Findings analysis results consist of a description of each current finding and a recommended action. You can view a summary of current ADDM findings and their impacts on the system. To view Current ADDM Findings: 1. In EM Express, from the...
Viewing a Summary of Real Time ADDM Findings Real-Time ADDM results consist of a description of each finding and recommended actions for some findings at the point in time when the Real-Time ADDM report was generated. You can view a summary of findings and their impacts on the system. To view a ...
Viewing and Modifying Initialization Parameters This section provides instructions about viewing the initialization parameter settings for your database and modifying these parameters. You can modify the initialization parameters for the database in one of three ways: ■ Until the instance is shu...
Viewing Automatic SQL Tuning Results You can track the activities of the Automatic SQL Tuning Advisor with EM Express. To view automatic SQL tuning results: 1. In EM Express, from the Performance menu, choose SQL Tuning Advisor. The SQL Tun...
