Specifying the Time Period for Which to Display Statistics In the Real-Time: Last Hour mode, the data in the Performance Hub is sourced from Active Session History (ASH). The ASH data is written to disk when the ASH buffer is filled up or af...
Standard (B-tree) and Bitmap A standard, B-tree index contains an entry for each value in the index key along with a disk address of the row where the value is stored. A B-tree index is the default and most common type of index in an Oracle database. A bitmap index uses strings of bits to encaps...
Starting and Stopping the Listener The Oracle listener is set to start automatically whenever the host is restarted. However, when your system encounters unforeseen circumstances, or when you have manually stopped the listener, you can restart i...
Starting DBCA Follow the steps in this section to start DBCA. To start DBCA: 1. Log on to your computer as a member of the administrative group that is authorized to install Oracle Database software and to create and run the database. ...
Starting EM Express To start EM Express, use the EM Express URL provided by DBCA when DBCA configured your database, as described in "Installing Oracle Database Software" on page 2-6. Or, use the following SQL statement to find...
Static Data Dictionary Views The data dictionary views are called static views because they change infrequently, only when a change is made to the data dictionary. Examples of data dictionary changes include creating a new table or granting a privilege to a user. Many data dictionary tables have...
Switching a Log File When a log switch occurs, the log writer (LGWR) process stops writing to the current online redo log group and starts writing to the next available redo log group. After a log switch, the current online redo log group becomes inactive, and the next available online redo log ...
Switching Undo Tablespaces You can switch from one undo tablespace to another. To switch the undo tablespace: 1. Go to the Undo Management Details page, as described in "Viewing Undo Information" on page 6-20. 2.
SYS and SYSTEM Users The following administrative user accounts are automatically created when you install Oracle Database. They are both created with the password that you supplied upon installation, and they are both automatically gran...
SYSDBA and SYSOPER System Privileges SYSDBA and SYSOPER are administrative privileges required to perform high-level administrative operations such as creating, starting up, shutting down, backing up, or recovering the database. The SYSDBA system privilege is for fully empowered database adminis...
