When will the x$tables or gv$views get refreshed or reloaded
I am asking this question because, when i flushed shared pool i still data related to my sqlid in gv$sql_monitor.
SQL> select count(*) from gv$sql_monitor where sql_id='xxxxxxxx'; COUNT(*) ---------- 16 1 row selected. SQL> alter system flush shared_pool; System altered. SQL> select count(*) from gv$sql_monitor where sql_id='xxxxxxxxxxxxxxxx'; COUNT(*) ---------- 16 1 row selected.
My understanding was that most the gv$ views will be flushed, is there way to check when this gv$ will be flushed or reloaded. ?