'write complete waits' with unknown SQLID?
- From: Rich <richa03@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Mar 2014 15:29:00 -0700
Hi List,
Oracle 11.2.0.3 on RHEL 6.3 w/ASM.
We see 'write complete waits' from a single session with no SQLID from
OEM...
I see the definition for this wait is at
http://docs.oracle.com/cd/B16240_01/doc/doc.102/e16282/oracle_database_help/oracle_database_wait_bottlenecks_write_complete_waits_pct.html(at
least for 10.2 - I don't see any Oracle documentation on this in the
11.2 set).
Looking at v$session, I see that the file# is a file in a TS which only has
a [securefile] LOB.
How do we determine what is happening with this session and why?
TIA,
Rich
Other related posts:
