The post provides information on new background processes introduced in 12c. Background ProcessDescription BWnnDatabase Writer Processes FENCFence Monitor Process IPC0IPC Service Background Process LDDnGlobal Enqueue Service Daemon Helper Slave LGnnLog Writer Worker LREGListener Registration Process OFSDOracle File Server Background Process RPOPInstant Recovery Repopulation Daemon SAnnSGA Allocator SCRBASM Disk Scrubbing Master Process SCRnASM Disk Scrubbing Slave … [Read more...] about New Background Processes In Oracle Database 12c
oracle 12c
Understanding Oracle Database Automatic SGA Memory Tuning
In Oracle Database 10g, Automatic Shared Memory Management (ASMM) feature is introduced to automatically determine the size of Database buffer cache (default pool), Shared Pool, Large pool and Java pool (starting with 10gR2, the streams pool is included) by setting the parameter SGA_TARGET. This feature reduces the tasks like dynamically analyzing the database workload and redistribute memory across the SGA pools. Benefits of Automatic Shared Memory Management Automatic Shared Memory … [Read more...] about Understanding Oracle Database Automatic SGA Memory Tuning
Understanding Oracle Background Processes
Oracle Background Processes The background processes of the Oracle instance manage memory structures, asynchronously perform I/O to write data to a file on a disk, and perform general maintenance tasks. An Oracle database system consists of an Oracle database and an Oracle instance. The database consists of a set of disk files that store user data and metadata, while the Oracle/database instance contains the set of Oracle Database background processes that operate on the stored data and the … [Read more...] about Understanding Oracle Background Processes
How to create password file for Database on 12c ASM diskgroup
The compatible.asm disk group attribute must be set to 12.1 or higher for the disk group where the password is to be placed. Steps 1. Create the password file using the following command. Go to the asmcmd command prompt and run : $ asmcmd ASMCMD> pwcreate --dbuniquename [dbuniquename] [file_path] [sys-password] Here, The --dbuniquename string option identifies the database unique name associated with the password file. The file_path value identifies the location where the password … [Read more...] about How to create password file for Database on 12c ASM diskgroup