Results for database


61 to 120 of 62098 results. Prev  Next
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 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)

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

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)

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)

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)

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

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





Was this page helpful?

Integrated Cloud Applications & Platform Services