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 process


1 to 20 of 7047 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Static SQL

The OPEN statement opens an explicit cursor, allocates database resources to process the associated…it with the OPEN statement, which does the following: Allocates database resources to process the

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

Viewing Rebalance Process Related Data

Viewing Rebalance Process Related DataTo view rebalance process-related data, including the number of participating instances on the … the link. Information on the rebalance process, along with details on the number of participating

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Multiprocess and Multithreaded Oracle Database Systemsprocess for each connected user or one or more processes shared by multiple users. Most databases … simultaneously. Each process in a database instance performs a specific job. By dividing the work of … runs in process mode. You must set the THREADED_EXECUTION initialization parameter to TRUE to run … processes (with each process

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Overview of Client Processesclient process (sometimes called a user process ) to run the user application. The client

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Automatic Workload Repository AWR is a repository of historical performance data that includes cumulative…Manageability Monitor Processes (MMON and MMNL) The manageability monitor process (MMON) performs … modified SQL objects. The manageability monitor lite process (MMNL) writes statistics from the Active

Database Concepts, 12c Release 1 (12.1)

Process Architecture

15 Process ArchitectureThis chapter discusses the processes in an Oracle database. This chapter contains the following sections: Introduction to Processes Overview of Client Processes Overview of Server Processes Overview of Background Processes

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Client and Server Processesinstance. The Oracle processes servicing the client process can read from and write to the SGA … , whereas the client process cannot. A client process can run on a host other than the database host … client process: % ps -ef | grep -e sample -e sqlplus | grep -v grep clientuser 29437 29436 0 15:40 … sample shows

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Connections and SessionsA database connection is a physical communication pathway between a client process and a database … communication mechanisms or network software. Typically, a connection occurs between a client process … and a server process or dispatcher, but it can also occur between a client process and Oracle … connections,

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Shared Server ProcessesIn shared server connections, client applications connect over a network to a dispatcher process … , not a server process. For example, 20 client processes can connect to a single dispatcher process … . The dispatcher process receives requests from connected clients and puts them into a request queue in … the

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Mandatory Background Processesfile. This section describes the following mandatory background processes: Process Monitor Process … (PMON) Listener Registration Process (LREG) System Monitor Process (SMON) Database Writer Process (DBW … ) Log Writer Process (LGWR) Checkpoint Process (CKPT) Manageability

Database Concepts, 12c Release 1 (12.1)

Process Architecture

The Oracle Net Listener the listener is a server-side process that listens for incoming client connection…Process Monitor Process (PMON) The process monitor (PMON) monitors the other background processes … and performs process recovery when a server or dispatcher process terminates abnormally. PMON is … responsible for cleaning up the database buffer cache and freeing resources that the client process

Database Concepts, 12c Release 1 (12.1)

Process Architecture

The online redo log for a database instance is called a redo thread.Log Writer Process (LGWR) The log writer process (LGWR) manages the online redo log buffer. LGWR

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Introduction to ProcessesA process is a mechanism in an operating system that can run a series of steps. The processprocess is a thread of execution within a process. On Linux and UNIX, an Oracle process is either an … operating system process or a thread within an operating system process.

Database Concepts, 12c Release 1 (12.1)

Process Architecture

A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle…Checkpoint Process (CKPT) The checkpoint process (CKPT) updates the control file and data file … . Figure 15-4 Checkpoint Process Description of \"Figure 15-4 Checkpoint Process\" See Also: \" Overview of Checkpoints \"

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Slave ProcessesFlashback Data Archive Process (FBDA) The flashback data archive process (FBDA) archives historical … table commits, this process stores the pre-image of the changed rows into the Flashback Data … for space, organization, and retention. Additionally, the process keeps track of how long the … archiving of tracked

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Dedicated Server Processesprocess. On Linux, 20 client processes connected to a database instance are serviced by 20 server … processes. Each client process communicates directly with its server process. This server process is … dedicated to its client process for the duration of the session. The server process

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Types of Processesfollowing types: A client process runs the application or Oracle tool code. An Oracle process is a … process can be an operating system process or a thread within an operating system process. Oracle … processes include the following subtypes: A background process starts with the database

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Database OperationsIn the context of database monitoring, a database operation is a logical entity that includes a SQL statement, a PL/SQL block, or a composite of the two. A simple database operation is either a single SQL statement, or a single PL/SQL procedure or function. A composite database operation is activity between two points in time in a single database session. You can divide a large set of tasks into database

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Overview of Background Processesfor multiple users. Each background process has a separate task, but works with the other processes … . For example, the LGWR process writes data from the redo log buffer to the online redo log. When a … filled redo log file is ready to be archived, LGWR signals another process to archive the redo log … V$PROCESS

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Optional Background ProcessesRecoverer Process (RECO) In a distributed database, the recoverer process (RECO) automatically … resolves failures in distributed transactions. The RECO process of a node automatically connects to … systems Optional Background Processes An optional background process is any background process not