🎴 Flashcard Mode
Enterprise Database Systems: AS400, IMS, and Oracle
Card1 / 12
Mastered0
Review0
QuestionClick to flip
How many ARCn processes can be associated with an instance
AnswerClick to flip back
A
ten
💡 Explanation:
Oracle's ARCn (Archiver) processes are responsible for archiving filled redo log files. An instance can have up to 10 ARCn processes (ARC0 through ARC9), though typically only one or two are active. This maximum is defined by the LOG_ARCHIVE_MAX_PROCESSES initialization parameter.