October 18, 2023 - ASRblogger

Voting Disk in Oracle RAC

Voting disks manage information about node membership. Each voting disk must be accessible by all nodes in the cluster for nodes to be members of the cluster1. You can store…

asrblogger October 18, 2023No Comments

Oracle RAC

Oracle Local Registry (OLR) in RAC

Oracle Clusterware includes three components: voting disks, Oracle Cluster Registry (OCR), and Oracle Local Registry (OLR). ■ Voting disks manage information about node membership. Each voting disk must be accessible…

asrblogger October 18, 2023No Comments

Oracle

Oracle Wait Events : ” enq: TM – Contention “

Enqueues are locks that coordinate access to database resources. This event indicates that the session is waiting for a lock that is held by another session. The V$EVENT_NAME view provides…

asrblogger October 18, 2023No Comments

Oracle

Oracle Wait Event : ” db_file_scattered_read “

This wait indicates that we are waiting for a read operation which reads a number of contiguous blocks from disk. In most cases this indicates that there is some form…