Politechnika Śląska - strona 117

Setting the Datafile for a Smallfile Tablespace to Automatically Extend This section explains how to set a datafile for a smallfile tablespace to automatically extend when it reaches its size limit. The following instructions assume that the datafile was previously not an autoextending datafile. ...

Shutting Down and Starting Up Using SQL*Plus You can shut down and start the Oracle instance using SQL*Plus. To shut down and start the Oracle instance using SQL*Plus: 1. Start SQL*Plus and connect to the database. See "Shutting Down and Starting Up Using SQL*Plus" on page 5-8. 2. Iss...

Shutting Down and Starting Up Using the Windows Services Program On Microsoft Windows, you can also start and shut down your Oracle database using the Services program in Control Panel. You must start or stop the following services: ■ OracleServiceSID, which is your Oracle instance. ■ OracleORAC...

Software Installation Directories You must specify the directory in which the Oracle Database software is installed, or the location where the product binary files are copied from the installation media. You must choose a location that h...

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...