performance issue, sqlId with Waiting for event "cursor: mutex X" in wait class "Concurrency" & Wai
the attached is the OEM capture.
I then did following to find the bind variables, I had those results:
Name Value Captured DataType
:B1 10365 varchar2(30)
:B1 07215 varchar2(30)
:B1 68895
Then I did trace on those bind variables:
1* SELECT VENDOR_ID FROM PO_VENDORS WHERE SEGMENT1='68895'
SQL> /
Execution Plan
----------------------------------------------------------
Plan hash value: 844487607
--------------------------------------------------------------------------------
-------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU
)| Time |
--------------------------------------------------------------------------------
-------------
| 0 | SELECT STATEMENT | | 1 | 12 | 2 (0
)| 00:00:01 |
| 1 | TABLE ACCESS BY INDEX ROWID| PO_VENDORS | 1 | 12 | 2 (0
)| 00:00:01 |
|* 2 | INDEX UNIQUE SCAN | PO_VENDORS_U3 | 1 | | 1 (0
)| 00:00:01 |
--------------------------------------------------------------------------------
-------------
Predicate Information (identified by operation id):