Akash Apps DBA corner
Tuesday, 26 December 2017
Thursday, 24 December 2015
Golden gate Administration
Stop OGG
==========================
stop REPLICAT <replicat_name>
stop EXTRACT <extract_name>
stop MANAGER
Start OGG
==========================
start MANAGER
start EXTRACT <extract_name>
start REPLICAT <replicat_name>
Check status
==========================
info MANAGER detail
info EXTRACT <extract_name>
info REPLICAT <replicat_name>
View report file
==========================
view report EXTRACT <extract_name>
view report REPLICAT <replicat_name>
View/edit parameters
==========================
view/edit param EXTRACT <extract_name>
view/edit param REPLICAT <replicat_name>
==========================
Basic Concepts
--------------------------------------------
==========================
stop REPLICAT <replicat_name>
stop EXTRACT <extract_name>
stop MANAGER
Start OGG
==========================
start MANAGER
start EXTRACT <extract_name>
start REPLICAT <replicat_name>
Check status
==========================
info MANAGER detail
info EXTRACT <extract_name>
info REPLICAT <replicat_name>
View report file
==========================
view report EXTRACT <extract_name>
view report REPLICAT <replicat_name>
View/edit parameters
==========================
view/edit param EXTRACT <extract_name>
view/edit param REPLICAT <replicat_name>
==========================
Basic Concepts
--------------------------------------------
Manager
The Manager
process must be running on both the source as well as target systems before the
Extract or Replicat process can be started and performs a number of functions
including monitoring and starting other GoldenGate processes, managing the
trail files and also reporting.
Extract
The Extract
process runs on the source system and is the data caoture mechanism of
GoldenGate. It can be configured both for initial loading of the source data as
well as to synchronize the changed data on the source with the target. This can
be configued to also propagate any DDL changes on those databases where DDL
change support is available.
Replicat
The Replicat
process runs on the target system and reads transactional data changes as well
as DDL changes and replicates then to the target database. Like the Extract
process, the Replicat process can also be configured for Initial Load as well
as Change Synchronization.
Collector
The Collector is a
background process which runs on the target system and is started automatically
by the Manager (Dynamic Collector) or it can be configured to stsrt manually
(Static Collector). It receives extracted data changes that are sent via TCP/IP
and writes then to the trail files from where they are processed by the
Replicat process.
Trails
Trails are series
of files that GoldenGate temporarily stores on disks and these files are
written to and read from by the Extract and Replicat processes as the case may
be. Depending on the configuration chosen, these trail files can exist on the
source as well as on the target systems. If it exists on the local system, it
will be known an Extract Trail or as an Remote Trail if it exists on the target
system.
Data Pumps
Data Pumps are
secondary extract mechanisms which exist in the source configuration. This is
optional component and if Data Pump is not used then Extract sends data via
TCP/IP to the remote trail on the target. When Data Pump is configured, the the
Primary Extract process will write to the Local Trail and then this trail is
read by the Data Pump and data is sent over the network to Remote Trails on the
target system.
In the absence of
Data Pump, the data that the Extract process extracts resides in memory alone
and there is no storage of this data anywhere on the source system. In case of
network of target failures, there could be cases where the primary extract
process can abort or abend. Data Pump can also be useful in those cases where
we are doing complex filtering and transformation of data as well as when we
are consolidating data from many sources to a central target.
Data
source
When processing
transactional data changes, the Extract process can obtain data directly from
the database transaction logs (Oracle, DB2, SQL Server, MySQL etc) or from a
GoldenGate Vendor Access Module (VAM) where the database vendor (for example
Teradata) will provide the required components that will be used by Extract to
extract the data changes.
Groups
To differentiate
between the number of different Extract and Replicat groups which can
potentially co-exist on a system, we can define processing groups. For
instance, if we want to replicate different sets of data in parallel, we can
create two Replicat groups.
A processing group
consisits of a process which could be either a Extract or Replicat process, a
corresponding parameter file, checkpoint file or checkpoint table (for
Replicat) and other files which could be associated with the process.
Tuesday, 2 June 2015
Invalid objects in the E-Business Suite Environment
Invalid
objects in the E-Business Suite Environment
Invalid
objects will appear for several reasons and it is not very easy to identify
invalid objects as the root cause of a failure. In many cases invalid objects
can be identified for failures reported from the functional area or for any misbehavior
identified. In any case you can expect invalid objects, when you have imported
a Database or when you have applied a Patch bringing new PL/SQL Packages. If
you are using adpatch with the Standard options, a compilation of invalid
objects for the APPS Schema is included by default - many DBA's disable this
compilation via "adpatch options=nocompile", to save time. In any
case, it is a good idea to check the E-Business Suite Instance on a regular
basis for invalid objects.
How many invalid objects
are in the Database ?
select
owner,object_type,COUNT(*)
from dba_objects
where status='INVALID'
group by owner, object_type;
from dba_objects
where status='INVALID'
group by owner, object_type;
Check for details about
the invalid objects :
column owner format A9
column object_name format A31
column object_type format A15
column last_ddl_time format A10
spool invalids.lst
select OWNER, OBJECT_NAME,OBJECT_TYPE,LAST_DDL_TIME
from dba_objects where status='INVALID'
order by owner;
column object_name format A31
column object_type format A15
column last_ddl_time format A10
spool invalids.lst
select OWNER, OBJECT_NAME,OBJECT_TYPE,LAST_DDL_TIME
from dba_objects where status='INVALID'
order by owner;
Validating
invalid objects
Manual
compilation of invalid objects:
alter package
<owner>.<name of the package> compile;
alter package <owner>.<name of the package> compile body;
alter view <owner>.<name of the view> compile;
alter alter java class "<owner>.<name of Java Class>" resolve;
alter procedure <owner>.<name of the procedure> compile;
alter function <owner>.<name of the function> compile;
alter materialized view <owner>.<name of the materialized view> compile;
alter package <owner>.<name of the package> compile body;
alter view <owner>.<name of the view> compile;
alter alter java class "<owner>.<name of Java Class>" resolve;
alter procedure <owner>.<name of the procedure> compile;
alter function <owner>.<name of the function> compile;
alter materialized view <owner>.<name of the materialized view> compile;
The script 'adcompsc.pls' under the $AD_TOP/sql :
cd $AD_TOP/sql
sqlplus @adcompsc.pls <SCHEMA_NAME> <SCHEMA_PASSWORD> %
sqlplus @adcompsc.pls <SCHEMA_NAME> <SCHEMA_PASSWORD> %
The script 'utlrp.sql' under the DATABASE
$ORACLE_HOME/rdbms/admin/
* This
script must be run using SQL*PLUS.
* You must be connected AS SYSDBA to run this script.
* There should be no other DDL on the database while running the script.
* You must be connected AS SYSDBA to run this script.
* There should be no other DDL on the database while running the script.
Creating your own compilation script
With the
following script, you will create a new sql-script to compile the invalid
objects, which can be used to compile your individual invalid objects.
set pagesize 0 head off
feedb off echo off
spool validate_all.sql
select 'alter '||object_type||' '||owner||'.'||object_name||' compile;'
from dba_objects where object_type in ('PROCEDURE','FUNCTION','VIEW','TRIGGER','MATERIALIZED VIEW')
and status='INVALID' order by owner
/
select 'alter package '||owner||'.'||object_name||' compile package;'
from dba_objects where object_type in ('PACKAGE')
and status='INVALID' order by owner
/
select 'alter package '||owner||'.'||object_name||' compile body;'
from dba_objects where object_type in ('PACKAGE BODY')
and status='INVALID' order by owner
/
select 'ALTER JAVA SOURCE "' || object_name || '" COMPILE;'
from user_objects where object_type = 'JAVA SOURCE' and status = 'INVALID';
/
select 'ALTER JAVA CLASS "' || object_name || '" RESOLVE;'
from user_objects where object_type = 'JAVA CLASS' and status = 'INVALID';
/
spool off
exit
spool validate_all.sql
select 'alter '||object_type||' '||owner||'.'||object_name||' compile;'
from dba_objects where object_type in ('PROCEDURE','FUNCTION','VIEW','TRIGGER','MATERIALIZED VIEW')
and status='INVALID' order by owner
/
select 'alter package '||owner||'.'||object_name||' compile package;'
from dba_objects where object_type in ('PACKAGE')
and status='INVALID' order by owner
/
select 'alter package '||owner||'.'||object_name||' compile body;'
from dba_objects where object_type in ('PACKAGE BODY')
and status='INVALID' order by owner
/
select 'ALTER JAVA SOURCE "' || object_name || '" COMPILE;'
from user_objects where object_type = 'JAVA SOURCE' and status = 'INVALID';
/
select 'ALTER JAVA CLASS "' || object_name || '" RESOLVE;'
from user_objects where object_type = 'JAVA CLASS' and status = 'INVALID';
/
spool off
exit
Some Questions & Answers
1.
Why do invalid objects occur? What causes them?
Invalid objects can and will occur for many reasons. You will usually find invalid objects after running (or failing to run) database preparation scripts, doing an export/import,
upgrading, or applying patches. Invalid objects are usually caused by missing grants, synonyms, views, tables or packages, but can also be caused by corrupted packages.
2. Why it is important to recompile the invalid objects?
Compiling invalid objects on your database is almost the equivalent of running scandisk on a PC hard drive. This should be one of the first things you check if you start experiencing problems with your Oracle database. It is also a good idea to schedule regular checks for invalid objects.
When you call in to Oracle Support with a database or installation issue, one of the first questions they will probably ask is whether you have checked for and resolved any invalid objects.
3. Are invalid objects ever acceptable? How many is too many?
If the invalid objects exist for a Product that is not installed, it may be OK to have some, but it is preferable to have no invalid objects existing at all. If invalid objects exist
for a Product that you do have installed and are using, then it should be considered unacceptable and any existing invalid objects should be resolved before further issues can occur.
There is no set number of invalid objects that could be considered 'acceptable' as each situation will vary widely from one Installation to the next. You could just have a few invalid objects or they could number in the hundreds or even thousands, but every effort should be made to resolve them.
4. If we do not use the Product with the invalid objects, can we delete them?
In an E-Business Suite Installation are several dependencies between Products and therefore you should never delete any invalid object, if not advised by Metalink Support, that these invalid objects can be deleted.
5. How can I use adadmin to recompile my invalid objects ?
If you don't want to use the methods shown above, you can use adadmin in an E-Business Suite Environment to compile the invalid objects. Please execute following steps to initiate the compilation via 'adadmin':
Invalid objects can and will occur for many reasons. You will usually find invalid objects after running (or failing to run) database preparation scripts, doing an export/import,
upgrading, or applying patches. Invalid objects are usually caused by missing grants, synonyms, views, tables or packages, but can also be caused by corrupted packages.
2. Why it is important to recompile the invalid objects?
Compiling invalid objects on your database is almost the equivalent of running scandisk on a PC hard drive. This should be one of the first things you check if you start experiencing problems with your Oracle database. It is also a good idea to schedule regular checks for invalid objects.
When you call in to Oracle Support with a database or installation issue, one of the first questions they will probably ask is whether you have checked for and resolved any invalid objects.
3. Are invalid objects ever acceptable? How many is too many?
If the invalid objects exist for a Product that is not installed, it may be OK to have some, but it is preferable to have no invalid objects existing at all. If invalid objects exist
for a Product that you do have installed and are using, then it should be considered unacceptable and any existing invalid objects should be resolved before further issues can occur.
There is no set number of invalid objects that could be considered 'acceptable' as each situation will vary widely from one Installation to the next. You could just have a few invalid objects or they could number in the hundreds or even thousands, but every effort should be made to resolve them.
4. If we do not use the Product with the invalid objects, can we delete them?
In an E-Business Suite Installation are several dependencies between Products and therefore you should never delete any invalid object, if not advised by Metalink Support, that these invalid objects can be deleted.
5. How can I use adadmin to recompile my invalid objects ?
If you don't want to use the methods shown above, you can use adadmin in an E-Business Suite Environment to compile the invalid objects. Please execute following steps to initiate the compilation via 'adadmin':
1.
Open
a new Shell and source the APPS User Environment
2.
Start
'adadmin' and pass the values requested for
3.
Select
the menu '3. Compile/Reload Applications Database Entities menu'
4.
Select
the menus '1. Compile APPS schema'
NOTE: Please be aware, that using
adadmin to compile invalid objects, only the invalid objects for APPS will be
compiled.
Tuesday, 7 April 2015
Background Processes in Oracle Database 12c
General
|
|||||
Acronym
|
Process Name
|
Description
|
Required for basic DB
operation
|
Started by default
|
New in this release
|
ABMR
|
Auto BMR Background
Process
|
Coordinates execution
of tasks such as filtering duplicate block media recovery requests and
performing flood control.
|
No
|
No
|
No
|
APnn
|
Logical Standby /
Streams Apply Process Coordinator Process
|
Obtains transactions
from the reader server and passes them to apply servers
|
No
|
No
|
No
|
ARC 0..t
|
Archiver Process (30
possible)
|
Copies the redo log
files to archival storage when they are full or an online redo log switch
occurs
|
No
|
No
|
No
|
BMRn
|
Automatic Block Media
Recovery Slave Pool Process
|
Fetches blocks from a
real-time readable standby database
|
No
|
No
|
No
|
BW nn
|
Database Writer
Process (20 possible)
|
Writes modified blocks
from the database buffer cache to the data files. The names of the 37th
through 100th Database Writer Processes are BW36-BW99. See DBWn for more
information on these processes.
|
Yes
|
Yes
|
Yes
|
CJQ0
|
Job Queue Coordinator
Process
|
Spawns slave processes
(Jnnn) to execute jobs in the queue.
|
No
|
Yes
|
No
|
CKPT
|
Checkpoint Process
|
Signals DBWn at
checkpoints and updates all the data files and control files of the database
to indicate the most recent checkpoint
|
Yes
|
Yes
|
No
|
CPnn
|
Database Capture
Process
|
Captures database
changes from the redo log by using the infrastructure of LogMiner.
|
No
|
No
|
No
|
CSnn
|
Streams Propagation
Sender Process
|
Sends LCRs to a
propagation receiver.
|
No
|
No
|
No
|
CSnn
|
I/O Calibration
Process
|
Issues I/Os to storage
as part of storage calibration. There is one slave process per CPU on each
node of the database.
|
Yes
|
Yes
|
No
|
CTWR
|
Change Tracking Writer
Process
|
Tracks changed data
blocks as part of the Recovery Manager block change tracking feature
|
No
|
No
|
No
|
DBRM
|
Database Resource
Manager Process
|
Sets resource plans
and performs other Resource Manager tasks.
|
No
|
Yes
|
No
|
DBW 0..j
|
Database Writer
Process
|
Writes modified blocks
from the database buffer cache to the data files. There can be 1 to 100
Database Writer Processes. The names of the first 36 Database Writer
Processes are DBW0-DBW9 and DBWa-DBWz. The names of the 37th through 100th
Database Writer Processes are BW36-BW99.
|
Yes
|
Yes
|
No
|
DIA0
|
Diagnostic Process 0
(although 10 possible, only 0 is currently used)
|
Responsible for hang
detection and deadlock resolution. Triggers DIAG to perform diagnostic tasks.
|
Yes
|
Yes
|
No
|
DIAG
|
Diagnostic Capture
Process
|
Performs diagnostic
dumps and executes global oradebug commands.
|
Yes
|
Yes
|
No
|
DMnn
|
Data Pump Master
Process
|
Coordinates the Data
Pump job tasks performed by Data Pump worker processes and handles client
interactions.
|
No
|
No
|
No
|
Dnnn
|
Dispatcher Process
|
In a Shared Server
configuration, dispatchers place connection requests in a connection request
queue.
|
No
|
Yes
|
No
|
DWnn
|
Data Pump Worker
Process
|
Performs Data Pump
tasks as assigned by the Data Pump Master Process.
|
No
|
No
|
No
|
EMNC
|
EMON Coordinator
Process
|
Coordinates the event
management and notification activity in the database, including Streams Event
Notifications, Continuous Query Notifications, and Fast Application Notifications.
Spawns Ennn processes.
|
No
|
No
|
No
|
Ennn
|
EMON Slave Process
|
Performs database
event management and notifications.
|
No
|
No
|
No
|
FBDA
|
Flashback Data
Archiver Process
|
Archives historical
rows for tracked tables into flashback data archives and manages archive
space, organization, and retention
|
No
|
No
|
No
|
FMON
|
File Mapping Monitor
Process
|
Spawns FMPUTL, an
external non-Oracle Database process that communicates with the mapping
libraries provided by storage vendors. Responsible for managing the mapping
information.
|
No
|
No
|
No
|
GEN0
|
General Task Execution
Process
|
Performs required
tasks including SQL and DML.
|
Yes
|
Yes
|
No
|
Innn
|
Disk and Tape I/O
Slave Process
|
Serves as an I/O slave
process spawned on behalf of DBWR, LGWR, or an RMAN backup session.
|
No
|
No
|
No
|
Jnnn
|
Job Queue Slave
Processes
|
Processes jobs in the
queue. Spawned by CJQ0.
|
No
|
Yes
|
No
|
LGn
|
Log Writer Slave
|
On multiprocessor
systems, LGWR creates slave processes to improve the performance of writing
to the redo log. LGWR slaves are not used when there is a SYNC standby
destination.
|
No
|
No
|
Yes
|
LGWR
|
Log Writer Process
|
Writes the log buffer
out to the redo logs.
|
Yes
|
Yes
|
No
|
Lnnn
|
Pooled Server Process
|
Handles client
requests in Database Resident Connection Pooling.
|
No
|
No
|
No
|
LREG
|
Listener Registration
Process
|
LREG notifies the
listeners about instances, services, handlers, and endpoint.
|
Yes
|
Yes
|
Yes
|
MMAN
|
Memory Manager Process
|
Serves as the SGA
Memory Broker and coordinates the sizing of the memory components.
|
No
|
Yes
|
No
|
MMNL
|
Manageability Monitor
Lite Process
|
Performs frequent and
lightweight manageability-related tasks, such as session history capture and
metrics computation.
|
No
|
Yes
|
No
|
MMON
|
Manageability Monitor
Process
|
Collects statistics
for the Automatic Workload Repository.
|
No
|
Yes
|
No
|
Mnnn
|
MMON Slave Process
|
Performs manageability
tasks on behalf of MMON.
|
No
|
No
|
No
|
MSnn
|
LogMiner Worker
Process
|
Reads redo log files
and translates and assembles into transactions.
|
No
|
No
|
No
|
Nnnn
|
Connection Broker
Process
|
Monitors idle
connections and hands off active connections in Database Resident Connection
Pooling
|
No
|
No
|
No
|
OFSD
|
Oracle File Server
Background Process
|
This background
process listens for new file system requests, both management (like mount,
unmount, and export) and I/O requests, and executes them using Oracle
threads.
|
Yes
|
Yes
|
No
|
PMON
|
Process Monitor
|
Recovers failed
process resources. If Shared Server architecture is used, PMON monitors and
restarts any failed dispatcher or server processes.
|
Yes
|
Yes
|
No
|
Pnnn
|
Parallel Query Slave
Process
|
Started and stopped as
needed to participate in parallel query operations.
|
No
|
No
|
No
|
PRnn
|
Parallel Recovery
Process
|
Performs tasks
assigned by the coordinator process performing parallel recovery
|
No
|
No
|
No
|
PSP0
|
Process Spawner
Process
|
Starts and stops
Oracle processes. Reduces workload of RBAL by starting / stopping ASM
rebalance slaves.
|
No
|
Yes
|
No
|
RCBG
|
Result Cache
Background Process
|
Supports SQL query and
PL/SQL function result caches.
|
No
|
No
|
No
|
RECO
|
Recoverer Process
|
Resolves failures
involving distributed transactions.
|
No
|
Yes
|
No
|
RM
|
RAT Masking Slave
Process
|
This background
process is used with Data Masking and Real Application Testing.
|
No
|
Yes
|
Yes
|
RPnn
|
Capture Processing
Worker Process
|
Processes a set of
workload capture files.
|
No
|
No
|
No
|
RPOP
|
Instant Recovery
Repopulation Daemon
|
Responsible for
re-creating and/or repopulating data files from snapshot files and backup
files. The RPOP process is responsible for re-creating and repopulating data
files from snapshots files. It works with the instant recovery feature to
ensure immediate data file access. The local instance has immediate access to
the remote snapshot file's data, while repopulation of the recovered primary
data files happens concurrently. Any changes in the data are managed between
the instance's DBW processes and RPOP to ensure the latest copy of the data
is returned to the user.
|
No
|
No
|
Yes
|
RVWR
|
Recovery Writer
Process
|
Writes flashback data
to flashback database logs in the flash recovery area.
|
No
|
No
|
No
|
SAnn
|
SG Allocator
|
A small fraction of
SGA is allocated during instance startup. The SAnn process allocates the rest
of SGA in small chunks. The process exits upon completion of SGA allocation.
|
No
|
Yes
|
Yes
|
SMCO
|
Space Management
Coordinator Process
|
Coordinates the
execution of various space management related tasks, such as proactive space
allocation and space reclamation.
|
No
|
Yes
|
No
|
SMON
|
System Monitor Process
|
Performs critical
tasks such as instance recovery and dead transaction recovery, and
maintenance tasks such as temporary space reclamation, data dictionary cleanup,
and undo tablespace management
|
Yes
|
Yes
|
No
|
Snnn
|
Shared Server Process
|
In a Shared Server
configuration, shared servers check a connection request queue (populated by
dispatchers) and services the connection requests.
|
No
|
Yes
|
No
|
VKRM
|
Virtual Scheduler for
Resource Manager Process
|
Serves as centralized
scheduler for Resource Manager activity.
|
No
|
Yes
|
No
|
VKTM
|
Virtual Keeper of Time
Process
|
Responsible for
providing a wall-clock time (updated every second) and reference-time counter
(updated every 20ms and available only when running at elevated priority).
|
Yes
|
Yes
|
No
|
Wnnn
|
Space Management Slave
Process
|
These are slave
processes spawned by SMCO to execute space management tasks.
|
No
|
Yes
|
No
|
Exadata
|
|||||
Acronym
|
Process
Name
|
Description
|
Required
for basic DB operation
|
Started
by default
|
New
in this release
|
DSKM
|
Slave
Diskmon Process
|
Acts
as conduit between RDBMS and ASM instances and the Master Diskmon daemon to
communicate I/O Fencing information, I/O Resource Manager Plans, and
Transaction Commit Cache information to Exadata storage. If no Exadata
storage is used, the slave diskmon process will exit silently after startup
of the instance. Only active if Exadata storage is used.
|
No
|
No
|
No
|
XDMG
|
Exadata
Automation Manager
|
Initiates
automation tasks involved in managing Exadata storage
|
No
|
No
|
No
|
XDWK
|
Exadata
Automation Worker
|
Performs
automation tasks requested by XDMG
|
No
|
No
|
No
|
Oracle
Real Application Clusters
|
|||||
Acronym
|
Process
Name
|
Description
|
Required
for basic DB operation
|
Started
by default
|
New
in this release
|
ACMS
|
Atomic
Control File to Memory Server Process
|
Coordinates
consistent updates to a control file resource with its SGA counterpart on all
instances in an Oracle RAC environment
|
No
|
No
|
No
|
GTX
0..j
|
Global
Transaction Process (20 possible)
|
Provides
transparent support for XA global transactions in an Oracle RAC environment.
The database auto tunes the number of these processes based on the workload
of XA global transactions.
|
No
|
No
|
No
|
IPC0
|
IPC
Service Background Process
|
IPC0
handles very high rates of incoming connect requests, as well as, completing
reconfigurations to support basic messaging and RDMA primitives over several
transports such as UDP, RDS, InfiniBand and RC.
|
No
|
No
|
Yes
|
LCKn
|
Lock
Process
|
Manages
the global enqueue requests and the cross-instance broadcast. Handles all
requests for resources other than data blocks.
|
No
|
No
|
No
|
LDDn
|
Global
Enqueue Service Daemon Helper Slave
|
Helps
the LMDn processes with various tasks. LDDn processes are slaves processes
spawned on demand by LMDn processes. They are spawned to help the dedicated
LMDn processes with various tasks when certain workloads start creating
performance bottlenecks.
|
No
|
No
|
Yes
|
LMDn
|
Global
Enqueue Service Daemon Process
|
Manages
enqueue manager service requests for Global Cache Service enqueues to control
access to global enqueues and resources. The LMD process also handles
deadlock detection and remote enqueue requests. Remote resource requests are
the requests originating from another instance.LMDn processes enqueue
resources managed under Global Enqueue Service. In particular, they process
incoming enqueue request messages and control access to global enqueues. They
also perform distributed deadlock detections. There can be up to 36 of these
processes (LMD0-LMDz).
|
No
|
No
|
No
|
LMHB
|
Global
Cache / Enqueue Service Heartbeat Monitor
|
Monitors
the heartbeat of LMON, LMD, and LMSn processes.
|
No
|
No
|
No
|
LMON
|
Global
Enqueue Service Monitor Process
|
Monitors
the entire cluster to manage the global enqueues and the resources. Manages
instance and process failures and the associated recovery for the Global
Cache Service (GCS) and Global Enqueue Service (GES). In particular, LMON
handles the part of recovery associated with global resources. LMON-provided
services are also known as cluster group services (CGS).
|
No
|
No
|
No
|
LMS
0..z
|
Global
Cache Service Process (36 possible)
|
Handles
remote Global Cache Service (GCS) messages. The number of LMS processes
varies depending on the amount of messaging traffic among nodes in the
cluster.
|
No
|
No
|
No
|
PING
|
Interconnect
Latency Measurement Process
|
Assesses
the latencies associated with communications for each pair of instances.
Every few seconds, the process in one instance (INSTANCE_NUMBER value) sends
two messages to each instance (TARGET_INSTANCE value). One message has a size
of 500 bytes and the other has a size of 8 KB. The message is received by the
PING process on the target instance and is immediately acknowledged. The time
for the round-trip is measured and collected.
|
No
|
No
|
No
|
RMSn
|
Oracle
RAC Management Process
|
RMSn
performs a variety of tasks, including creating resources related to Oracle
RAC when new instances are added to a cluster.
|
No
|
No
|
No
|
RSMN
|
Remote
Slave Monitor Process
|
Manages
background slave process creation and communication on remote instances.
|
No
|
No
|
No
|
Oracle
Data Guard
|
|||||
Acronym
|
Process
Name
|
Description
|
Required
for basic DB operation
|
Started
by default
|
New
in this release
|
ASnn
|
Database
Apply Reader or Apply Server
|
As
the Reader Server, computes dependencies between LCRs and assembles messages
into transactions. As the Apply Server, applies LCRs to database objects, or
passes LCRs to the appropriate apply handlers.
|
No
|
No
|
No
|
DMON
|
Data
Guard Broker Monitor Process
|
Starts
when Data Guard Broker is started. The server-side component that interacts
with the local database and the DMON processes of the other databases to
perform the requested function. Also responsible for monitoring the health of
the broker configuration and for ensuring that every database has a
consistent description of the configuration.
|
No
|
No
|
No
|
FSFP
|
Data
Guard Broker Fast Start Failover Pinger Process
|
Observer
process integrated in the DGMGRL client-side component. It monitors the DG
Broker environment and initiates the failover on detecting a problem with
Primary.
|
No
|
No
|
No
|
INSV
|
Data
Guard Broker Instance Slave Process
|
Performs
Data Guard Broker communication between instances of a RAC database.
|
No
|
No
|
No
|
LSP0
|
Logical
Standby Coordinator Process
|
Assigns
transactions to different Data Guard appliers and coordinates among them to
ensure that dependencies between transactions are honored.
|
No
|
No
|
No
|
LSP1
|
Logical
Standby Dictionary Build Process
|
Builds
the data dictionary for the Logical Standby.
|
No
|
No
|
No
|
LSP2
|
Logical
Standby Set Guard Process
|
Maintains
Guard Standby information for the Logical Standby.
|
No
|
No
|
No
|
MRP0
|
Managed
Standby Recovery Process
|
Provides
transparent support for XA global transactions in RAC
|
No
|
No
|
No
|
NSSn
|
Network
Server Sync Process
|
Transfers
redo from current online redo logs to remote standby destinations configured
for SYNC transport
|
No
|
No
|
No
|
NSV
0..9
|
Data
Guard Broker NetSlave Process (10 possible)
|
Performs
broker network communications between databases in a Data Guard
configuration.
|
No
|
No
|
No
|
RSM0
|
Data
Guard Broker Worker Server Process
|
Used
by the DMON process to manage and monitor the database.
|
No
|
No
|
No
|
TMON
|
Transport
Monitor
|
TMON
starts the TMON slave (called the TT processes) and monitors a number of redo
transport processes for hangs and death.
|
No
|
No
|
Yes
|
TTnn
|
Redo
Transport Slave Process
|
Ships
redo from current online and standby redo logs to remote standby destinations
configured for ASYNC transport
|
No
|
No
|
Yes
|
Oracle
Advanced Queuing
|
|||||
Acronym
|
Process
Name
|
Description
|
Required
for basic DB operation
|
Started
by default
|
New
in this release
|
QMNC
|
AQ
Coordinator Process
|
Monitors
message queues. Spawns Qnnn slave processes.
|
No
|
Yes
|
No
|
QMnn
|
AQ
Master Class Process
|
Each
of this type of process represents a single class of work item such as AQ
notification, queue monitors, and cross process.
|
No
|
No
|
No
|
Qnnn
|
AQ
Server Class Process
|
Processes
messages in the Streams AQ queue. Spawned by QMNC.
|
No
|
Yes
|
No
|
Automatic
Storage Management
|
|||||
Acronym
|
Process
Name
|
Description
|
Required
for basic DB operation
|
Started
by default
|
New
in this release
|
ACFS
|
ASM
Cluster File System CSS Process
|
Tracks
the cluster membership in CSS and informs the file system driver of
membership changes.
|
No
|
No
|
No
|
ARB
0..A
|
ASM
Rebalance Process (11 possible)
|
Rebalances
data extents across the ASM file systems.
|
No
|
No
|
No
|
ARSn
|
ASM
Recovery Slave Process (10 possible)
|
The
ASM RBAL background process coordinates and spawns one or more of these slave
processes to recover aborted ASM transactional operations. These processes
run only in the Oracle ASM instance.
|
No
|
No
|
Yes
|
ASMB
|
ASM
Background Process
|
Communicates
with the ASM instance, managing storage and providing statistics
|
No
|
No
|
No
|
B00
0..4
|
ASM
Blocking Slave Process for GMON
|
Performs
maintenance actions on ASM disk groups
|
No
|
No
|
No
|
Bnnn
|
ASM
Blocking Slave Process for GMON
|
Performs
maintenance actions on Oracle ASM disk groups. Bnnn performs actions that
require waiting for resources on behalf of GMON. GMON must be highly
available and cannot wait.
|
No
|
No
|
Yes
|
FENC
|
Fence
Monitor Process
|
Processes
fence requests for RDBMS instances which are using Oracle ASM IOServer
instances
|
No
|
No
|
Yes
|
GMON
|
ASM
Disk Group Monitor Process
|
Maintains
disk membership in ASM disk groups.
|
No
|
No
|
No
|
MARK
|
Mark
AU for Resynchronization Coordinator Process
|
Marks
ASM Allocation Units as stale following a missed write to an offline disk
|
No
|
No
|
No
|
OCFn
|
ASM
CF Connection Pool Process
|
Maintains
a connection to the ASM instance for metadata operations
|
No
|
No
|
No
|
Onnn
|
ASM
Connection Pool Process
|
Maintains
a connection to the ASM instance for metadata operations
|
No
|
No
|
No
|
RBAL
|
ASM
Rebalance Master Process
|
In
an Oracle ASM instance, it coordinates rebalance activity for disk groups. In
a database instances, it manages Oracle ASM disk groups.
|
No
|
No
|
No
|
RMON
|
Rolling
Migration Monitor Process
|
Manages
the rolling migration procedure for an Oracle ASM cluster (The RMON process
is spawned on demand to run the protocol for transitioning an ASM cluster in
and out of rolling migration mode.
|
Yes
|
No
|
Yes
|
Rnnn
|
ASM
Block Remap Slave Process
|
A
database instance reading from an Oracle ASM disk group can encounter an
error during a read. If possible, Oracle ASM asynchronously schedules a Rnnn
slave process to remap this bad block from a mirror copy.
|
No
|
No
|
No
|
SCCn
|
ASM
Disk Scrubbing Slave Check Process
|
SCCn
acts as a slave process for SCRB and performs the checking operations.
|
No
|
No
|
Yes
|
SCRB
|
ASM
Disk Scrubbing Master Process
|
SCRB
runs in an Oracle ASM instance and coordinates Oracle ASM disk scrubbing operations.
|
No
|
No
|
Yes
|
SCRn
|
ASM
Disk Scrubbing Slave Repair Process
|
SCRn
acts as a slave process for SCRB and performs the repairing operations.
|
No
|
No
|
Yes
|
SCVN
|
ASM
Disk Scrubbing Slave Verify Process
|
Performs
Oracle ASM disk scrubbing verify operation. SCVn acts as a slave process for
SCRB and performs the verifying operations. The possible processes are
SCV0-SCV9.
|
No
|
No
|
Yes
|
TEMn
|
ASM
Disk Test Error Emulation Process
|
Emulates
I/O errors on ASM disks through named events.
|
No
|
No
|
No
|
VBGn
|
Volume
Background Process
|
Communicates
between the ASM instance and the operating system volume driver.
|
No
|
No
|
No
|
VDBG
|
Volume
Driver Process
|
Forwards
ASM request to perform various volume-related tasks.
|
No
|
No
|
No
|
VMBO
|
Volume
Membership Process
|
Maintains
cluster membership on behalf of the ASM volume drivers
|
No
|
No
|
No
|
VUBG
|
Volume
drive Umbilicus Background
|
Relays
messages between Oracle ASM instance and Oracle ASM Proxy instance that is
used by ADVM (for ACFS)
|
No
|
No
|
Yes
|
Xnnn
|
ASM
Disk Expel Slave Process
|
Performs
Oracle ASM post-rebalance activities. This process expels dropped disks at
the end of an Oracle ASM rebalance.
|
No
|
No
|
Yes
|
Subscribe to:
Posts (Atom)