Database Tuning (MOSC)

MOSC Banner

write complete wait on global temporary tables

edited Jun 25, 2013 5:12AM in Database Tuning (MOSC) 4 commentsAnswered
Hi All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center