Database – Page 42

ARC 0..t or Redo Log Archiveback,”Writes filled redo logs to the archive log destination(s). It is known as the archiver, The archiver process (ARCn) copies online redo log files to a designated storage device after a log switch has occurred. ARCn processes are present only when the database is in ARCHIVELOG mode, and automatic archiving is enabled.An Oracle instance can have up to 10 ARCn processes (ARC0 to ARC9). The LGWR process starts a new ARCn process whenever the current number of ARCn processes is insufficient to handle the workload. The alert file keeps a record of when LGWR starts a new ARCn process.If you anticipate a heavy workload for archiving, such as during bulk loading of data, you can specify multiple archiver processes with the initialization parameter LOG_ARCHIVE_MAX_PROCESSES. The ALTER SYSTEM statement can change the value of this parameter dynamically to increase or decrease the number of ARCn processes. However, you do not need to change this parameter from its default value of 1, because the system determines how many ARCn processes are needed

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.ARC 0..t or Redo Log[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.VKRM or Virtual Schedular for[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.RVWR or Recovery Writerback RVWR[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.VKTM or Virtual keeper of[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Tangible cost A cost associated[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Walkthrough A peer group review[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.OLAP(Online Analytical Processing),”Used for analyzing[…]