Hdr: 14641937 11.2.0.3.2EXADBBP RDBMS 11.2.0.3.2EXADBBP RAC PRODID-5 PORTID-226 Abstract: HIGH WAIT TIME ON "GCS DRM FREEZE IN ENTER SERVER MODE"   *** 09/18/12 08:12 am *** ---- 3-6142228071   PROBLEM: -------- high wait time on "gcs drm freeze in enter server mode".   Subpartition insert statements are behind the waits:   3tg7mr4spz0kb INSERT INTO "T_MERC_TRANSACTION_IN" ("ACTION", "AUDIT_TIME",  "CARD_NO", "ID_MERC_TRANSACTION_IN", "ID_MEREF_CLIENT", "IPADDR",  "MESSAGE_IN", "SERVER_NAME", "STATUS", "TRACKINGID", "TRANS_COUNT",  "TRANS_EXT_ID", "USERID") VALUES (:p3, :p4, :p5,  ID_MERC_TRANSACTION_IN.NEXTVAL, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13,  :p14) 7uhhg1uqrwxyv INSERT INTO "T_MERC_TRANSACTION_OUT" ("AUDIT_TIME",  "ID_MERC_TRANSACTION_IN", "ID_MEREF_CLIENT", "MESSAGE_OUT",  "MT_PROCESS_TIME", "POST_PROCESS_TIME", "PRE_PROCESS_TIME", "STATUS",  "TOTAL_PROCESS_TIME", "USERID") VALUES (:p3, :p4, :p5, :p6, :p7, :p8, :p9,  :p10, :p11, :p12)   DIAGNOSTIC ANALYSIS: -------------------- Server: X2-8 Database Servers: Grid Infrastructure Oracle Grid Infrastructure 11.2.0.3.0 Bundle Patch 13513783 Database Servers: Oracle RDBMS Oracle Database - Enterprise Server Edition 11.2.0.3.0 Bundle Patch 13513783 Storage Servers Exadata Software: Active Image Version 11.2.3.1.0 Operating System Deployed OEL 5.7 LINUX X86-64 OELRHEL 5  2.6.32-300.7.2.el5uek   Bug 12917230 ]- Query with temp table transformation runs slow in RAC (Doc ID  12917230.8) Does not apply.    WORKAROUND: ----------- Possibly  Bug 14618938 - exadata: gcs drm freeze in enter server mode But per BDE of that bug this might cause performance issues in this scenario.   RELATED BUGS: ------------- Bug 14618938 - exadata: gcs drm freeze in enter server mode   REPRODUCIBILITY: ---------------- Steadily at customer site   TEST CASE: ----------   STACK TRACE: ------------   SUPPORTING INFORMATION: -----------------------   24 HOUR CONTACT INFORMATION FOR P1 BUGS: ----------------------------------------   DIAL-IN INFORMATION: --------------------   IMPACT DATE: ------------   *** 09/18/12 08:13 am ***  *** 09/18/12 08:15 am ***  *** 09/18/12 08:15 am *** *** 09/18/12 08:17 am *** *** 09/18/12 08:18 am *** *** 09/18/12 08:19 am *** *** 09/18/12 08:42 am *** *** 09/18/12 09:30 am *** *** 09/18/12 10:07 am *** *** 09/18/12 10:14 am *** *** 09/18/12 10:27 am *** (CHG: Sta->10) *** 09/18/12 10:27 am *** *** 10/01/12 03:10 pm *** (CHG: Sta->16) *** 10/01/12 03:10 pm *** *** 10/02/12 06:08 am *** (CHG: Sta->10) *** 10/02/12 06:08 am *** *** 10/02/12 01:00 pm *** (CHG: Sta->16) *** 10/02/12 01:00 pm *** *** 10/03/12 06:34 am *** (CHG: Sta->10) *** 10/03/12 06:34 am *** *** 10/04/12 01:14 pm *** (CHG: Sta->16) *** 10/04/12 01:14 pm *** *** 10/05/12 11:58 am *** *** 10/05/12 11:58 am *** (CHG: Sta->10) *** 10/08/12 01:19 pm *** (CHG: Sta->16) *** 10/08/12 01:19 pm *** *** 10/09/12 05:52 am *** (CHG: Sta->10) *** 10/09/12 05:52 am *** *** 10/09/12 05:53 am ***  *** 10/10/12 11:11 am *** (CHG: Sta->16) *** 10/10/12 11:11 am *** *** 10/10/12 12:17 pm *** (CHG: Sta->11) *** 10/10/12 12:17 pm *** *** 10/10/12 12:18 pm ***  *** 10/10/12 12:18 pm *** *** 10/10/12 12:19 pm *** *** 10/18/12 07:19 am ***  *** 10/30/12 02:27 pm *** (CHG: Comp. Ver-> 11.2.0.3.2 -> 11.2.0.3....) *** 10/30/12 02:27 pm *** (CHG: RDBMS Ver.-> 11.2.0.3.2 -> 11.2.0.3...) *** 11/19/12 11:39 pm *** (CHG: Sta->30) *** 11/19/12 11:39 pm *** *** 11/20/12 06:29 pm *** (CHG: Sta->11) *** 11/20/12 06:29 pm *** *** 11/22/12 01:50 am *** (CHG: Sta->30) *** 11/22/12 01:50 am *** *** 11/26/12 05:26 pm *** (CHG: Sta->11) *** 11/26/12 05:26 pm *** *** 11/27/12 05:04 am *** *** 11/27/12 09:55 am *** *** 11/27/12 09:56 am *** *** 11/27/12 10:04 am *** *** 11/28/12 01:11 am *** (CHG: Sta->30) *** 11/28/12 01:11 am *** *** 11/28/12 06:07 pm *** *** 11/28/12 06:19 pm *** (CHG: Sta->11) *** 11/28/12 06:19 pm *** *** 11/29/12 01:20 am *** (CHG: Sta->30) *** 11/29/12 01:20 am *** *** 11/29/12 02:36 pm *** (CHG: Sta->11) *** 11/29/12 02:36 pm *** *** 12/03/12 01:31 pm *** *** 12/11/12 12:02 pm *** *** 12/11/12 12:33 pm *** *** 01/08/13 09:14 pm ***  *** 01/12/13 12:32 am *** (CHG: Sta->30) *** 01/12/13 12:32 am *** *** 01/30/13 08:16 pm *** *** 02/05/13 03:41 pm *** (CHG: Sta->33) *** 02/05/13 03:41 pm *** *** 03/14/13 03:03 pm *** *** 04/01/13 11:49 am *** *** 05/30/13 09:43 am *** *** 12/22/13 08:51 pm *** *** 02/05/14 04:35 pm ***