Program Global Area A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when...
Real Time ADDM Real-Time ADDM automatically monitors the database in real time. Real-Time ADDM proactively detects and diagnoses transient high impact problems such as these before they threaten application performance: ■ High CPU ■ I/O sp...
Related Documentation For more information, see these Oracle resources: ■ Oracle Database Administrator's Guide xiv ■ Oracle Database Concepts ■ Oracle Database Net Services Administrator's Guide ■ Oracle Database SQL Language Referen...
Removing Oracle Database Software If you want to remove an Oracle software installation, you can use the deinstallation tool to completely uninstall the software from your computer. Starting with Oracle Database 12c, the deinstallation t...
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...
