'write complete waits' with unknown SQLID?

From: Rich <richa03_at_gmail.com>
Date: Mon, 10 Mar 2014 15:29:00 -0700
Message-ID: <CALgGkeBxdRdgh+PWDOfKTH++fuOu9wqCxNWj9yH6-twnYD-x9Q_at_mail.gmail.com>

Hi List,
Oracle 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?


Received on Mon Mar 10 2014 - 23:29:00 CET

Original text of this message