How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Creating Shared Database Links → To create a shared database link, use the keyword SHARE D in the CREATE DATABASE LINK statement … : CREATE SHARED DATABASE LINK dblink_name [CONNECT TO username IDENTIFIED BY password]|[CONNECT TO … AUTHENTICATED BY clause must exist in the remote database and must be granted at least the CREATE SESSION … database
Managing Database Links → This section contains the following topics: Closing Database Links Dropping Database Links Limiting the Number of Active Database Link Connections
Creating Global Database Links → In earlier releases, you defined global database links in the Oracle Names server. The Oracle Names … by net service names. In this document these are what are referred to as global database links. See … the Oracle Database Net Services Administrator's Guide to learn how to create directory entries that act as global database
Creating Database Links → You create a database link with the statement CREATE DATABASE LINK. The statement lets you specify … this information about the database link: The name of the database link The database connect string … to access the remote database The username and password to connect to the remote
Distributed Database Administration → The following sections explain some of the topics relating to database management in an Oracle … Database distributed database system: Site Autonomy Distributed Database Security Auditing Database … Links Administration Tools See Also: Chapter 30, \"Managing a Distributed Database\"
Database Administrator Authentication → As a DBA, you often perform special operations such as shutting down or starting up a database … . Because only a DBA should perform these operations, the database administrator usernames require a … Selecting an Authentication Method for Database Administrators Using Operating System Authentication Using Password File Authentication
Distributed Database Security → The database supports all of the security features that are available with a non-distributed … database environment for distributed database systems, including: Password authentication for users and … configuring an Oracle Database distributed database system: Authentication Through Database
Authentication Through Database Links → Database links are either private or public, authenticated or non-authenticated. You create public … : CREATE PUBLIC DATABASE LINK foo USING 'sales'; You create authenticated links by specifying the … CONNECT TO clause, AUTHENTICATED BY clause, or both clauses together in the database link creation … statement. For example, you
Starting Up a Database → Star ting Up a Database When you start up a database, you create an instance of that database and … you determine the state of the database. Normally, you start up an instance by mounting and opening … the database. Doing so makes the database available for any valid user to connect
Altering Database Availability → You can alter the availability of a database. You may want to do this in order to restrict access … for maintenance reasons or to make the database read only. The following sections explain how to … alter the availability of a database: Mounting a Database to an Instance Opening a Closed Database
Database Link Name Resolution → A global object name is an object specified using a database link. The essential components of a … global object name are: Object name Database name Domain The following table shows the components of … an explicitly specified global database object name: Statement Object Database Domain SELECT * FROM … Whenever
Dropping Database Links → You can drop a database link just as you can drop a table or view. If the link is private, then it … must be in your schema. If the link is public, then you must have the DROP PUBLIC DATABASE LINK … system privilege. The statement syntax is as follows, where dblink is the name of the link: DROP [PUBLIC] DATABASE LINK dblink;
Major Database Release Number → The first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.
Client/Server Database Architecture → A database server is the Oracle software managing a database, and a client is an application that … databases. Each node in a distributed database system can act as a client, a server, or both … , depending on the situation. In Figure 29-2, the host for the hq database is acting as a database server
Quiescing a Database → Quiescing a D atabase Occasionally you might want to put a database in a state that allows only DBA … running in the system. Note: In this discussion of quiesce database, a DBA is defined as user SYS or … QUIESCE DATABASE statement or proceed after the database is quiesced. The quiesced state lets … database
Defining Database Services → This section describes database services and includes the following topics: Deploying Services … Configuring Services Using Services Database services (services) are logical abstractions for managing … workloads in Oracle Database. Services divide workloads into mutually disjoint groupings. Each … database service
29 Distributed Database Concepts → In this chapter: Distributed Database Architecture Database Links Distributed Database … Administration Transaction Processing in a Distributed System Distributed Database Application Development Character Set Support for Distributed Environments
Shutting Down a Database → To initiate database shutdown, use the SQL*Plus SHUTDOWN command. Control is not returned to the … session that initiates a database shutdown until shutdown is complete. Users who attempt connections … - connection is not permitted Note: You cannot shut down a database if you are connected to the … database through
Auditing Database Links → You must always perform auditing operations locally. That is, if a user acts in a local database … and accesses a remote database through a database link, the local actions are audited in the local … database, and the remote actions are audited in the remote database, provided appropriate audit options
Creating Public Database Links → To create a public database link, use the keyword PUBLIC (where link_name is the global database … name or an arbitrary link name): CREATE PUBLIC DATABASE LINK link_name...; Following are examples of … public database links: SQL Statement Result CREATE PUBLIC DATABASE LINK supply.us.acme.com; A public
Distributed Database Architecture → A distributed database system allows applications to access data from local and remote databases … . In a homogenous distributed database system, each database is an Oracle Database. In a heterogeneous … distributed database system, at least one of the databases is not an Oracle Database.
Heterogeneous Distributed Database Systems → In a heterogeneous distributed database system, at least one of the databases is a non-Oracle … Database system. To the application, the heterogeneous distributed database system appears as a single … , local, Oracle Database. The local Oracle Database server hides the distribution and heterogeneity
Opening a Closed Database → You can make a mounted but closed database available for general use by opening the database. To … open a mounted database, use the ALTER DATABASE statement with the OPEN clause: ALTER DATABASE OPEN … ; After executing this statement, any valid Oracle Database user with the CREATE SESSION
Creating Private Database Links → To create a private database link, specify the following (where link_name is the global database … name or an arbitrary link name): CREATE DATABASE LINK link_name...; Following are examples of private … database links: SQL Statement Result CREATE DATABASE LINK supply.us.acme.com; A private link using
Distributed Database Management → Part V Distributed Database Management Part V discusses the management of a distributed database … environment. It contains the following chapters: Chapter 29, \"Distributed Database Concepts\" Chapter … 30, \"Managing a Distributed Database\" Chapter 31, \"Developing Applications for a Distributed … Database
CREATE DATABASE LINK → Purpose Use the CREATE DATABASE LINK statement to create a database link. A database link is a … schema object in one database that enables you to access objects on another database. The other database … need not be an Oracle Database system. However, to access non-Oracle
Database Maintenance Release Number → The second digit represents a maintenance release level. Some new features may also be included.
Homogenous Distributed Database Systems → A homogenous distributed database system is a network of two or more Oracle Databases that reside … local database mfg can retrieve joined data from the products table on the local database and the dept … table on the remote hq database. For a client application, the location and platform of the … database
Planning for Database Creation → Prepare to create the database by research and careful planning. Table 2-1 lists some recommended … actions: Table 2-1 Database Planning Tasks Action Additional Information Plan the database tables and … indexes and estimate the amount of space they will require. Part II, \"Oracle Database Structure … your database
7 Monitoring Database Operations → It is important that you monitor the operation of your database on a regular basis. Doing so not … understanding of the normal operation of your database. Being familiar with normal behavior in turn helps
Guaranteeing Global Database Consistency → that uniquely identifies a committed version of the database. In a distributed system, the SCNs of … using the path described by one or more database links A distributed SQL statement executes A … , global time-based recovery can also be completed. During the prepare phase, the database determines
Using Shared Database Links → Every application that references a remote server using a standard database link establishes a … connection between the local database and the remote database. Many users running applications … simultaneously can cause a high number of connections between the local and remote databases. Shared database … Database
Creating Database Links → To support application access to the data and schema objects throughout a distributed database … system, you must create all necessary database links. This section contains the following topics … : Obtaining Privileges Necessary for Creating Database Links Specifying Link Types Specifying Link Users
Shrinking Database Segments Online → Oracle Database segment. The benefits of segment shrink are these: Compaction of data leads to better … unused space only above the high water mark. In shrink operations, by default, the database compacts the … LOBs See Also: Oracle Database SQL Language Reference for more information on the ALTER TABLE command … clause. Refer
Specifying Database Block Sizes → The DB_BLOCK_SIZE initialization parameter specifies the standard block size for the database. This … block size is used for the SYSTEM tablespace and by default in other tablespaces. Oracle Database
Configuring Shared Database Links → You can configure shared database links in the following ways: Creating Shared Links to Dedicated Servers Creating Shared Links to Shared Servers
Closing Database Links → If you access a database link in a session, then the link remains open until you close the session … same public link in a local database, then 20 database link connections are open. If 20 users open … sessions and each user accesses a private link, then 20 database link connections are open. If one … user starts
Database Incarnations → A database incarnation is created whenever you open the database with the RESETLOGS option. After … recovery with a backup control file, however, you must open the database with the RESETLOGS option … , thereby creating a new incarnation of the database. The database requires a new incarnation to avoid
Oracle® Database → Performance Tuning Guide 11 g Release 1 (11.1) B28274-02 July 2008 Oracle Database Performance
Oracle® Database → Installation Guide 11 g Release 1 (11.1) for Linux B32002-11 November 2011 Oracle Database
Oracle® Database → Flashback Technology, and user-managed backup and recovery Oracle Database Backup and Recovery User's Guide
Flashback Database → Oracle Database includes the following logical flashback features: Oracle Flashback Query You can … specify a target time and run queries against a database, viewing results as they would have appeared … Database Advanced Application Developer's Guide explains how to use this feature. Oracle Flashback … Database
Creating a Database with the CREATE DATABASE Statement → Using the CREATE DATBASE SQL statement is a more manual approach to creating a database. If you use … the CREATE DATABASE statement, you must complete additional actions before you have an operational … database. These actions include building views on the data dictionary tables and installing standard
Managing a Distributed Database: Examples → This section presents examples illustrating management of database links: Example 1: Creating a … Public Fixed User Database Link Example 2: Creating a Public Fixed User Shared Database Link Example 3 … : Creating a Public Connected User Database Link Example 4: Creating a Public Connected User Shared … Database
Viewing a Global Database Name → Use the data dictionary view GLOBAL_NAME to view the database global name. For example, issue the
Determining the Global Database Name → The global database name consists of the user-specified local database name and the location of the … database within a network structure. The DB_NAME initialization parameter determines the local name … component of the database name, and the DB_DOMAIN parameter, which is optional, indicates the … parameters
Tasks of a Database Administrator → Oracle Database: Task 1: Evaluate the Database Server Hardware Task 2: Install the Oracle Database … Software Task 3: Plan the Database Task 4: Create and Open the Database Task 5: Back Up the Database … Task 6: Enroll System Users Task 7: Implement the Database Design
Suspending and Resuming a Database → file data) and control files. The suspended state lets you back up a database without I/O … interference. When the database is suspended all preexisting I/O operations are allowed to complete and any new … database accesses are placed in a queued state. The suspend command is not specific to an instance … resume normal database
About Oracle Database Background Processes → To maximize performance and accommodate many users, a multiprocess Oracle Database system uses … multiple database programs running for each user process. Background processes asynchronously perform I … /O and monitor other Oracle Database processes to provide increased parallelism for better … performance and reliability. Table
About Database Resident Connection Pooling → Database Resident Connection Pooling (DRCP) provides a connection pool in the database server for … typical Web application usage scenarios where the application acquires a database connection, works … pooled server is the equivalent of a server foreground process and a database session combined. DRCP … process.
Viewing Information About Database Links → The data dictionary of each database stores the definitions of all the database links in the … database. You can use data dictionary tables and views to gain information about the links. This section … contains the following topics: Determining Which Links Are in the Database Determining Which Link Connections Are Open
Database Role Schema Enterprise Users → create the following: A global user in a centralized directory A user in every database that the global … global user solution has the consequence that you must create a user called fred on every database that … need their own schemas, the creation of a separate account in each database for every global user … creates significant
About Creating an Oracle Database → After you plan your database using some of the guidelines presented in this section, you can create … the database with a graphical tool or a SQL command. You typically create a database during Oracle … Database software installation. However, you can also create a database after installation. Reasons
Specifying CREATE DATABASE Statement Clauses → When you execute a CREATE DATABASE statement, Oracle Database performs a number of operations. The … actual operations performed depend on the clauses that you specify in the CREATE DATABASE statement … and the initialization parameters that you have set. Oracle Database performs at least these … operations: Creates
Inserting Records Into the Database → A PL/SQL-only extension of the INSERT statement lets you insert records into database rows, using a
Capacity Planning for Database Objects → Oracle Database provides two ways to plan capacity for database objects: With Enterprise Manager … Manager online help and Oracle Database 2 Day DBA for details on capacity planning with Enterprise … monitor the size of existing database objects. This section discusses those procedures and contains the
30 Managing a Distributed Database → In this chapter: Managing Global Names in a Distributed System Creating Database Links Using Shared … Database Links Managing Database Links Viewing Information About Database Links Creating Location … Transparency Managing Statement Transparency Managing a Distributed Database: Examples
Considerations Before Creating the Database → Database creation prepares several operating system files to work together as an Oracle Database … . You need only create a database once, regardless of how many datafiles it has or how many instances … access it. You can create a database to erase information in an existing database and create a new
Types of Oracle Database Users → The types of users and their roles and responsibilities depend on the database site. A small site … can have one database administrator who administers the database for application developers and users … . A very large site can find it necessary to divide the duties of a database administrator among
Task 9: Tune Database Performance → Optimizing the performance of the database is one of your ongoing responsibilities as a DBA. Oracle … Database provides a database resource management feature that helps you to control the allocation … of resources among various user groups. The database resource manager is described in Chapter 25 … , \"Managing