Re: row cache lock

Posted by ErmanArslansOracleBlog on Jan 05, 2022; 4:37am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/row-cache-lock-tp10531p10556.html

This trace doesn't represent the same issue. We don't have a significant row cache lock wait there Roshan.
so I guess you shouldn't reproduce the issue..

You got some direct path write temp wait there. But that's for :

SQL ID: 2z9xtas2f76d8 Plan Hash: 0
create table  BIREPORT.TB

I don't see the whole create table statemement, but probably there is a sort there.
Remember those waits; are typically caused by sort operations which cannot be completed in memory.

These types of is generally seen during the following operations:

Index Creation
Aggregation/Group By
Order By SQL's
UNION/Intersect/Minus Operations

Anyways, this is an another case, and it doesn't seem related with the actual one..
But in case if you want to address some direct path write temp, just check the following MOS note:

How to Address High Wait Times for the 'direct path write temp' Wait Event (Doc ID 1576956.1)