Locally Managed Tablespaces Space management within a tablespace involves keeping track of available (free) and used space, so that space is allocated efficiently during data insertion and deletion. Locally managed tablespaces keep the space allocation information within the tablespace, not in t...
Managing Undo Data Beginning with Oracle Database 11g, for a default installation, Oracle Database automatically manages the undo data. There is typically no need for database administrator (DBA) intervention. However, if your installati...
Monitoring and Tuning the Database Monitoring the performance of a database and ensuring that it performs optimally is an important task for a database administrator. This chapter discusses the features and functions included in Oracle Datab...
Net Configuration Assistant During a typical database installation, Net Configuration Assistant automatically configures a listener called LISTENER that has a TCP/IP listening protocol address for the database. If you do a custom installation, then Net Configuration Assistant prompts you to conf...
Overview of Database Upgrade Assistant Database Upgrade Assistant (DBUA) guides you through the upgrade process and configures your database for the new release. DBUA automates the upgrade process and makes appropriate recommendations for config...
Prerequisite Steps This window displays the results of the validation checks that DBCA performs to ensure that your system is capable of creating the database with the configuration options you have selected. If any of the validation checks fail, Oracle recommends that you click Back to return t...
Progress The Progress window displays the progress of the database creation operation. When DBCA finishes, it displays the Database Configuration Assistant window, which advises you that database creation is complete. The Database Configuration Assistant window provides information about: ■ The...
Shared Server Mode—This mode allows several client connections to share a database-allocated pool of resources. Use this mode in configurations in which client load is expected to cause a strain on memory and other system resources. If you choose...
SQL Developer SQL Developer provides another GUI for accessing your Oracle database. SQL Developer supports development in both the SQL and PL/SQL languages. It is available in the default installation of Oracle Database. With SQL Developer, you...
Starting DBUA If you install the Oracle Database software only and specify that you are upgrading an existing database to the new Oracle Database release, then DBUA is launched automati...
