Understanding the SQL Developer User Interface When you start SQL Developer, the SQL Developer window appears. The SQL Developer window generally uses the left side for navigation to find and select objects, and the right side to display informa...
Undo Retention Oracle Database automatically ensures that undo data that is in use by an active transaction is never overwritten until that transaction has been committed. After the transaction has been committed, the space occupied by that undo data can be reused, or overwritten. In this case, ...
Upgrading a Database Using DBUA Complete the following steps to upgrade a database using DBUA. If you need help at any page or want to consult more documentation about DBUA, then click the Help button to access the online Help. To upgrade a dat...
Use Common Location for All Database Files—This option requires you to specify a new directory for the Oracle home. All the database files are created in this location. Later, you can make modifications to database file names and locations. If you specify the Use Oracle Managed Files option,
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...
