write complete wait on global temporary tables
We are on Oracle EBS 11.5.10.2 with 11.1.0.7. OS is HPUX ia64.
We are seeing lots of 'write complete wait' event in the system and it's coming sporadically to users.
We further observed that it's coming on global temporary tables. See below:
SQL> select distinct a.object_name, a.object_type
from dba_objects a, dba_hist_active_sess_history b
where a.object_id = b.current_obj#
and b.event = 'write complete waits'
and a.object_type = 'TABLE';
OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
FND_CONC_RELEASE_CLASSES TABLE
HXC_TK_GROUPS TABLE
JTF_TASKS_B TABLE
XXINFC_ERR_RECORDS TABLE