BN,
> I wasn't sure where the Blocker loosing his time, Later in the evening , I noticed that there were many ST enqueue locks (no, we are not using LMTS - For all new tables I am pushing LMTS). I am assuming that this could be an issue. Bumped up the next extent size. The tables were large and extents were in 1000s. > > I am also monitoring v$session_wait. Its intermittent and fast. The users complain that they are stuck and if they retry they are back to normal. >
Is your "TEMP" tablespace LMT or Dict? Is it of type temporary or normal? I ask this because you mention ST enqueue and this is held for creating/dropping extents in a dict managed tbs.... You might be mistaking a 'enqueue' wait for a user lock when it is actually waiting for a "system" lock (on FET$ and UET$)....
-- John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W)
Disappointment is always inevitable; Discouragement is invariably optional
** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- //www.freelists.org/webpage/oracle-l