I have 2 OEm12c installations. 126.96.36.199 with BP1 as well as 188.8.131.52 latest with all performance patches applied. However console performance is slow . Sometime it appear very fast and sometime very very slow. Not able to resolve since last 3 months. As per tracing - "SELECT * FROM EM_TGTNAV_OPEN_SEARCH_XML" is causing issue but this is very fast from DB side, on OMS side looks like issue is there.
Can anyone help? Also am I the only one facing this issue?