IN_FUL_DPL process is running slow. Has anyone else had this issue?
The SQL that IN_FUL_DPL is stuck on is: select /*+ INDEX(hh I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST) QOSLIVE */ intcol# from sys.wri$_optstat_histhead_history hh where obj# = :1 and savtime = timestamp '4000-12-01 01:00:00 -0:0' order by intcol# asc