Backup Tags A tag is a text string that identifies a backup, either uniquely or as part of a group of backups. All RMAN backups, including incremental backups, are labeled with a tag. For example, if you performed a full database backup every Saturday, then you could use the tag FULL_SAT to iden...
Block Size—Use this list to select the block size, or accept the default. Oracle Database data is stored in data blocks of the size specified. One data block corresponds to a specific number of bytes of physical space on disk. Selecting a block size other than the default 8 kilobytes (KB) value r...
Changing Undo Management Analysis Parameters You can change the current analysis period and the desired undo retention period. To change the analysis period and the undo retention period: 1. Go to the Undo Management Details page, as described i...
Character Sets Use this tab to define the character sets used by your database. Character sets are the encoding schemes used to display characters on your computer screen. The character set determines what languages can be represented in the d...
Checking Prerequisites Before installing the software, OUI performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation. If your computer does not meet a requirement, then an error message is displayed. T...
Administering the Database with SQL-Based Management Tools In addition to using the graphical user interface (GUI) pages presented in EM Express, you can use other Oracle tools such as SQL Developer and SQL*Plus to administer your database. These tools enable you to perform database management op...
About Schema Objects A schema is a collection of database objects. A schema is owned by a database user and shares the same name as the user. Schema objects are logical structures created by users. Some objects, such as tables or indexes, hold data. Other objects, such as views or synonyms, cons...
Advantages of Using Templates Using templates has the following advantages: ■ Time saving. If you use a template, then you do not have to define the database. ■ Easy duplication. By creating a template containing your database settings, you can easily create a duplicate database without specifyi...
Changing the Configuration of a Database Using DBCA You can use DBCA to change the configuration of an existing database. For example, you can make configuration changes such as: ■ Add database options that were not previously configured (for example, Oracle Label Security or Oracle OLAP) ■ Cha...
Computing the Minimum Undo Tablespace Size Using the Undo Advisor If you must change the undo tablespace to a fixed size, then use the Undo Advisor to help determine the minimum required size. You can also use the Undo Advisor to set the minimum undo retention period. To configure the undo table...
