SQL & PL/SQL

Hello all ;

I  have little confusion with ivalidations from v$sql;

but i am trying with 2 different users   (hr , rs)  invalidations  always showing '0' - why ??

Usually 'invalidation' tells whether a cursor is invalidated and gets reloaded, which helps us to verify whether a parse call becomes hard parse.

HR>alter system flush shared_pool;

System altered.

HR>select * from tab1 where no=1;

        NO   NAME               EMAIL                                   CITY

       1    hrs          hrs@gmail.com   kolkotta

HR>conn rs/rs

Connected.

RS>select * from tab1 where no=1;

      NO      NAME                EMAIL                                CITY

      1       rs            rs@gmail.com    Atlanda

RS>select sql_id , plan_hash_value, parse_calls , INVALIDATIONS , sql_text from v$sql

  2  where lower(sql_text) like '%tab1%';

SQL_ID                         PLAN_HASH_VALUE         PARSE_CALLS            INVALIDATIONS              SQL_TEXT

1bf26hh7fsa46      2211052296                 1                            0                        select * from tab1 where no=1

1bf26hh7fsa46      2211052296                 1                             0                        select * from tab1 where no=1