Senior Database Administrator

David VanZandt

<div>
AWS RDS will resolve all dead locks automatically. Please refer below site for more details.<br><span style=" text-align: left;">www.bluematador.com/docs/troubleshooting/rds-deadlocks</span>&nbsp;<br><br>
</div>


AWS RDS will resolve all dead locks automatically. Please refer below site for more details.
www.bluematador.com/docs/troubleshooting/rds-deadlocks 



<div>
Pretty sure this wasn't about deadlocks.
</div>


<div>
<p>Ramasamy, thanks for the news. We set up the timeout on row locks for the occasional conflict. The question was, however, intended to get knowledge about CloudWatch -- which was the solution.</p>
</div>


Ramasamy, thanks for the news. We set up the timeout on row locks for the occasional conflict. The question was, however, intended to get knowledge about CloudWatch -- which was the solution.

<div>
<div class="content wysiwyg-content fr-view">
<p>As an Oracle DBA, I am looking to set up an alarm when a prolonged block/lock occurs between database users on an RDS Oracle instance, 19c. I think we're okay once we get the query results into an OS file and copied to an S3 bucket (CloudWatch, Lambda, etc.). My brain is stuck on a SQL method to periodically query for the condition and save it to a result set. I can grasp the idea of throwing an alarm based on metrics patterns, but the dynamic code execution throws me. My PLSQL block looks like:&nbsp;</p><p style="margin-left: 20px;">select count(1)&nbsp;<br id="isPasted">into vCntr&nbsp;<br>from gv$lock l1, gv$session s1, gv$lock l2, gv$session s2<br>where s1.sid=l1.sid and s2.sid=l2.sid<br>and l1.BLOCK=1 and l2.request &gt; 0<br>and l1.id1 = l2.id1<br>and l2.id2 = l2.id2 ;</p>
</div>
</div>



As an Oracle DBA, I am looking to set up an alarm when a prolonged block/lock occurs between database users on an RDS Oracle instance, 19c. I think we're okay once we get the query results into an OS file and copied to an S3 bucket (CloudWatch, Lambda, etc.). My brain is stuck on a SQL method to periodically query for the condition and save it to a result set. I can grasp the idea of throwing an alarm based on metrics patterns, but the dynamic code execution throws me. My PLSQL block looks like: 
select count(1) 
into vCntr 
from gv$lock l1, gv$session s1, gv$lock l2, gv$session s2
where s1.sid=l1.sid and s2.sid=l2.sid
and l1.BLOCK=1 and l2.request > 0
and l1.id1 = l2.id1
and l2.id2 = l2.id2 ;

AWS RDS Oracle -- I need to throw an alarm based upon a SQL query.

Amazon Web Services (AWS), is a collection of remote computing services, also called web services, that make up a cloud-computing platform  operated from 11 geographical regions across the world. The most central and well-known of these services include Amazon Elastic Compute Cloud, also known as "EC2", and Amazon Simple Storage Service, also known as "S3". Other services include Elastic MapReduce (EMR), Route 53 (a DNS web service),  provides a highly available and scalable Domain Name System (DNS) web service, Virtual Private Cloud (VPC), storage, database, deployment and application services.