Does flush shared pool really flushes he cursors. ?
I am seeing a strange behavior, Even i after flushing the shared pool. load in v$ SQL is not 0, it increases by 1 since my query goes for hard parse. My understanding is if we flush the shared pool, it will create a new parent and load should be 0. Can someone please help me understand why load is not 0 and where v$ information is stored.
see in the below example, i am running a simple select (select * from departments;). in Column H_Parses value increased to 2 after shared pool flush, does that mean it did not flush the parent or from where it is getting that info.