Getting Started with Database Administration This chapter provides a brief roadmap for administering your database. It introduces you to Oracle Enterprise Manager Database Express (EM Express), the Web-based interface for managing an Oracle database. This chapter contains the following sections:...
Granting Access to EM Express for Nonadministrative Users As a database administrator, you can log in to EM Express with the SYS or SYSTEM user account to perform administrative and other tasks. Nonadministrative users may also want to log in to EM Express. For example, application developers may...
How to Use This Guide with Related Material This guide is part of a comprehensive set of learning material for administering Oracle Database, which includes a 2 Day DBA Oracle By Example (OBE) series, available on the Web. Every chapter in
Image Copies and Backup Sets Database backups created by RMAN are stored as image copies or backup sets. Image copies are exact byte-for-byte copies of files. You can create an image copy by copying a file at the operating system level. Unlike copying files at the operating system level, however...
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...
