Load-oriented oracle rac wait events

Load-oriented oracle RAC wait events : The load-oriented wait events indicate that a delay in processing has occurred in the GCS, which is usually caused by high load, CPU saturation and would have to be solved by additional CPUs, load-balancing, off loading processing to different times or a new cluster node. For the events mentioned, […]

Read More

Message-Oriented Oracle RAC wait events

Message-Oriented Oracle RAC wait event The message-oriented wait event statistics indicate that no block was received because it was not cached in any instance. Instead, a global grant was given, enabling the requesting instance to read the block from disk or modify it. If the local instance is the resource master, the grant happens immediately.If […]

Read More

Grouping Oracle Rac Wait Events

To determine the amount of work and cost related to inter-instance messaging and contention, examine block transfer rates, remote requests made by each transaction, the number and time waited for global cache events as described under The response time for cache fusion transfers is determined by the messaging and processing times imposed by the physical […]

Read More

Block-Related Oracle Rac Wait Events – Part 2

An event can be anything that Oracle has to perform on behalf of a set of instructions sent by the user interface. The term “wait” is used because every time a user connects to your application, a resource is allocated to perform tasks on its behalf. The waiting comes when a session is waiting for […]

Read More

Block-Related Oracle Rac Wait Events – Part 1

The block-related wait event statistics indicate that a block was received as either the result of a 2-way or a 3-way message, that is, the block was sent from either the resource master requiring 1 message and 1 transfer, or was forwarded to a third node from which it was sent, requiring 2 messages and […]

Read More

Basic on Oracle RAC wait events

Analyzing and interpreting what causes sessions to wait is an important method to determine where time is spent. In Oracle RAC, the wait time is attributed to an event which reflects the exact outcome of a request. For example, when a session on an instance is looking for a block in the global cache, it […]

Read More

Changing password securely in Oracle

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – We are living in the world of username and password life. We all have countless password due to technology’s development. Password plays an important role in our life. Oracle Database leads the industry in security. To maximize the security […]

Read More

ASM -(Sector Disk Drives)

This post is about ASM’s attribute deep knowledge. Before going ahead we must have an idea about the topic. Let’s some line must explain about  ASM -(Sector Disk Drives). The database and Oracle’s Automatic Storage Management (ASM) volume manager explicitly understood 4k devices. In this and subsequent versions of ASM, disk groups created on native mode […]

Read More

ASM Disk Group Attributes

We are the part of RDBMS world. As a student when we entered in the world of RDBMS we learned about the attributes of the entity.  I hope you have the idea what we are going to do in this post.  As the heading of the post explains. Today we are going to have look at ASM Disk […]

Read More

Shutdown mode in Oracle ASM Instance

Being an Oracle DBA we have learned about the db instance in Oracle database. As we know db instance has shutdown mode. In this post, we are going to have look at Oracle ASM Instance. The ASM shutdown process is initiated when you run the SHUTDOWN command in SQL*Plus. While running this command we must ensure […]

Read More