ADDM ADDM performs its analysis on data that has been captured and stored in AWR. For ADDM, the default collection interval for a snapshot is one hour. Generally, ADDM is used for identifying systemwide systemic problems. It calls attention to ...
Administering Database User Accounts This section provides instructions for creating and managing user accounts for the people and applications that use your database. It contains the following topics: ■ Viewing User Accounts ■ Example: Creatin...
ARCHIVELOG and NOARCHIVELOG Mode One of the important decisions you need to make as a DBA is to determine if the database must be run in ARCHIVELOG mode or NOARCHIVELOG mode. The mode you choose depends on your availability and reliability requirements. It also impacts the type of backup and rec...
Assigning a Tablespace Quota to a User Account Suppose you are creating or modifying a user account named Nick. You want to assign Nick a space usage quota of 16 MB on his default tablespace. You must assign Nick a tablespace quota on his default tablespace before he can create objects in that t...
Audience Oracle Database 2 Day DBA is for anyone who wants to perform basic administrative tasks with Oracle Database. Only minimal basic knowledge of or experience with database management is required, and a basic knowledge of computers...
Autoextend Tablespace You can set a tablespace to automatically extend itself by a specified amount when it reaches its size limit. If you do not enable autoextend, then you are alerted when the tablespace reaches its critical or warning threshold size. The critical and warning threshold paramet...
Automated Upgrade Tasks After completing the pre-upgrade steps, DBUA automatically performs the following tasks: ■ Modifies or creates new required tablespaces ■ Invokes the appropriate upgrade scripts While the upgrade is running, DBUA shows ...
Automatic Database Diagnostic Monitor Oracle Database includes a self-diagnostic engine called Automatic Database Diagnostic Monitor (ADDM). ADDM makes it possible for Oracle Database to diagnose its own
Automatic Storage Management—This option enables you to place your data files in Oracle Automatic Storage Management (Oracle ASM) disk groups. If you choose Oracle ASM, then Oracle Database
Backing Up Your Database This section describes how to back up your database with RMAN. The Oracle suggested strategy for disk-only backups provides efficient daily backup of the database. This strategy enables you to quickly return your database to its state at any point during the previous 24 ...
