(All recent versions of SQL Developer including 19.2)
When I see a query or DML in the "Real Time SQL Monitor" pane (running or finished), no matter what I do, I never see the execution plan in the "PLAN STATISTICS" tab.
Turning on the statement log, I see repeated calls and one of the two types I see does NOT run when I try to run it manually:
WITH ACTIVE_SESSION_HISTORY AS (
. . .
FROM
sql\_monitor m,
sql\_plan\_monitor p,
sql\_plan\_monitor\_limits l
WHERE
m.key = p.key
AND m.key = l.key
AND m.sql\_id = :sqlid
AND m.sql\_exec\_id = :sqlexecid
AND m.sql\_exec\_start = **:sqlexecstart**;
-- "sqlId"="35kxyv0gkpwy7", "sqlExecStart"="2019-08-07 10:47:50.0", "sqlExecId"=33554433
If I take that SQL statement and change the last line to this, it runs fine.
AND m.sql_exec_start = to_timestamp('2019-08-07 11:19:13.0','YYYY-MM-DD HH24:MI:SS.XFF');
I have all my SD date formats set back to default as DD-MON-RR but even after restarting SD, still happens. Where is SD getting that timestamp format from?
