Indexes and Performance Indexes generally improve the performance of queries and DML statements that operate on a single, existing row or a small number of existing rows. However, too many indexes can increase the processing overhead for sta...
Common Oracle DBA Tasks As an Oracle DBA, you can expect to be involved in the following tasks: ■ Installing Oracle software ■ Creating Oracle databases ■ Performing upgrades of the database and software to new release levels ■ Starting and shutting down the database instance ■ Managing the st...
Installing Oracle Database Software This section briefly describes the steps for a desktop-class installation. Most steps are common to all platforms and involve running the Oracle Universal Installer. Platform-specific steps are noted. ...
Introduction to Oracle Enterprise Manager Database Express Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management a...
Loading Data into a Table You can use SQL Developer to load data into a table. You can load data from an .xls file or a .csv file into the table. In this example, you load data into the PURCHASE_ORDERS table that you created in "Example: C...
Managing Templates with DBCA DBCA templates are XML files that contain information required to create a database. Templates are used in DBCA to create new databases and duplicate existing databases. The information in templates includes database options, initialization parameters, and storage at...
Managing the Online Redo Log The online redo log files are a critical component in database recovery. Every transaction in the database updates the redo logs, regardless of whether archiving is enabled. During crash, instance, or media recovery, the database properly applies redo log files in as...
Media Recovery If you restore the archived redo log files and data files, then you must perform media recovery before you can open the database. Any database transactions in the archived redo log files not reflected in the data files are applied to the data files, bringing them to a transaction-...
Modifying a Role Suppose your applications make use of Oracle Streams Advanced Queuing, and you determine that developers must be granted the roles AQ_ADMINISTRATOR_ROLE and AQ_ USER_ROLE to develop and test their applications. You must edit the APPDEV role to grant it these two Advanced Queuing...
Monitoring Fast Recovery Area Space Usage It is important to monitor space usage in the fast recovery area to ensure that it is large enough to contain backups and other recovery-related files.
