SQL Performance (MOSC)

MOSC Banner

When will the x$tables or gv$views get refreshed or reloaded

in SQL Performance (MOSC) 6 commentsAnswered ✓

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. ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center