I have 2 OEm12c installations. 18.104.22.168 with BP1 as well as 22.214.171.124 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?