Connecting to an Oracle Database from a Client Computer This section describes how to use SQL*Plus and the easy connect naming method to connect to an Oracle database from a client comput...
Connection Requests Users initiate a connection request by providing a connect string. A connect string includes a user name and password, and a connect identifier. This connect identifier can be the connect descriptor itself, or a name that resolves to the connect descriptor using mapping infor...
Conventions The following text conventions are used in this document: Convention Meaning boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. italic Italic type indicates book titles, emphasis, or placeholder var...
Creating the Backup Script—UNIX and Linux This backup script implements the Oracle suggested backup strategy, enabling quick recovery to any time in the preceding 24 hours. To create the backup script for UNIX and Linux: ■ Start a text editor and create and save a file with the following content...
Custom—This method requires more configuration than the Typical option, but gives you more control over how the database instance uses system memory. This option is meant for more experienced database administrators. You can directly specify memo...
Diagnosing Performance Problems Using ADDM At times, database performance problems arise that require your diagnosis and correction. Usually, these problems are brought to your attention by ADDM, which analyzes data for different time period...
Dropping a Tablespace After a tablespace has been dropped (deleted), the objects and data in it are no longer available. To recover them can be a time-consuming process. Oracle recommends performing a backup before and after dropping a tablespace. To drop a tablespace: 1. In EM Express, from th...
Dynamic Performance Views Dynamic performance views monitor ongoing database activity. They are available only to administrators. The names of dynamic performance views start with the characters V$. For this reason, these views are often ref...
Compressed Tables Table Compression is suitable for both OLTP applications and data warehousing applications. Compressed tables require less disk storage and result in improved query performance due to reduced I/O and buffer cache requirement...
Local Naming The local naming method stores connect descriptors, identified by their net service names, in a client configuration file named tnsnames.ora. This file is located in the ORACLE_HOME/network/admin directory. When you create a database using Oracle Database Configuration Assistant (DB...
