Responding to ADDM Performance Findings You can act upon the recommendations that accompany ADDM performance findings. To respond to ADDM performance findings: 1. In the ADDM Tasks table on the ADDM tab of the Performance Hub page, click th...
Restoring and Recovering the Database This section demonstrates how to restore and recover the entire database using RMAN. This example assumes that you are restoring and recovering your database after the loss of one or more data files, but you still have a usable server parameter file and cont...
Rewinding a Database Using Oracle Flashback Database Unlike the other flashback features, Oracle Flashback Database operates at a physical level. When you use Flashback Database, your current data files revert to their contents at a previous time. The result is similar to database point-in-time r...
RMAN Repository RMAN maintains a record of database files and backups for each database on which it performs operations. This metadata is called the RMAN repository. When you request recovery of a database, RMAN uses the repository metadata to choose the most efficient backups needed for this re...
Running the SQL Tuning Advisor Use the SQL Tuning Advisor for tuning SQL statements. Typically, you run this advisor in response to an ADDM performance finding that recommends its use. You can also start the SQL Tuning Advisor manually. One reason is to tune statements that the Automatic SQL Tun...
Installation Method The installation methods are divided into Desktop Class and Server Class: ■ Desktop Class—This installation class is most appropriate for laptop or desktop computers. It includes a starter database and requires minimal configu...
Setting the Datafile for a Smallfile Tablespace to Automatically Extend This section explains how to set a datafile for a smallfile tablespace to automatically extend when it reaches its size limit. The following instructions assume that the datafile was previously not an autoextending datafile. ...
Shutting Down and Starting Up Using SQL*Plus You can shut down and start the Oracle instance using SQL*Plus. To shut down and start the Oracle instance using SQL*Plus: 1. Start SQL*Plus and connect to the database. See "Shutting Down and Starting Up Using SQL*Plus" on page 5-8. 2. Iss...
Shutting Down and Starting Up Using the Windows Services Program On Microsoft Windows, you can also start and shut down your Oracle database using the Services program in Control Panel. You must start or stop the following services: ■ OracleServiceSID, which is your Oracle instance. ■ OracleORAC...
Software Installation Directories You must specify the directory in which the Oracle Database software is installed, or the location where the product binary files are copied from the installation media. You must choose a location that h...
