Monitoring General Database State and Workload The Database Home page enables you to monitor the state and workload of your database. It provides a central place for general database state information and is updated periodically. To monitor the general database state and workload: 1. Go to the ...
Monitoring Performance Using the Performance Hub The Performance Hub allows you to view all the performance data available for a specified time period. Once a time period is selected, the performance information is collected and presented ba...
Multiplexing the Online Redo Log Oracle recommends that you multiplex the online redo log. Multiplexing provides better protection for data if an instance or media failure occurs. To multiplex your online redo log, you must add members to each online redo log group. It is not required that onlin...
Naming Schema Objects Every object in the database belongs to one schema and has a unique name within that schema. Multiple database objects can share the same name, if they are in different schemas. You can use the schema name to unambiguously refer to objects. For example, hr.employees refers ...
New Features ■ Oracle Enterprise Manager Database Express (EM Express) is the next-generation management tool for administration and management of individual databases that comes with Oracle Database 12c Release 1 (12.1). In previous Or...
Nonpartitioned and Partitioned As with tables, you can partition an index. In most situations, it is useful to partition an index when the associated table is partitioned, and to partition the index using the same partitioning scheme as the table...
Oracle Net Listener Configuration On the database host, the Oracle Net listener (the listener), is a process that listens for client connection requests. It receives incoming client connection requests and manages the traffic of these requests to the database server. The default listener configu...
Overview of Database Backup and Recovery The focus in Oracle Database backup and recovery is on the physical backup of database files, which permits you to reconstruct your database. RMAN, a command-line tool, is the method preferred by ...
Overview of the Oracle Instance and Instance Management An Oracle database system consists of an Oracle database and an Oracle instance (in an Oracle Real Application Clusters environment, there can be more than one instance). A database co...
Partitioned Tables and Indexes You can partition tables and indexes. Partitioning helps to support very large tables and indexes by enabling you to divide the tables and indexes into smaller and more manageable pieces called partitions. SQL queries and DML statements do not have to be modified to...
