'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 11.2.0.3 on RHEL 6.3 w/ASM.
Date: Mon, 10 Mar 2014 15:29:00 -0700
Message-ID: <CALgGkeBxdRdgh+PWDOfKTH++fuOu9wqCxNWj9yH6-twnYD-x9Q_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 10 2014 - 23:29:00 CET