To modify the instance PGA size: 1. In EM Express, from the Configuration menu, select Memory. The Memory Management page appears. If the database has either automatic shared memory management o...
To perform a basic installation: 1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and to create and run the database. Refer to your operating system-specific documentation or contact your system administrator to determine w...
To perform a whole database backup when the database is open: 1. Connect RMAN to the target database as described in "Connecting to the Target Database" on page 9-9. 2. Ensure that your database is in ARCHIVELOG mode as described in "Enabling Archiving of Redo Log Files" on p...
To perform the Flashback Table operation: 1. Connect RMAN to the target database as described in "Connecting to the Target Database" on page 9-9. 2. Determine whether the table that you intend to flash back has dependencies on other tables. Use the following SQL query to determine the...
To predict the percentage of reads saved for different database cache sizes: 1. In EM Express, from the Configuration menu, select Memory. The Memory Management page appears. In the Memory Settings section, the Management Mode value is Manual in...
To set a tablespace to automatically extend: 1. In EM Express, from the Storage menu, select Tablespaces. The Tablespaces page appears. 2. Select the bigfile tablespace for which you want to enable autoextend, and then click Edit Auto Extend. The Auto Extend Setting of Bigfile Tablespace page a...
To start SQL*Plus and connect to the database from the Windows Start menu: 1. Configure the operating system environment variables, as described in "Configuring the Operating System Environment Variables" on page 3-2. 2.
To start SQL*Plus and connect to the database from the command line: 1. Open a command window. 2. Configure the operating system environment variables, as described in "Configuring the Operating System Environment Variables" on pag...
Typical—This method requires little configuration, and allocates memory as a percentage of total overall physical system memory. Select Typical and enter a value in the Memory Size (SGA and PGA) field. The percentage of memory represented by the ...
Understanding Network Configuration A client is any application that connects to Oracle Database to send or retrieve data. An Oracle Database client application can reside on any computer that has Oracle Database client software installe...
