Hi,
Unfortunately I dont have this information as the issue happened almost a month back.
We need a couple of things
1) The SQL for SQL_ID 4d7vq4q1vj56w
(select sql_fulltext from v$sql where sql_id = '4d7vq4q1vj56w ')
2) The type of block
select event from v$session where sid in ( [the sids that are blocked] )
Hi, I hope you are well and healthy in these uncertain times.
We have a Oracle 12c database, non pdb, with two schemas. Each Schema is used by different application. It was found that although used by different apps with no matching object names, one schema was blocking session from another schema. Schema names are COBRA and CMPL_PRD. COBRA is also blocking SYS. Please suggest why schema for totally different apps may block another schema.
Blocking sessions Details :
BLOCKING_STATUS
------------------------------------------------------------------------------------------------------------------------------------
COBRA@sccob02 ( SID=335:21452: ) is blocking COBRA@sccob03 ( SID=388:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=335:21452: ) is blocking COBRA@sccob02 ( SID=388:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=335:21452: ) is blocking COBRA@sccob03 ( SID=205:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob03 ( SID=1292:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob03 ( SID=973:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob03 ( SID=844:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob03 ( SID=906:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking SYS@scsogdb04 ( SID=906: )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob02 ( SID=645:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob03 ( SID=388:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob02 ( SID=388:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking COBRA@sccob03 ( SID=387:4d7vq4q1vj56w )
COBRA@sccob02 ( SID=590:11902: ) is blocking CMPL_PRD@scwacz215 ( SID=387: )