Identity Management (MOSC)

MOSC Banner

OID 11.1.1.2 consume high cpu

edited Mar 17, 2015 10:00AM in Identity Management (MOSC) 1 commentAnswered

Dear Expert,

System hang, CPU utilization rate become 100%. This issue occur every 3or4 days after fully restart the system.

Analyzing awr report, ash reportand and nmon when the problem arise.we found sql that cause cpu run out.
9pw374g7gfm6t
SELECT /*+ USE_NL(store) INDEX(store EI_ATTRSTORE) FIRST_ROWS */ store.entryid, store.attrname, NVL(store.attrval, ' '), NVL(store.attrstype, ' ') FROM ds_attrstore store, ( SELECT t2.entryid FROM ( SELECT t1.entryid, rownum as row_num FROM ( SELECT /*+ FIRST_ROWS */ dn.entryid FROM ct_dn dn WHERE dn.entryid IN ( (SELECT /*+ INDEX( at1 VA_objectclass ) */ at1.entryid FROM CT_objectclass at1, CT_orclisenabled at2 WHERE at1.attrvalue = 'person_tsingtao' AND at2.attrvalue

Tagged:

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center