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
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
Viewing Rebalance Process Related Data → To 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
Multiprocess and Multithreaded Oracle Database Systems → process 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
Overview of Client Processes → client process (sometimes called a user process ) to run the user application. The client
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
15 Process Architecture → This 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
Client and Server Processes → instance. 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
Connections and Sessions → A 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,
Shared Server Processes → In 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
Mandatory Background Processes → file. 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
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
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
Introduction to Processes → A process is a mechanism in an operating system that can run a series of steps. The process … process 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.
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 \"
Slave Processes → Flashback 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
Dedicated Server Processes → process. 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
Types of Processes → following 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 Operations → In 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
Overview of Background Processes → for 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
Optional Background Processes → Recoverer 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