0 Replies Latest reply: Nov 20, 2012 6:26 AM by mce RSS

    verify data model data masking causes excessive cpu use

    mce
      12.1.0.2.0 EM with data masking, verifying an EBS data model, causes the following, a very high load.

      Has anybody seen this before? I know that 12.1.0.2.0 with EBS is very new (about a week old)


      Start TimeNov 20, 2012 12:23:59 PM     

      Activity (%)     SID     QC SID     User     Program     Service     Plan Hash Value
      11.85     354     
      APPS     OMS     SYS$USERS     3377385921
      11.80     17     
      APPS     OMS     SYS$USERS     3377385921
      11.80     134     
      APPS     OMS     SYS$USERS     3377385921
      11.76     240     
      APPS     OMS     SYS$USERS     3377385921
      11.63     360     
      APPS     OMS     SYS$USERS     3377385921
      11.63     125     
      APPS     OMS     SYS$USERS     3377385921
      11.59     137     
      APPS     OMS     SYS$USERS     3377385921
      10.99     708     
      APPS     OMS     SYS$USERS     3377385921
      6.93     469     
      APPS     OMS     SYS$USERS     3377385921

      urrent Status          ACTIVE
      Serial Number          8039
      DB User Name          APPS
      OS Process ID          2060
      Login Time          Nov 20, 2012 12:06:27 PM
      Login Duration          29:27 (mm:ss)
      Connection Type          DEDICATED
      Type          USER
      Resource Consumer Group          Unavailable

           
      Client


      OS User Name          oracle
      OS Process ID          1234
      Host          xxxxxxx
      Terminal          unknown
      Current Client ID          Unavailable
      Current Client Info          Unavailable

           
      Application


      Current SQL          cx8j3jja07say
      Current SQL Command          SELECT
      Last Call Duration          28:40 (mm:ss)
      SQL Trace          DISABLED
      Current SQL Trace Level          1
      Trace With Wait Information          DISABLED
      Trace With Bind Information          DISABLED
      Open Cursors          3
      Program          OMS
      Service          SYS$USERS
      Current Module          OEM
      Current Action          Unavailable

           
      Contention


      Blocking Session ID          None

           
      Wait


      Current Wait Event          latch: cache buffers chains
      Current Wait Class          Concurrency
      Wait Duration          7 (s)
      P1          address null
      P2          number 150
      P3          tries null
      Object          SYS.SEG$

           
      Other


      Parsing Schema          APPS
      Failover Type          NONE
      Failover Method          NONE
      Failed Over          NO
      PDML Status          DISABLED
      PDDL Status          ENABLED
      PQ Status          ENABLED
      Current Queue Duration          0 (s)


      System: xxxxxx Tue Nov 20 12:31:29 2012
      Load averages: 6.47, 5.16, 3.50
      764 processes: 645 sleeping, 119 running
      Cpu states:
      CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
      0 5.87 98.3% 0.0% 1.5% 0.2% 0.0% 0.0% 0.0% 0.0%
      1 7.51 90.9% 0.2% 8.7% 0.2% 0.0% 0.0% 0.0% 0.0%
      16 6.44 77.7% 0.1% 22.1% 0.1% 0.0% 0.0% 0.0% 0.0%
      17 6.44 98.2% 0.6% 1.2% 0.0% 0.0% 0.0% 0.0% 0.0%
      18 6.24 96.9% 0.0% 3.0% 0.1% 0.0% 0.0% 0.0% 0.0%
      19 6.46 92.1% 0.1% 7.6% 0.2% 0.0% 0.0% 0.0% 0.0%
      25 6.36 98.7% 0.0% 1.2% 0.1% 0.0% 0.0% 0.0% 0.0%
      --- ---- ----- ----- ----- ----- ----- ----- ----- -----
      avg 6.47 93.2% 0.1% 6.5% 0.2% 0.0% 0.0% 0.0% 0.0%

      System Page Size: 4Kbytes
      Memory: 18345032K (8414672K) real, 21465128K (10191460K) virtual, 21254008K free Page# 1/22