You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for database


61 to 120 of 62103 results. previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database Administrator's Guide, 11g Release 1 (11.1)

Using Shared Database Links

Creating Shared Database LinksTo 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

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Database Links

Managing Database LinksThis section contains the following topics: Closing Database Links Dropping Database Links Limiting the Number of Active Database Link Connections

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Database Links

Creating Global Database LinksIn 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

Database SQL Language Reference, 11g Release 1 (11.1)

Syntax for Schema Objects and Parts in SQL Statements

Creating Database LinksYou 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Administration

Distributed Database AdministrationThe 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's Guide, 11g Release 1 (11.1)

Database Administrator Authentication

Database Administrator AuthenticationAs 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Administration

Distributed Database SecurityThe 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Administration

Authentication Through Database LinksDatabase 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

Database Administrator's Guide, 11g Release 1 (11.1)

Starting Up a Database

Starting Up a DatabaseStar 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

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Database Availability

Altering Database AvailabilityYou 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 Administrator's Guide, 11g Release 1 (11.1)

Transaction Processing in a Distributed System

Database Link Name ResolutionA 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

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Database Links

Dropping Database LinksYou 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;

Database Administrator's Guide, 11g Release 1 (11.1)

Identifying Your Oracle Database Software Release

Major Database Release NumberThe first digit is the most general identifier. It represents a major new version of the software that contains significant new functionality.

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Architecture

Client/Server Database ArchitectureA 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

Database Administrator's Guide, 11g Release 1 (11.1)

Quiescing a Database

Quiescing a DatabaseQuiescing 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

Database Administrator's Guide, 11g Release 1 (11.1)

Defining Database Services

Defining Database ServicesThis 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Concepts

29 Distributed Database ConceptsIn 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

Database Administrator's Guide, 11g Release 1 (11.1)

Shutting Down a Database

Shutting Down a DatabaseTo 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Administration

Auditing Database LinksYou 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

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Database Links

Creating Public Database LinksTo 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Architecture

Distributed Database ArchitectureA 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.

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Architecture

Heterogeneous Distributed Database SystemsIn 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

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Database Availability

Opening a Closed DatabaseYou 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

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Database Links

Creating Private Database LinksTo 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

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Management

Distributed Database ManagementPart 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

Database SQL Language Reference, 11g Release 1 (11.1)

CREATE DATABASE LINK

CREATE DATABASE LINKPurpose 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 Administrator's Guide, 11g Release 1 (11.1)

Identifying Your Oracle Database Software Release

Database Maintenance Release NumberThe second digit represents a maintenance release level. Some new features may also be included.

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Architecture

Homogenous Distributed Database SystemsA 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

Database Administrator's Guide, 11g Release 1 (11.1)

About Creating an Oracle Database

Planning for Database CreationPrepare 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

Database Administrator's Guide, 11g Release 1 (11.1)

Monitoring Database Operations

7 Monitoring Database OperationsIt 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

Database Administrator's Guide, 11g Release 1 (11.1)

Two-Phase Commit Mechanism

Guaranteeing Global Database Consistencythat 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

Database Administrator's Guide, 11g Release 1 (11.1)

Using Shared Database Links

Using Shared Database LinksEvery 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 databaseDatabase

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Database Links

Creating Database LinksTo 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

Database Administrator's Guide, 11g Release 1 (11.1)

Reclaiming Wasted Space

Shrinking Database Segments OnlineOracle 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

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

Specifying Database Block SizesThe 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

Database Administrator's Guide, 11g Release 1 (11.1)

Using Shared Database Links

Configuring Shared Database LinksYou can configure shared database links in the following ways: Creating Shared Links to Dedicated Servers Creating Shared Links to Shared Servers

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Database Links

Closing Database LinksIf 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 Backup and Recovery User's Guide, 11g Release 1 (11.1)

RMAN Data Repair Concepts

Database IncarnationsA 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

Database Performance Tuning Guide, 11g Release 1 (11.1)

Oracle Database Performance Tuning Guide, 11g Release 1 (11.1)

Oracle® DatabasePerformance Tuning Guide 11 g Release 1 (11.1) B28274-02 July 2008 Oracle Database Performance

Database Installation Guide for Linux, 11g Release 1 (11.1)

Oracle Database Installation Guide, 11g Release 1 (11.1) for Linux

Oracle® DatabaseInstallation Guide 11 g Release 1 (11.1) for Linux B32002-11 November 2011 Oracle Database

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Oracle Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Oracle® DatabaseFlashback Technology, and user-managed backup and recovery Oracle Database Backup and Recovery User's Guide

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Introduction to Backup and Recovery

Flashback DatabaseOracle 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

Database Administrator's Guide, 11g Release 1 (11.1)

Creating a Database with the CREATE DATABASE Statement

Creating a Database with the CREATE DATABASE StatementUsing 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

Database Administrator's Guide, 11g Release 1 (11.1)

Managing a Distributed Database: Examples

Managing a Distributed Database: ExamplesThis 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

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Global Names in a Distributed System

Viewing a Global Database NameUse the data dictionary view GLOBAL_NAME to view the database global name. For example, issue the

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

Determining the Global Database NameThe 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

Database Administrator's Guide, 11g Release 1 (11.1)

Tasks of a Database Administrator

Tasks of a Database AdministratorOracle 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

Database Administrator's Guide, 11g Release 1 (11.1)

Suspending and Resuming a Database

Suspending and Resuming a Databasefile 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

Database Administrator's Guide, 11g Release 1 (11.1)

About Oracle Database Background Processes

About Oracle Database Background ProcessesTo 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

Database Administrator's Guide, 11g Release 1 (11.1)

About Database Resident Connection Pooling

About Database Resident Connection PoolingDatabase 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.

Database Administrator's Guide, 11g Release 1 (11.1)

Viewing Information About Database Links

Viewing Information About Database LinksThe 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 Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Administration

Database Role Schema Enterprise Userscreate 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

Database Administrator's Guide, 11g Release 1 (11.1)

About Creating an Oracle Database

About Creating an Oracle DatabaseAfter 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

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying CREATE DATABASE Statement Clauses

Specifying CREATE DATABASE Statement ClausesWhen 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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using PL/SQL Collections and Records

Inserting Records Into the DatabaseA PL/SQL-only extension of the INSERT statement lets you insert records into database rows, using a

Database Administrator's Guide, 11g Release 1 (11.1)

Capacity Planning for Database Objects

Capacity Planning for Database ObjectsOracle 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

Database Administrator's Guide, 11g Release 1 (11.1)

Managing a Distributed Database

30 Managing a Distributed DatabaseIn 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

Database Administrator's Guide, 11g Release 1 (11.1)

About Creating an Oracle Database

Considerations Before Creating the DatabaseDatabase 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

Database Administrator's Guide, 11g Release 1 (11.1)

Types of Oracle Database Users

Types of Oracle Database UsersThe 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

Database Administrator's Guide, 11g Release 1 (11.1)

Tasks of a Database Administrator

Task 9: Tune Database PerformanceOptimizing 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